SAP Bikes Sales Sample Data

Bikes Sales sample content from SAP ERP and cloud

@kaggle.yasinnaal_bikes_sales_sample_data

Table List

8 tables(94.69 KB)

Addresses

@kaggle.yasinnaal_bikes_sales_sample_data.addresses

11.62 KB
54 rows
12 columns

addressid ADDRESSID	city CITY	postalcode POSTALCODE	street STREET	building BUILDING	country COUNTRY	region REGION	addresstype ADDRESSTYPE	validity_startdate VALIDITY STARTDATE	validity_enddate VALIDITY ENDDATE	latitude LATITUDE	longitude LONGITUDE
1000000034	West Nyack	10994	Settlers Lane	5027	US	AMER	2	20000101	99991231	41.100057	-73.973562
1000000035	Fair Oaks	95628	Woodland Terrace	4467	US	AMER	2	20000101	99991231	38.638355	-121.286683
1000000036	Dunn	28334	Layman Avenue	2250	US	AMER	2	20000101	99991231	35.312013	-78.60995
1000000037	Chicago	60605	University Drive	4697	US	AMER	2	20000101	99991231	41.874591	-87.627303
1000000038	Ocala	34471	Bagwell Avenue	1565	US	AMER	2	20000101	99991231	29.183977	-82.118413
1000000039	Callenberg	02681	Kantstraße	56	DE	EMEA	2	20000101	99991231	51.096588	14.433772
1000000040	Trimport	54636	Luetzowplatz	74	DE	EMEA	2	20000101	99991231	49.908759	6.578609
1000000041	Berlin Mariendorf	12107	Brandenburgische Straße	10	DE	EMEA	2	20000101	99991231	52.492245	13.310903
1000000042	Marne	25705	An Der Urania	30	DE	EMEA	2	20000101	99991231	53.952609	9.018139
1000000043	Augsburg	86045	Sonnenallee	43	DE	EMEA	2	20000101	99991231	48.370625	10.893961


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