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

Generated: 2025-11-27 00:21:33.740579 Schema: raw_results.sap_absatz Total Rows: 1,400,125 Columns: 25 Completeness: 100.00%

Source Files¶

File	Rows	Size
sap_absatz.csv	1,400,125	406.1 MB
Total	1,400,125	406.1 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	vertrag	integer	INTEGER	No	0.00%	0
4	budat	timestamp	TIMESTAMP	No	0.00%	0
5	belegdat	string	VARCHAR(40)	No	0.00%	0
6	tariftyp	string	VARCHAR(12)	No	0.00%	0
7	spbup	string	VARCHAR(10)	No	0.00%	0
8	massbill	string	VARCHAR(6)	No	0.00%	0
9	twaers	string	VARCHAR(4)	No	0.00%	0
10	i_abrmenge	numeric	NUMERIC(12,2)	No	0.00%	0
11	zzmenarbha	numeric	NUMERIC(12,2)	No	0.00%	0
12	zzambioup	numeric	NUMERIC(12,2)	No	0.00%	0
13	zzaphandel	numeric	NUMERIC(12,2)	No	0.00%	0
14	zzapbioup	numeric	NUMERIC(12,2)	No	0.00%	0
15	zzaptr_swi	numeric	NUMERIC(12,2)	No	0.00%	0
16	zzaptr_reg	numeric	NUMERIC(12,2)	No	0.00%	0
17	zzaptransp	numeric	NUMERIC(12,2)	No	0.00%	0
18	zzapvertei	numeric	NUMERIC(12,2)	No	0.00%	0
19	zzlphandel	numeric	NUMERIC(12,2)	No	0.00%	0
20	zzlptr_swi	numeric	NUMERIC(12,2)	No	0.00%	0
21	zzlptr_reg	numeric	NUMERIC(12,2)	No	0.00%	0
22	zzlptransp	numeric	NUMERIC(12,2)	No	0.00%	0
23	zzlpvertei	numeric	NUMERIC(12,2)	No	0.00%	0
24	MD_prozessiert	timestamp	TIMESTAMP	No	0.00%	0
25	anlart	string	VARCHAR(6)	No	0.00%	0

Detailed Column Profiles¶

1. OBJECTID¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

1400004, 1400019, 1400025, 1400028, 1400033

2. recz¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

1400004, 1400019, 1400025, 1400028, 1400033

3. vertrag¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

1265509, 1265362, 1266151, 1266181, 1266175

4. budat¶

Type: timestamp → TIMESTAMP
Nullable: No

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

Sample Values:

2023-12-31 00:00:00, 2023-06-30 00:00:00, 2024-09-30 00:00:00, 2025-09-30 00:00:00, 2022-09-30 00:00:00

5. belegdat¶

Type: string → VARCHAR(40)
Nullable: No

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

Sample Values:

2025-07-16 00:00:00.0000000, 2025-10-15 00:00:00.0000000, 2025-09-18 00:00:00.0000000, 2025-09-24 00:00:00.0000000, 2025-09-25 00:00:00.0000000

6. tariftyp¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

EWP, EWP.B25, EWP.B10, EW.B10, EW

7. spbup¶

Type: string → VARCHAR(10)
Nullable: No

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

Sample Values:

09.2023, 03.2025, 09.2024, 12.2024, 06.2023

8. massbill¶

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

KWH, NULL, M3

9. twaers¶

Type: string → VARCHAR(4)
Nullable: No

Metric	Value
Total Rows	1,400,125
Non-null	1,400,125 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	3
Avg Length	0.0
Buffered Length	4 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,400,125 - Parse Success: 1,400,125 / 1,400,125

Sample Values:

CHF

10. i_abrmenge¶

Type: numeric → NUMERIC(12,2)
Nullable: No

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

Sample Values:

0.0, 11.0, 21.0, 32.0, 42.0

11. zzmenarbha¶

Type: numeric → NUMERIC(12,2)
Nullable: No

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

Sample Values:

0.0, 11.0, 21.0, 32.0, 42.0

12. zzambioup¶

Type: numeric → NUMERIC(12,2)
Nullable: No

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

Sample Values:

0.0, 3.85, 7.35, 11.2, 12.8

13. zzaphandel¶

Type: numeric → NUMERIC(12,2)
Nullable: No

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

Sample Values:

0.0, 1.44, 5.44, 54.43, 1138.23

14. zzapbioup¶

Type: numeric → NUMERIC(12,2)
Nullable: No

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

Sample Values:

0.0, 1.05, 1.39, 0.36, 15.15

15. zzaptr_swi¶

Type: numeric → NUMERIC(12,2)
Nullable: No

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

Sample Values:

0.0, 0.01, 0.03, 0.02, 0.04

16. zzaptr_reg¶

Type: numeric → NUMERIC(12,2)
Nullable: No

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

Sample Values:

0.0, 0.02, 0.05, 0.09, 0.18

17. zzaptransp¶

Type: numeric → NUMERIC(12,2)
Nullable: No

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

Sample Values:

0.0, 0.02, 0.03, 0.04, 0.09

18. zzapvertei¶

Type: numeric → NUMERIC(12,2)
Nullable: No

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

Sample Values:

0.0, 0.41, 0.27, 0.82, 0.95

19. zzlphandel¶

Type: numeric → NUMERIC(12,2)
Nullable: No

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

Sample Values:

0.0, 0.01, 42.87, 42.56, 3.74

20. zzlptr_swi¶

Type: numeric → NUMERIC(12,2)
Nullable: No

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

Sample Values:

0.0, 0.45, 0.44, 0.34, 0.46

21. zzlptr_reg¶

Type: numeric → NUMERIC(12,2)
Nullable: No

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

Sample Values:

0.0, 7.87, 7.78, 23.36, 3.93

22. zzlptransp¶

Type: numeric → NUMERIC(12,2)
Nullable: No

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

Sample Values:

0.0, 5.6, 0.12, 0.72, 5.54

23. zzlpvertei¶

Type: numeric → NUMERIC(12,2)
Nullable: No

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

Sample Values:

0.0, 23.53, 23.02, 23.28, 7.57

24. MD_prozessiert¶

Type: timestamp → TIMESTAMP
Nullable: No

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

Sample Values:

2025-11-02 00:00:00

25. anlart¶

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

NHE, NBA, AHE, XWAS, XABF

PostgreSQL DDL¶

See sap_absatz_schema.sql

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