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_geraet¶

Generated: 2025-11-27 00:24:44.640148 Schema: raw_results.sap_geraet Total Rows: 206,745 Columns: 23 Completeness: 100.00%

Source Files¶

File	Rows	Size
sap_geraet.csv	206,745	45.9 MB
Total	206,745	45.9 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	equnr	integer	INTEGER	No	0.00%	0
4	sernr	string	VARCHAR(15)	No	0.00%	0
5	matnr	string	VARCHAR(9)	No	0.00%	0
6	tplnr	string	VARCHAR(43)	No	0.00%	0
7	eqtyp	string	VARCHAR(1)	No	0.00%	0
8	typtx	string	VARCHAR(28)	No	0.00%	0
9	eqktx	string	VARCHAR(61)	No	0.00%	0
10	baujj	string	VARCHAR(6)	No	0.00%	0
11	eqfnr	string	VARCHAR(39)	No	0.00%	0
12	eqart	string	VARCHAR(10)	No	0.00%	0
13	eartx	string	VARCHAR(30)	No	0.00%	0
14	stort	string	VARCHAR(6)	No	0.00%	0
15	ktext	string	VARCHAR(55)	No	0.00%	0
16	msgrp	string	VARCHAR(12)	No	0.00%	0
17	zzuendsicherung	string	VARCHAR(6)	No	0.00%	0
18	zzuendsicherung_tx	string	VARCHAR(40)	No	0.00%	0
19	zleist	integer	INTEGER	No	0.00%	0
20	zzfwlei	integer	INTEGER	No	0.00%	0
21	zmeins	string	VARCHAR(6)	No	0.00%	0
22	leistrel	string	VARCHAR(1)	No	0.00%	0
23	MD_prozessiert	timestamp	TIMESTAMP	No	0.00%	0

Detailed Column Profiles¶

1. OBJECTID¶

Type: integer → INTEGER
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (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: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

15109, 15089, 15090, 15091, 15092

2. recz¶

Type: integer → INTEGER
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (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: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

15109, 15089, 15090, 15091, 15092

3. equnr¶

Type: integer → INTEGER
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (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: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

7008680, 7008681, 7008684, 7008685, 7008657

4. sernr¶

Type: string → VARCHAR(15)
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (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: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

22971232, 22971234, 22971205, 22971207, 22971208

5. matnr¶

Type: string → VARCHAR(9)
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (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: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

30311, 30310, 102803, 101134, 30045

6. tplnr¶

Type: string → VARCHAR(43)
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (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: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

Z/0001.01663.0042    .100, B/0104.07634.0013    .100, Z/0001.00465.0020    .015, Z/0001.01751.0076    .025, B/0003.08080.0085C   .100

7. eqtyp¶

Type: string → VARCHAR(1)
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (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: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

A, Z

8. typtx¶

Type: string → VARCHAR(28)
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	19
Avg Length	0.0
Buffered Length	28 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

Apparat / Anlage, Zähler/-Zusatzgerät

9. eqktx¶

Type: string → VARCHAR(61)
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (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: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

G4ZR W, G4ER I-CYBLE/P, G6ER I-CYBLE/P, Rombach HR90 18-25 mbar 5/4"", GMT HAR25ZD 19-28 mbar 1""

10. baujj¶

Type: string → VARCHAR(6)
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (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: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

1900, 2024, 2014, 2018, 2015

11. eqfnr¶

Type: string → VARCHAR(39)
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (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: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

HEIZUNG, KELLER, NULL, KELLERGANG, WASCHKÜCHE

12. eqart¶

Type: string → VARCHAR(10)
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (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: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

ZBZ-VBI, DR-HR, I-AHGEB, AH-HTK, ZBZ-VBW

13. eartx¶

Type: string → VARCHAR(30)
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (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: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

Vol. Balgengaszähler, Hausregler, Gebäudeabstellhahn, Heiztherm kondens., Haushaltherd eingeb

14. stort¶

Type: string → VARCHAR(6)
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (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: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

U1, EG, 1., 2., 3.

15. ktext¶

Type: string → VARCHAR(55)
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	37
Avg Length	0.0
Buffered Length	55 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

1. Untergeschoss, Erdgeschoss, 1. Stock, 2. Stock, 3. Stock

16. msgrp¶

Type: string → VARCHAR(12)
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	8
Avg Length	0.0
Buffered Length	12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

NULL, KÜCHE, BAD, GANG, HEIZUNG

17. zzuendsicherung¶

Type: string → VARCHAR(6)
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (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: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

NULL, K, S, D

18. zzuendsicherung_tx¶

Type: string → VARCHAR(40)
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	27
Avg Length	0.0
Buffered Length	40 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

Sicherung vorhanden, NULL, Keine Zündsicherung ab Werk, Zündsicherung demontiert

19. zleist¶

Type: integer → INTEGER
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (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: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

0, 11, 10, 24, 9

20. zzfwlei¶

Type: integer → INTEGER
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (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: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

0, 11, 10, 28, 9

21. zmeins¶

Type: string → VARCHAR(6)
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (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: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

NULL

22. leistrel¶

Type: string → VARCHAR(1)
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (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: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

N, J

23. MD_prozessiert¶

Type: timestamp → TIMESTAMP
Nullable: No

Metric	Value
Total Rows	206,745
Non-null	206,745 (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: 206,745 - Parse Success: 206,745 / 206,745

Sample Values:

2025-11-02 00:00:00

PostgreSQL DDL¶

See sap_geraet_schema.sql

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