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

Generated: 2025-11-24 19:49:01.305088 Schema: raw.eanl Total Rows: 70,055 Columns: 38 Completeness: 64.81%

Source Files¶

File	Rows	Size
20251029124858_eanl_5978.csv	70,055	19.8 MB
Total	70,055	19.8 MB

Column Summary¶

#	Column	Type	PostgreSQL	Nullable	Nulls	Unique
1	MANDT	integer	INTEGER	No	0.00%	0
2	ANLAGE	string	VARCHAR(15)	No	0.00%	0
3	SPARTE	string	VARCHAR(3)	No	0.00%	0
4	VSTELLE	string	VARCHAR(15)	No	0.00%	0
5	ABLSPERR	integer	INTEGER	Yes	100.00%	0
6	BAPERTYP	string	VARCHAR(1)	Yes	0.34%	0
7	ANSCHREI	string	VARCHAR(15)	No	0.00%	0
8	SPEBENE	string	VARCHAR(1)	Yes	100.00%	0
9	DRCKSTUF	string	VARCHAR(1)	Yes	100.00%	0
10	ANLART	string	VARCHAR(6)	No	0.00%	0
11	BEZUG	string	VARCHAR(1)	Yes	99.99%	0
12	ABLESARTST	string	VARCHAR(12)	No	0.00%	0
13	NODISCONCT	string	VARCHAR(6)	No	0.00%	0
14	SERVICE	string	VARCHAR(6)	No	0.00%	0
15	DEREGSTAT	string	VARCHAR(1)	Yes	100.00%	0
16	INFOREL	string	VARCHAR(1)	Yes	100.00%	0
17	ETIMEZONE	string	VARCHAR(9)	No	0.00%	0
18	OUCONT	string	VARCHAR(1)	Yes	100.00%	0
19	HOLICALID	string	VARCHAR(1)	Yes	100.00%	0
20	DUMMY_UTILSINST_INCL_EEW_PS	string	VARCHAR(1)	Yes	100.00%	0
21	ZCRISIS_MANAGER	string	VARCHAR(15)	No	0.00%	0
22	ZZPROTECTED	string	VARCHAR(1)	Yes	96.82%	0
23	ZZPROTECTED_INTERNAL	string	VARCHAR(1)	Yes	45.67%	0
24	ZNOPBFROM	string	VARCHAR(12)	No	0.00%	0
25	ZNOPBTO	string	VARCHAR(12)	No	0.00%	0
26	ZNORECALC	string	VARCHAR(1)	Yes	100.00%	0
27	ZPBTOG	string	VARCHAR(3)	No	0.00%	0
28	ZWKEY	string	VARCHAR(12)	No	0.00%	0
29	ZMAXDIFMR	string	VARCHAR(4)	No	0.00%	0
30	ZTADVB	string	VARCHAR(12)	No	0.00%	0
31	ZINSTLN	string	VARCHAR(15)	No	0.00%	0
32	ERDAT	string	VARCHAR(12)	No	0.00%	0
33	ERNAM	string	VARCHAR(18)	No	0.00%	0
34	AEDAT	string	VARCHAR(12)	No	0.00%	0
35	AENAM	string	VARCHAR(18)	No	0.00%	0
36	BEGRU	string	VARCHAR(6)	No	0.00%	0
37	LOEVM	string	VARCHAR(1)	Yes	94.36%	0
38	COLOGRP_INST	string	VARCHAR(1)	Yes	100.00%	0

Detailed Column Profiles¶

1. MANDT¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

2. ANLAGE¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

0001010458, 0001019950, 0001022240, 0001016043, 0001019713

3. SPARTE¶

Type: string → VARCHAR(3)
Nullable: No

Metric	Value
Total Rows	70,055
Non-null	70,055 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	2
Avg Length	0.0
Buffered Length	3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 70,055 - Parse Success: 70,055 / 70,055

Sample Values:

01, 03, 06, 07

4. VSTELLE¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

0002211775, 0001019064, 0001011698, 0002303162, 0001020993

5. ABLSPERR¶

Type: integer → INTEGER
Nullable: Yes

Metric	Value
Total Rows	70,055
Non-null	1 (0.0%)
Null	70,054 (100.00%)
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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values:

6. BAPERTYP¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	70,055
Non-null	69,818 (99.7%)
Null	237 (0.34%)
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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values:

7. ANSCHREI¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

8. SPEBENE¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	70,055
Non-null	0 (0.0%)
Null	70,055 (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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values:

(no data)

9. DRCKSTUF¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	70,055
Non-null	0 (0.0%)
Null	70,055 (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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values:

(no data)

10. ANLART¶

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

NBA , NHE , XWAS, XABF, UZAE

11. BEZUG¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	70,055
Non-null	8 (0.0%)
Null	70,047 (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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values:

12. ABLESARTST¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

0100    , 0001    ,         , 0002

13. NODISCONCT¶

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

    , 0001

14. SERVICE¶

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

GNET,     , GLIE

15. DEREGSTAT¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	70,055
Non-null	0 (0.0%)
Null	70,055 (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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values:

(no data)

16. INFOREL¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	70,055
Non-null	0 (0.0%)
Null	70,055 (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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values:

(no data)

17. ETIMEZONE¶

Type: string → VARCHAR(9)
Nullable: No

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

Sample Values:

      , CET

18. OUCONT¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	70,055
Non-null	0 (0.0%)
Null	70,055 (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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values:

(no data)

19. HOLICALID¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	70,055
Non-null	0 (0.0%)
Null	70,055 (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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values:

(no data)

20. DUMMY_UTILSINST_INCL_EEW_PS¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	70,055
Non-null	0 (0.0%)
Null	70,055 (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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values:

(no data)

21. ZCRISIS_MANAGER¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

0000000000, 0000055697, 0000055427, 0000055432, 0000031557

22. ZZPROTECTED¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	70,055
Non-null	2,228 (3.2%)
Null	67,827 (96.82%)
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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values:

P, U

23. ZZPROTECTED_INTERNAL¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	70,055
Non-null	38,058 (54.3%)
Null	31,997 (45.67%)
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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values:

P, U, Z, K, W

24. ZNOPBFROM¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

00000000

25. ZNOPBTO¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

00000000

26. ZNORECALC¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	70,055
Non-null	0 (0.0%)
Null	70,055 (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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values:

(no data)

27. ZPBTOG¶

Type: string → VARCHAR(3)
Nullable: No

Metric	Value
Total Rows	70,055
Non-null	70,055 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	2
Avg Length	0.0
Buffered Length	3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 70,055 - Parse Success: 70,055 / 70,055

Sample Values:

28. ZWKEY¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

29. ZMAXDIFMR¶

Type: string → VARCHAR(4)
Nullable: No

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

Sample Values:

30. ZTADVB¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

31. ZINSTLN¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

32. ERDAT¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

20010416, 20081220, 20081219, 20131016, 20250502

33. ERNAM¶

Type: string → VARCHAR(18)
Nullable: No

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

Sample Values:

HALBHERR    , JOBADMIN    , JOGGI       , ZUPPIGER    , VOGEL

34. AEDAT¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

20240903, 20240905, 00000000, 20081222, 20230109

35. AENAM¶

Type: string → VARCHAR(18)
Nullable: No

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

Sample Values:

JOBADMIN    , SCHEFER     , OTTENEDER   ,             , BLESS

36. BEGRU¶

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

    , ZEED, 1021, 2034, 2045

37. LOEVM¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	70,055
Non-null	3,950 (5.6%)
Null	66,105 (94.36%)
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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values:

38. COLOGRP_INST¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	70,055
Non-null	0 (0.0%)
Null	70,055 (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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values:

(no data)

PostgreSQL DDL¶

See eanl_schema.sql

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