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

Generated: 2025-11-24 19:50:15.254404 Schema: raw.eanlh Total Rows: 464,412 Columns: 27 Completeness: 77.78%

Source Files¶

File	Rows	Size
20251107002203_eanlh_6183.csv	464,412	109.4 MB
Total	464,412	109.4 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	BIS	integer	INTEGER	No	0.00%	0
4	AB	integer	INTEGER	No	0.00%	0
5	TARIFTYP	string	VARCHAR(15)	No	0.00%	0
6	ANLSTAT	string	VARCHAR(1)	Yes	100.00%	0
7	KONZBEFR	string	VARCHAR(1)	Yes	100.00%	0
8	PAUSCHAL	string	VARCHAR(1)	Yes	100.00%	0
9	BRANCHE	string	VARCHAR(15)	No	0.00%	0
10	AKLASSE	string	VARCHAR(6)	No	0.00%	0
11	ABLEINH	string	VARCHAR(12)	No	0.00%	0
12	TEMP_AREA	string	VARCHAR(12)	No	0.00%	0
13	KONZVER	string	VARCHAR(15)	No	0.00%	0
14	BILLING_PARTY	string	VARCHAR(15)	No	0.00%	0
15	INVOICING_PARTY	string	VARCHAR(15)	No	0.00%	0
16	PROV_LAST_RES	string	VARCHAR(15)	No	0.00%	0
17	MAININST	string	VARCHAR(15)	No	0.00%	0
18	INSTROLE	string	VARCHAR(6)	No	0.00%	0
19	INSTGRTYPE	string	VARCHAR(6)	No	0.00%	0
20	ISTYPE	string	VARCHAR(6)	No	0.00%	0
21	HIGHLEVINST	string	VARCHAR(15)	No	0.00%	0
22	DUMMY_UTILSINSTH_INCL_EEW_PS	string	VARCHAR(1)	Yes	100.00%	0
23	SCHEMANR	string	VARCHAR(15)	No	0.00%	0
24	HOCHART	string	VARCHAR(1)	Yes	100.00%	0
25	VPERGRUP	string	VARCHAR(6)	No	0.00%	0
26	PRUEFGR	string	VARCHAR(6)	No	0.00%	0
27	ABSSTEU	string	VARCHAR(1)	Yes	100.00%	0

Detailed Column Profiles¶

1. MANDT¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

2. ANLAGE¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

0002023345, 0002016422, 0002034025, 0002016172, 0002023196

3. BIS¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

99991231, 20240930, 20090930, 20210331, 20190331

4. AB¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

20241001, 20091001, 19940101, 20210401, 20190401

5. TARIFTYP¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

EWP       , EH        , GH        , HE        , EH.BXX

6. ANLSTAT¶

Type: string → VARCHAR(1)
Nullable: Yes

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

Sample Values:

(no data)

7. KONZBEFR¶

Type: string → VARCHAR(1)
Nullable: Yes

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

Sample Values:

(no data)

8. PAUSCHAL¶

Type: string → VARCHAR(1)
Nullable: Yes

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

Sample Values:

(no data)

9. BRANCHE¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

KO        , HEWA      , HEKOWA    , KOWA      , HE

10. AKLASSE¶

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

0100, 0130, 0300, 0600, 0700

11. ABLEINH¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

QSG-01  , JSG-05  , QDG-01  , JSG-11  , JSG-02

12. TEMP_AREA¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

0100    ,         , RES     , 0001

13. KONZVER¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

14. BILLING_PARTY¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

15. INVOICING_PARTY¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

16. PROV_LAST_RES¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

17. MAININST¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

18. INSTROLE¶

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

19. INSTGRTYPE¶

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

20. ISTYPE¶

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

21. HIGHLEVINST¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

22. DUMMY_UTILSINSTH_INCL_EEW_PS¶

Type: string → VARCHAR(1)
Nullable: Yes

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

Sample Values:

(no data)

23. SCHEMANR¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

24. HOCHART¶

Type: string → VARCHAR(1)
Nullable: Yes

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

Sample Values:

(no data)

25. VPERGRUP¶

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

26. PRUEFGR¶

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

27. ABSSTEU¶

Type: string → VARCHAR(1)
Nullable: Yes

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

Sample Values:

(no data)

PostgreSQL DDL¶

See eanlh_schema.sql

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