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

Generated: 2025-11-25 00:44:17.309885 Schema: raw.evbs Total Rows: 78,106 Columns: 22 Completeness: 87.46%

Source Files¶

File	Rows	Size
20251104234941_evbs_6120.csv	78,106	25.6 MB
Total	78,106	25.6 MB

Column Summary¶

#	Column	Type	PostgreSQL	Nullable	Nulls	Unique
1	MANDT	integer	INTEGER	No	0.00%	0
2	VSTELLE	string	VARCHAR(15)	No	0.00%	0
3	HAUS	string	VARCHAR(45)	No	0.00%	0
4	STR_ERG2	string	VARCHAR(60)	No	0.00%	0
5	HAUS_NUM2	string	VARCHAR(15)	No	0.00%	0
6	TXTLANGU	string	VARCHAR(1)	No	0.00%	0
7	LGZUSATZ	string	VARCHAR(60)	No	0.00%	0
8	VBSART	string	VARCHAR(12)	No	0.00%	0
9	EIGENT	string	VARCHAR(15)	No	0.00%	0
10	OBJNR	string	VARCHAR(33)	No	0.00%	0
11	TPLNUMMER	string	VARCHAR(45)	No	0.00%	0
12	ERDAT	integer	INTEGER	No	0.00%	0
13	ERNAM	string	VARCHAR(18)	No	0.00%	0
14	AEDAT	string	VARCHAR(12)	No	0.00%	0
15	AENAM	string	VARCHAR(18)	No	0.00%	0
16	BEGRU	string	VARCHAR(6)	No	0.00%	0
17	LOEVM	string	VARCHAR(1)	Yes	94.28%	0
18	ANZPERS	string	VARCHAR(4)	No	0.00%	0
19	FLOOR	string	VARCHAR(15)	No	0.00%	0
20	ROOMNUMBER	string	VARCHAR(15)	No	0.00%	0
21	HPTWHNSITZ	string	VARCHAR(1)	Yes	100.00%	0
22	STR_ERG4	string	VARCHAR(60)	Yes	81.56%	0

Detailed Column Profiles¶

1. MANDT¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

2. VSTELLE¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

0001012211, 0001023393, 0001023395, 0001021929, 0001023403

3. HAUS¶

Type: string → VARCHAR(45)
Nullable: No

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

Sample Values:

A/0067.10069.0023             , X/3450.F7369.0009             , A/0004.52895.0009             , A/0067.30006.0022             , B/0088.07297.0036

4. STR_ERG2¶

Type: string → VARCHAR(60)
Nullable: No

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

Sample Values:

                                        , Heizung + Warmwasser                    , Stockwerkeigent.Gemeinschaft            , GA 1.04 - Energiezähler                 , GA 4.40 - Energiezähler

5. HAUS_NUM2¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

          , U1        , Spezial   , Heizung   , EG

6. TXTLANGU¶

Type: string → VARCHAR(1)
Nullable: No

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

Sample Values:

7. LGZUSATZ¶

Type: string → VARCHAR(60)
Nullable: No

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

Sample Values:

                                        , Heizung + Warmwasser                    , Heizung                                 , Hauptwärmezähler                        , Unterzähler

8. VBSART¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

MFH     ,         , EFH     , BG      , RB

9. EIGENT¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

10. OBJNR¶

Type: string → VARCHAR(33)
Nullable: No

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

Sample Values:

11. TPLNUMMER¶

Type: string → VARCHAR(45)
Nullable: No

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

Sample Values:

12. ERDAT¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

20010414, 20081220, 20081219, 20140827, 20010420

13. ERNAM¶

Type: string → VARCHAR(18)
Nullable: No

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

Sample Values:

HALBHERR    , JOBADMIN    , BUCHMANN    , STALDER     , SCHREFEL

14. AEDAT¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

00000000, 20100806, 20010419, 20010420, 20210728

15. AENAM¶

Type: string → VARCHAR(18)
Nullable: No

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

Sample Values:

            , JOBADMIN    , HALBHERR    , LEU         , HOFSTETTER

16. BEGRU¶

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

17. LOEVM¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	78,106
Non-null	4,470 (5.7%)
Null	73,636 (94.28%)
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: 78,106 - Parse Success: 78,106 / 78,106

Sample Values:

18. ANZPERS¶

Type: string → VARCHAR(4)
Nullable: No

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

Sample Values:

19. FLOOR¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

          , U1        , ALLG      , P         , 1

20. ROOMNUMBER¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

          , Garage    , DG        , UG        , 505

21. HPTWHNSITZ¶

Type: string → VARCHAR(1)
Nullable: Yes

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

Sample Values:

(no data)

22. STR_ERG4¶

Type: string → VARCHAR(60)
Nullable: Yes

Metric	Value
Total Rows	78,106
Non-null	14,405 (18.4%)
Null	63,701 (81.56%)
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: 78,106 - Parse Success: 78,106 / 78,106

Sample Values:

Heizung + Warmwasser, Gas, Gasheizung, Heizung, Gas-Hzg/Ww

PostgreSQL DDL¶

See evbs_schema.sql

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