Baselight
Sign In

SAP Bikes Sales Sample Data

Bikes Sales sample content from SAP ERP and cloud

@kaggle.yasinnaal_bikes_sales_sample_data

Salesorders
@kaggle.yasinnaal_bikes_sales_sample_data.salesorders

  • 23.22 KB
  • 334 rows
  • 17 columns
salesorderid

SALESORDERID

createdby

CREATEDBY

createdat

CREATEDAT

changedby

CHANGEDBY

changedat

CHANGEDAT

fiscvariant

FISCVARIANT

fiscalyearperiod

FISCALYEARPERIOD

noteid

NOTEID

partnerid

PARTNERID

salesorg

SALESORG

currency

CURRENCY

grossamount

GROSSAMOUNT

netamount

NETAMOUNT

taxamount

TAXAMOUNT

lifecyclestatus

LIFECYCLESTATUS

billingstatus

BILLINGSTATUS

deliverystatus

DELIVERYSTATUS

500000000420180111420180116K42018001100000022APJUSD1358711888.6251698.375CCC
500000001220180112220180115K42018001100000026EMEAUSD1262211044.251577.75CCC
500000002520180115520180120K42018001100000018APJUSD4565539948.1255706.875CCC
500000003320180115320180120K42018001100000009EMEAUSD10178689062.7512723.25CCC
500000004820180116820180117K42018001100000025EMEAUSD7168462723.58960.5CCC
500000005820180116820180119K42018001100000008EMEAUSD10421391186.37513026.625CCC
500000006320180117320180120K42018001100000038EMEAUSD173987152238.62521748.375CCC
500000007420180119420180121K42018001100000020APJUSD13981223.25174.75CCC
500000008320180120320180122K42018001100000028EMEAUSD127803111827.62515975.375CCC
500000009420180121420180122K42018001100000021APJUSD7910169213.3759887.625CCC

CREATE TABLE salesorders (
  "salesorderid" BIGINT,
  "createdby" BIGINT,
  "createdat" BIGINT,
  "changedby" BIGINT,
  "changedat" BIGINT,
  "fiscvariant" VARCHAR,
  "fiscalyearperiod" BIGINT,
  "noteid" VARCHAR,
  "partnerid" BIGINT,
  "salesorg" VARCHAR,
  "currency" VARCHAR,
  "grossamount" BIGINT,
  "netamount" DOUBLE,
  "taxamount" DOUBLE,
  "lifecyclestatus" VARCHAR,
  "billingstatus" VARCHAR,
  "deliverystatus" VARCHAR
);