Skip to content

SAP Data Profiles & Relationships

Home
Getting Started
Source Profiles
Source Profiles
- Source Table Profiles
Marts
Marts
- Mart Profiles
Relationships
Relationships
- Table Relationships
Dependencies & Build Order
Dependencies & Build Order
Data Quality
Data Quality
- Data Quality
- Record Counts
Domains
Domains
- Domain Groupings

Data Profile: sap_technischerplatz¶

Generated: 2025-11-27 00:25:27.560513 Schema: raw_results.sap_technischerplatz Total Rows: 689,003 Columns: 22 Completeness: 99.99%

Source Files¶

File	Rows	Size
sap_technischerplatz.csv	689,003	111.0 MB
Total	689,003	111.0 MB

Column Summary¶

#	Column	Type	PostgreSQL	Nullable	Nulls	Unique
1	OBJECTID	integer	INTEGER	No	0.00%	0
2	recz	integer	INTEGER	No	0.00%	0
3	tplnr	string	VARCHAR(43)	No	0.00%	0
4	lvorm	string	VARCHAR(6)	No	0.00%	0
5	fltyp	string	VARCHAR(1)	No	0.00%	0
6	pltxt	string	VARCHAR(61)	No	0.00%	0
7	eqart	string	VARCHAR(15)	No	0.00%	0
8	prems	string	VARCHAR(10)	No	0.00%	0
9	street	string	VARCHAR(42)	No	0.00%	0
10	house_num1	string	VARCHAR(9)	No	0.00%	0
11	house_num2	string	VARCHAR(6)	Yes	0.14%	0
12	post_code1	string	VARCHAR(7)	No	0.00%	0
13	city1	string	VARCHAR(39)	No	0.00%	0
14	streetcode	string	VARCHAR(9)	No	0.00%	0
15	city_code	string	VARCHAR(6)	No	0.00%	0
16	zzdrmnr	string	VARCHAR(9)	No	0.00%	0
17	zdrmbez	string	VARCHAR(45)	No	0.00%	0
18	zzdrmsch	string	VARCHAR(6)	No	0.00%	0
19	zzdrmsch_bez	string	VARCHAR(36)	No	0.00%	0
20	egid	string	VARCHAR(13)	No	0.00%	0
21	MD_prozessiert	timestamp	TIMESTAMP	No	0.00%	0
22	regiogroup	string	VARCHAR(7)	No	0.00%	0

Detailed Column Profiles¶

1. OBJECTID¶

Type: integer → INTEGER
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	20
Avg Length	0.0
Buffered Length	30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

573183, 573187, 573189, 573054, 573056

2. recz¶

Type: integer → INTEGER
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	20
Avg Length	0.0
Buffered Length	30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

387067, 387081, 387101, 387102, 387108

3. tplnr¶

Type: string → VARCHAR(43)
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	29
Avg Length	0.0
Buffered Length	43 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

X/3658.C6464.0015, X/3658.C6464.0023, X/3658.C6464.0033, X/3658.C6464.0042, X/3658.C6464.0043

4. lvorm¶

Type: string → VARCHAR(6)
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	4
Avg Length	0.0
Buffered Length	6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

NULL, X

5. fltyp¶

Type: string → VARCHAR(1)
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	1
Avg Length	0.0
Buffered Length	1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

A, G, T

6. pltxt¶

Type: string → VARCHAR(61)
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	41
Avg Length	0.0
Buffered Length	61 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

NULL, Haupthahn / Hausregler, Haupthahnen / Hausregler, Pestalozzistrasse 20, Pestalozzistrasse 35

7. eqart¶

Type: string → VARCHAR(15)
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	10
Avg Length	0.0
Buffered Length	15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

NULL, Y-ERDGAS, Y-ÖL, Y-FERNW, Y-PELLETS

8. prems¶

Type: string → VARCHAR(10)
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	7
Avg Length	0.0
Buffered Length	10 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

NULL, 2010304, 1019920, 1005742, 1005741

9. street¶

Type: string → VARCHAR(42)
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	28
Avg Length	0.0
Buffered Length	42 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

NULL, Seestrasse, Dorfstrasse, Hauptstrasse, Kappelenring

10. house_num1¶

Type: string → VARCHAR(9)
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	6
Avg Length	0.0
Buffered Length	9 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

1, 2, 4, 3, 5

11. house_num2¶

Type: string → VARCHAR(6)
Nullable: Yes

Metric	Value
Total Rows	689,003
Non-null	688,036 (99.9%)
Null	967 (0.14%)
Unique	0 (0.0%)
Min Length	0
Max Length	4
Avg Length	0.0
Buffered Length	6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

NULL, a, b, c, d

12. post_code1¶

Type: string → VARCHAR(7)
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	5
Avg Length	0.0
Buffered Length	7 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

4900, 8001, 8280, 3110, 4600

13. city1¶

Type: string → VARCHAR(39)
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	26
Avg Length	0.0
Buffered Length	39 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

NULL, Zürich, Winterthur, Adliswil, Stäfa

14. streetcode¶

Type: string → VARCHAR(9)
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	6
Avg Length	0.0
Buffered Length	9 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

14590, 52304, 51513, 50589, 126437

15. city_code¶

Type: string → VARCHAR(6)
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	4
Avg Length	0.0
Buffered Length	6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

1, NULL, 134, 4547, 4398

16. zzdrmnr¶

Type: string → VARCHAR(9)
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	6
Avg Length	0.0
Buffered Length	9 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

NULL, 10.106, 6.088, 32.007, 1.048

17. zdrmbez¶

Type: string → VARCHAR(45)
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	30
Avg Length	0.0
Buffered Length	45 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

NULL, Rehalp, Stadtspital Triemli, Bunker Sihlquai, Givaudan

18. zzdrmsch¶

Type: string → VARCHAR(6)
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	4
Avg Length	0.0
Buffered Length	6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

NULL, A, -, B, Z

19. zzdrmsch_bez¶

Type: string → VARCHAR(36)
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	24
Avg Length	0.0
Buffered Length	36 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

NULL, Schiene A, ist DRM-Station, Schiene B, Schiene für Summenzähler

20. egid¶

Type: string → VARCHAR(13)
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	9
Avg Length	0.0
Buffered Length	13 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

NULL, 157134, 155764, 162606, 157109

21. MD_prozessiert¶

Type: timestamp → TIMESTAMP
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	20
Avg Length	0.0
Buffered Length	30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

2025-11-02 00:00:00

22. regiogroup¶

Type: string → VARCHAR(7)
Nullable: No

Metric	Value
Total Rows	689,003
Non-null	689,003 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	5
Avg Length	0.0
Buffered Length	7 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 689,003 - Parse Success: 689,003 / 689,003

Sample Values:

X, K0007, K0003, K0006, 134

PostgreSQL DDL¶

See sap_technischerplatz_schema.sql

Generated by process-csv-to-postgres v1.0.0