Dataset: SAP Bikes Sales Sample Data

About this Dataset

SAP Bikes Sales Sample Data

Content

SAP bikes store sample dummy sales data for testing and practicing. the files include (Sales orders transactions, Products master data, Prices, Salesman information and more....) It is part of the SAP warehouse cloud content master data for practicing data analytics, ML, AI, Big Data....

Enjoy.

Tables

Addresses

@kaggle.yasinnaal_bikes_sales_sample_data.addresses

11.62 KB
54 rows
12 columns


CREATE TABLE addresses (
  "addressid" BIGINT,
  "city" VARCHAR,
  "postalcode" VARCHAR,
  "street" VARCHAR,
  "building" DOUBLE,
  "country" VARCHAR,
  "region" VARCHAR,
  "addresstype" BIGINT,
  "validity_startdate" BIGINT,
  "validity_enddate" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Businesspartners

@kaggle.yasinnaal_bikes_sales_sample_data.businesspartners

13.14 KB
40 rows
14 columns


CREATE TABLE businesspartners (
  "partnerid" BIGINT,
  "partnerrole" BIGINT,
  "emailaddress" VARCHAR,
  "phonenumber" BIGINT,
  "faxnumber" VARCHAR,
  "webaddress" VARCHAR,
  "addressid" BIGINT,
  "companyname" VARCHAR,
  "legalform" VARCHAR,
  "createdby" BIGINT,
  "createdat" BIGINT,
  "changedby" BIGINT,
  "changedat" BIGINT,
  "currency" VARCHAR
);

Productcategories

@kaggle.yasinnaal_bikes_sales_sample_data.productcategories

2.85 KB
9 rows
3 columns


CREATE TABLE productcategories (
  "prodcategoryid" VARCHAR,
  "createdby" BIGINT,
  "createdat" BIGINT
);

Productcategorytext

@kaggle.yasinnaal_bikes_sales_sample_data.productcategorytext

3.83 KB
9 rows
5 columns


CREATE TABLE productcategorytext (
  "prodcategoryid" VARCHAR,
  "language" VARCHAR,
  "short_descr" VARCHAR,
  "medium_descr" VARCHAR,
  "long_descr" VARCHAR
);

Products

@kaggle.yasinnaal_bikes_sales_sample_data.products

13.18 KB
42 rows
19 columns


CREATE TABLE products (
  "productid" VARCHAR,
  "typecode" VARCHAR,
  "prodcategoryid" VARCHAR,
  "createdby" BIGINT,
  "createdat" BIGINT,
  "changedby" BIGINT,
  "changedat" BIGINT,
  "supplier_partnerid" BIGINT,
  "taxtariffcode" BIGINT,
  "quantityunit" VARCHAR,
  "weightmeasure" DOUBLE,
  "weightunit" VARCHAR,
  "currency" VARCHAR,
  "price" BIGINT,
  "width" VARCHAR,
  "depth" VARCHAR,
  "height" VARCHAR,
  "dimensionunit" VARCHAR,
  "productpicurl" VARCHAR
);

Producttexts

@kaggle.yasinnaal_bikes_sales_sample_data.producttexts

4.98 KB
44 rows
5 columns


CREATE TABLE producttexts (
  "productid" VARCHAR,
  "language" VARCHAR,
  "short_descr" VARCHAR,
  "medium_descr" VARCHAR,
  "long_descr" VARCHAR
);

Salesorderitems

@kaggle.yasinnaal_bikes_sales_sample_data.salesorderitems

21.87 KB
1930 rows
13 columns


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
);

Salesorders

@kaggle.yasinnaal_bikes_sales_sample_data.salesorders

23.22 KB
334 rows
17 columns


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
);