Skip to content

Instantly share code, notes, and snippets.

View weberstephanhd's full-sized avatar

Stephan Weber weberstephanhd

6 followers · 2 following
View GitHub Profile
@weberstephanhd
weberstephanhd / businessPartner.csv
Created April 23, 2014 19:15
SAP HANA Cloud Platform - HANA native "Top Customers" - data/businessPartner.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 7 should actually have 14 columns, instead of 13 in line 6.
0100000000,01,[email protected],0622734567,,http://www.sap.com,1000000034,SAP,AG,0000000033,20121003,0000000033,20121003,EUR
0100000001,02,[email protected],3088530,,http://www.beckerberlin.de,1000000035,Becker Berlin,GmbH,0000000033,20121003,0000000033,20121003,EUR
0100000002,01,[email protected],3023352668,,http://www.delbont.com,1000000036,DelBont Industries,Ltd.,0000000033,20121003,0000000033,20121003,USD
0100000003,01,[email protected],511403266,,http://www.talpa-hannover.de,1000000037,Talpa,GmbH,0000000033,20121003,0000000033,20121003,EUR
0100000004,01,[email protected],2244668800,,http://www.panorama-studios.biz,1000000038,Panorama Studios,Inc.,0000000033,20121003,0000000033,20121003,USD
0100000005,01,[email protected],2511415,,http://www.tecum-ag.de,1000000039,TECUM,AG,0000000033,20121003,0000000033,20121003,EUR
0100000006,01,[email protected],9078563412,,http://www.asia-ht.com,1000000040,Asia High tech,Inc.,0000000033,20121003,0000000033,
@weberstephanhd
weberstephanhd / businessPartner.hdbtable
Last active August 29, 2015 14:00
SAP HANA Cloud Platform - HANA native "Top Customers" - data/businessPartner.hdbtable
table.schemaName = "{{SCHEMA_NAME}}";
table.tableType = COLUMNSTORE;
table.description = "EPM Business Partners";
table.columns = [
{name = "PartnerId"; sqlType = NVARCHAR; nullable = false; length = 10; comment = "Partner ID"; },
{name = "PartnerRole"; sqlType = NVARCHAR; nullable = false; length = 3; comment = "Business Partner Role"; },
{name = "EmailAddress"; sqlType = NVARCHAR; nullable = false; length = 255; comment = "E-Mail Address"; },
{name = "PhoneNumber"; sqlType = NVARCHAR; nullable = false; length = 30; comment = "Business Phone Number"; },
{name = "FaxNumber"; sqlType = NVARCHAR; nullable = true; length = 30; comment = "Business Fax Number"; },
{name = "WebAddress"; sqlType = NVARCHAR; nullable = false; length = 1024; comment = "Web Address"; },
@weberstephanhd
weberstephanhd / .xsaccess
Last active August 29, 2015 14:00
SAP HANA Cloud Platform - HANA native "Top Customers" - .xsaccess
{
"exposed" : true,
"default_file": "index.html"
}