Name: SAP Bikes Sales Sample Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

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.9 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.46 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.92 kB
9 rows
3 columns

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

Productcategorytext

@kaggle.yasinnaal_bikes_sales_sample_data.productcategorytext

3.92 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.49 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

5.1 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

22.39 kB
1,930 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.78 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
);