Baselight

SAP Bikes Sales Sample Data

Bikes Sales sample content from SAP ERP and cloud

@kaggle.yasinnaal_bikes_sales_sample_data

Salesorderitems
@kaggle.yasinnaal_bikes_sales_sample_data.salesorderitems

  • 21.87 KB
  • 1930 rows
  • 13 columns
salesorderid

SALESORDERID

salesorderitem

SALESORDERITEM

productid

PRODUCTID

noteid

NOTEID

currency

CURRENCY

grossamount

GROSSAMOUNT

netamount

NETAMOUNT

taxamount

TAXAMOUNT

itematpstatus

ITEMATPSTATUS

opitempos

OPITEMPOS

quantity

QUANTITY

quantityunit

QUANTITYUNIT

deliverydate

DELIVERYDATE

50000000010MB-1034 USD24992186.625312.375I4EA20180311
50000000020CB-1161 USD399349.12549.875I9EA20180311
50000000110HB-1175 USD899786.625112.375I2EA20180228
50000000120RC-1056 USD24992186.625312.375I2EA20180228
50000000130CC-1021 USD11441001143I3EA20180228
50000000140CB-1161 USD399349.12549.875I6EA20180228
50000000210HB-1175 USD899786.625112.375I6EA20180309
50000000220RC-1055 USD19991749.125249.875I3EA20180309
50000000230DB-1081 USD14991311.625187.375I3EA20180309
50000000240EB-1133 USD22501968.75281.25I10EA20180309

CREATE TABLE salesorderitems (
  "salesorderid" BIGINT,
  "salesorderitem" BIGINT,
  "productid" VARCHAR,
  "noteid" VARCHAR,
  "currency" VARCHAR,
  "grossamount" BIGINT,
  "netamount" DOUBLE,
  "taxamount" DOUBLE,
  "itematpstatus" VARCHAR,
  "opitempos" VARCHAR,
  "quantity" BIGINT,
  "quantityunit" VARCHAR,
  "deliverydate" BIGINT
);

Share link

Anyone who has the link will be able to view this.