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: vinet¶

Generated: 2025-11-25 00:22:11.302442 Schema: raw.vinet Total Rows: 55,087 Columns: 31 Completeness: 90.32%

Source Files¶

File	Rows	Size
20251105001402_vinet_6120.csv	55,087	22.0 MB
Total	55,087	22.0 MB

Column Summary¶

#	Column	Type	PostgreSQL	Nullable	Nulls	Unique
1	MANDT	integer	INTEGER	No	0.00%	0
2	KANTE	string	VARCHAR(27)	No	0.00%	0
3	SPRAS	string	VARCHAR(1)	No	0.00%	0
4	KANXT	string	VARCHAR(60)	No	0.00%	0
5	KZLTX	string	VARCHAR(1)	Yes	99.99%	0
6	MLANG	string	VARCHAR(1)	No	0.00%	0
7	NETID	string	VARCHAR(12)	No	0.00%	0
8	KANTYP	boolean	BOOLEAN	No	0.00%	0
9	TPVON	string	VARCHAR(45)	No	0.00%	0
10	EQVON	string	VARCHAR(27)	No	0.00%	0
11	TPNACH	string	VARCHAR(45)	No	0.00%	0
12	EQNACH	string	VARCHAR(27)	No	0.00%	0
13	LFDKNR	string	VARCHAR(6)	No	0.00%	0
14	DATVA	string	VARCHAR(12)	No	0.00%	0
15	ZEITVA	string	VARCHAR(9)	No	0.00%	0
16	DATVB	integer	INTEGER	No	0.00%	0
17	ZEITVB	integer	INTEGER	No	0.00%	0
18	STATUS	string	VARCHAR(33)	No	0.00%	0
19	TPKANT	string	VARCHAR(45)	No	0.00%	0
20	EQKANT	string	VARCHAR(27)	No	0.00%	0
21	MEDIU	string	VARCHAR(9)	No	0.00%	0
22	BEZARP	integer	INTEGER	No	0.00%	0
23	BEZARL	integer	INTEGER	No	0.00%	0
24	ERDAT	integer	INTEGER	No	0.00%	0
25	ERNAM	string	VARCHAR(18)	No	0.00%	0
26	AEDAT	string	VARCHAR(12)	No	0.00%	0
27	AENAM	string	VARCHAR(18)	No	0.00%	0
28	BEGRU	string	VARCHAR(6)	No	0.00%	0
29	LVORM	string	VARCHAR(1)	Yes	100.00%	0
30	NETYP	string	VARCHAR(1)	No	0.00%	0
31	MATNR	string	VARCHAR(1)	Yes	100.00%	0

Detailed Column Profiles¶

1. MANDT¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

2. KANTE¶

Type: string → VARCHAR(27)
Nullable: No

Metric	Value
Total Rows	55,087
Non-null	55,087 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	18
Avg Length	0.0
Buffered Length	27 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 55,087 - Parse Success: 55,087 / 55,087

Sample Values:

000000000010073909, 000000000010073923, 000000000010073937, 000000000010073952, 000000000010073966

3. SPRAS¶

Type: string → VARCHAR(1)
Nullable: No

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

Sample Values:

4. KANXT¶

Type: string → VARCHAR(60)
Nullable: No

Metric	Value
Total Rows	55,087
Non-null	55,087 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	40
Avg Length	0.0
Buffered Length	60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 55,087 - Parse Success: 55,087 / 55,087

Sample Values:

Schluessel-Tresor zu Haus               , Zuleitung                               , Schlüssel-Tresor zu Haus                , Zähler / Apparate                       , Zähler / Unterzähler

5. KZLTX¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	55,087
Non-null	5 (0.0%)
Null	55,082 (99.99%)
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: 55,087 - Parse Success: 55,087 / 55,087

Sample Values:

6. MLANG¶

Type: string → VARCHAR(1)
Nullable: No

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

Sample Values:

7. NETID¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

SLT     , T-FERNW , L-ZUL   , L-AUS   , Z-UZ

8. KANTYP¶

Type: boolean → BOOLEAN
Nullable: No

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

Sample Values:

True

9. TPVON¶

Type: string → VARCHAR(45)
Nullable: No

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

Sample Values:

Z/0001.00685.0025             , Z/0001.00247.0176             , Z/0001.00035.0022    .000     , 0/3503.E9157.0008             , Z/0001.01052.0048    .000

10. EQVON¶

Type: string → VARCHAR(27)
Nullable: No

Metric	Value
Total Rows	55,087
Non-null	55,087 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	18
Avg Length	0.0
Buffered Length	27 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 55,087 - Parse Success: 55,087 / 55,087

Sample Values:

11. TPNACH¶

Type: string → VARCHAR(45)
Nullable: No

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

Sample Values:

Z/0001.00685.0027             , Z/0001.00058.0215             , 0/0121.09792.0024             , 0/0121.09792.0046             , B/0093.08399.0041

12. EQNACH¶

Type: string → VARCHAR(27)
Nullable: No

Metric	Value
Total Rows	55,087
Non-null	55,087 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	18
Avg Length	0.0
Buffered Length	27 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 55,087 - Parse Success: 55,087 / 55,087

Sample Values:

13. LFDKNR¶

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

0001, 0002, 0003, 0004, 0005

14. DATVA¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

20071127, 20020220, 20230202, 19980309, 20100101

15. ZEITVA¶

Type: string → VARCHAR(9)
Nullable: No

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

Sample Values:

200002, 050131, 050221, 083027, 050315

16. DATVB¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

99991231, 20211121, 20161231, 20231231, 20240613

17. ZEITVB¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

235959, 151955, 145915

18. STATUS¶

Type: string → VARCHAR(33)
Nullable: No

Metric	Value
Total Rows	55,087
Non-null	55,087 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	22
Avg Length	0.0
Buffered Length	33 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 55,087 - Parse Success: 55,087 / 55,087

Sample Values:

IN000000000010074008  , IN000000000010073899  , IN000000000010073902  , IN000000000010073929  , IN000000000010009419

19. TPKANT¶

Type: string → VARCHAR(45)
Nullable: No

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

Sample Values:

                              , Z/0001.00538.0008

20. EQKANT¶

Type: string → VARCHAR(27)
Nullable: No

Metric	Value
Total Rows	55,087
Non-null	55,087 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	18
Avg Length	0.0
Buffered Length	27 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 55,087 - Parse Success: 55,087 / 55,087

Sample Values:

21. MEDIU¶

Type: string → VARCHAR(9)
Nullable: No

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

Sample Values:

SLT   ,       , TECH

22. BEZARP¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

1, 2

23. BEZARL¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

1, 2, 0

24. ERDAT¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

20071127, 20021216, 20230202, 19980309, 20220830

25. ERNAM¶

Type: string → VARCHAR(18)
Nullable: No

Metric	Value
Total Rows	55,087
Non-null	55,087 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	12
Avg Length	0.0
Buffered Length	18 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 55,087 - Parse Success: 55,087 / 55,087

Sample Values:

GAHLER      , JOBADMIN    , BOCK        , VONBALLMOOS , FINK

26. AEDAT¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

00000000, 20240121, 20230702, 20190401, 20050107

27. AENAM¶

Type: string → VARCHAR(18)
Nullable: No

Metric	Value
Total Rows	55,087
Non-null	55,087 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	12
Avg Length	0.0
Buffered Length	18 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 55,087 - Parse Success: 55,087 / 55,087

Sample Values:

JOBADMIN    ,             , STALDER     , BOCK        , FINK

28. BEGRU¶

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

29. LVORM¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	55,087
Non-null	0 (0.0%)
Null	55,087 (100.00%)
Unique	0 (0.0%)
Min Length	0
Max Length	0
Avg Length	0.0
Buffered Length	0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 55,087 - Parse Success: 55,087 / 55,087

Sample Values:

(no data)

30. NETYP¶

Type: string → VARCHAR(1)
Nullable: No

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

Sample Values:

S, T, L, W

31. MATNR¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	55,087
Non-null	0 (0.0%)
Null	55,087 (100.00%)
Unique	0 (0.0%)
Min Length	0
Max Length	0
Avg Length	0.0
Buffered Length	0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 55,087 - Parse Success: 55,087 / 55,087

Sample Values:

(no data)

PostgreSQL DDL¶

See vinet_schema.sql

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