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

Generated: 2025-11-24 19:53:19.305889 Schema: raw.egerh Total Rows: 797,228 Columns: 29 Completeness: 95.51%

Source Files¶

File	Rows	Size
20251104235038_egerh_6120.csv	797,228	225.0 MB
Total	797,228	225.0 MB

Column Summary¶

#	Column	Type	PostgreSQL	Nullable	Nulls	Unique
1	MANDT	integer	INTEGER	No	0.00%	0
2	EQUNR	string	VARCHAR(27)	No	0.00%	0
3	BIS	integer	INTEGER	No	0.00%	0
4	AB	integer	INTEGER	No	0.00%	0
5	KOMBINAT	string	VARCHAR(12)	No	0.00%	0
6	LOGIKNR	string	VARCHAR(27)	No	0.00%	0
7	ZWGRUPPE	string	VARCHAR(12)	No	0.00%	0
8	EINBDAT	string	VARCHAR(12)	No	0.00%	0
9	AUSBDAT	string	VARCHAR(12)	No	0.00%	0
10	GERWECHS	string	VARCHAR(3)	Yes	30.17%	0
11	DEVLOC	string	VARCHAR(45)	No	0.00%	0
12	DEVGRP	string	VARCHAR(12)	No	0.00%	0
13	WGRUPPE	string	VARCHAR(12)	No	0.00%	0
14	PPM_METER	string	VARCHAR(3)	No	0.00%	0
15	PRIMWNR1	string	VARCHAR(3)	No	0.00%	0
16	SEKWNR1	string	VARCHAR(3)	No	0.00%	0
17	PRIMWNR2	string	VARCHAR(3)	No	0.00%	0
18	SEKWNR2	string	VARCHAR(3)	No	0.00%	0
19	LOSSDTGROUP	string	VARCHAR(12)	No	0.00%	0
20	RATING	string	VARCHAR(16)	No	0.00%	0
21	P_VOLTAGE	string	VARCHAR(12)	No	0.00%	0
22	S_VOLTAGE	string	VARCHAR(12)	No	0.00%	0
23	AMS	string	VARCHAR(6)	No	0.00%	0
24	AMCG_CAP_GRP	string	VARCHAR(6)	No	0.00%	0
25	MSG_ATTR_ID	string	VARCHAR(6)	No	0.00%	0
26	CAP_ACT_GRP	string	VARCHAR(6)	No	0.00%	0
27	EINBZEIT	string	VARCHAR(9)	No	0.00%	0
28	AUSBZEIT	string	VARCHAR(9)	No	0.00%	0
29	ZEITZONE	string	VARCHAR(1)	Yes	100.00%	0

Detailed Column Profiles¶

1. MANDT¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

2. EQUNR¶

Type: string → VARCHAR(27)
Nullable: No

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

Sample Values:

000000000001129340, 000000000001126672, 000000000001129127, 000000000001129337, 000000000001129342

3. BIS¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

99991231, 20040229, 20051231, 20100930, 20221020

4. AB¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

19000101, 20081001, 19871001, 19871019, 19871006

5. KOMBINAT¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

S       , Z       , M       ,         , D

6. LOGIKNR¶

Type: string → VARCHAR(27)
Nullable: No

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

Sample Values:

000000000000000000, 000000000001047298, 000000000001048451, 000000000001053461, 000000000001053592

7. ZWGRUPPE¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

        , 00000003, 00000002, 00000029, 00000033

8. EINBDAT¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

00000000, 20081001, 19871019, 19871001, 19871006

9. AUSBDAT¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

00000000, 20040301, 20060101, 20050701, 20050101

10. GERWECHS¶

Type: string → VARCHAR(3)
Nullable: Yes

Metric	Value
Total Rows	797,228
Non-null	556,733 (69.8%)
Null	240,495 (30.17%)
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: 797,228 - Parse Success: 797,228 / 797,228

Sample Values:

06, 99, 01, 05, 02

11. DEVLOC¶

Type: string → VARCHAR(45)
Nullable: No

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

Sample Values:

                              , Z/0001.00090.0068    .005.01A , Z/0001.00006.0026    .035.  A , Z/0001.00075.0069    .010.  A , Z/0001.00075.0018    .025.  A

12. DEVGRP¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

13. WGRUPPE¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

14. PPM_METER¶

Type: string → VARCHAR(3)
Nullable: No

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

Sample Values:

00, 01, 02

15. PRIMWNR1¶

Type: string → VARCHAR(3)
Nullable: No

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

Sample Values:

16. SEKWNR1¶

Type: string → VARCHAR(3)
Nullable: No

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

Sample Values:

17. PRIMWNR2¶

Type: string → VARCHAR(3)
Nullable: No

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

Sample Values:

18. SEKWNR2¶

Type: string → VARCHAR(3)
Nullable: No

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

Sample Values:

19. LOSSDTGROUP¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

20. RATING¶

Type: string → VARCHAR(16)
Nullable: No

Metric	Value
Total Rows	797,228
Non-null	797,228 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	11
Avg Length	0.0
Buffered Length	16 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 797,228 - Parse Success: 797,228 / 797,228

Sample Values:

21. P_VOLTAGE¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

22. S_VOLTAGE¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

23. AMS¶

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

24. AMCG_CAP_GRP¶

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

25. MSG_ATTR_ID¶

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

26. CAP_ACT_GRP¶

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

27. EINBZEIT¶

Type: string → VARCHAR(9)
Nullable: No

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

Sample Values:

28. AUSBZEIT¶

Type: string → VARCHAR(9)
Nullable: No

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

Sample Values:

29. ZEITZONE¶

Type: string → VARCHAR(1)
Nullable: Yes

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

Sample Values:

(no data)

PostgreSQL DDL¶

See egerh_schema.sql

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