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

Generated: 2025-11-24 19:51:12.950763 Schema: raw.eastl Total Rows: 186,750 Columns: 15 Completeness: 80.02%

Source Files¶

File	Rows	Size
20251104235144_eastl_6120.csv	186,750	29.0 MB
Total	186,750	29.0 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	LOGIKNR	string	VARCHAR(27)	No	0.00%	0
4	BIS	integer	INTEGER	No	0.00%	0
5	AB	integer	INTEGER	No	0.00%	0
6	PREISKLA	string	VARCHAR(15)	No	0.00%	0
7	GVERRECH	string	VARCHAR(1)	Yes	99.74%	0
8	TARIFART	string	VARCHAR(12)	No	0.00%	0
9	KONDIGR	string	VARCHAR(15)	No	0.00%	0
10	ERDAT	integer	INTEGER	No	0.00%	0
11	ERNAM	string	VARCHAR(18)	No	0.00%	0
12	AEDAT	string	VARCHAR(12)	No	0.00%	0
13	AENAM	string	VARCHAR(18)	No	0.00%	0
14	DEVICE_NBR	string	VARCHAR(1)	Yes	100.00%	0
15	/SAPCE/IURU_VL	string	VARCHAR(1)	Yes	100.00%	0

Detailed Column Profiles¶

1. MANDT¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

2. ANLAGE¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

0002031111, 0002040404, 0002040405, 0002046056, 0001022551

3. LOGIKNR¶

Type: string → VARCHAR(27)
Nullable: No

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

Sample Values:

000000000001043522, 000000000001260211, 000000000001260214, 000000000001260345, 000000000001260349

4. BIS¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

99991231, 20240930, 20040229, 20051231, 20050430

5. AB¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

19940101, 20050518, 20081001, 20241001, 20010402

6. PREISKLA¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

          , WSPR_00001, GB

7. GVERRECH¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	186,750
Non-null	488 (0.3%)
Null	186,262 (99.74%)
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: 186,750 - Parse Success: 186,750 / 186,750

Sample Values:

8. TARIFART¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

        , 3003

9. KONDIGR¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

10. ERDAT¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

20010418, 20010419, 20081220, 20010417, 20241010

11. ERNAM¶

Type: string → VARCHAR(18)
Nullable: No

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

Sample Values:

HALBHERR    , STALDER     , IRNIGER     , VONBALLMOOS , DEMONACO

12. AEDAT¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

00000000, 20110314, 20010605, 20140129, 20140314

13. AENAM¶

Type: string → VARCHAR(18)
Nullable: No

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

Sample Values:

            , JOGGI       , HADORN      , ERNI

14. DEVICE_NBR¶

Type: string → VARCHAR(1)
Nullable: Yes

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

Sample Values:

(no data)

15. /SAPCE/IURU_VL¶

Type: string → VARCHAR(1)
Nullable: Yes

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

Sample Values:

(no data)

PostgreSQL DDL¶

See eastl_schema.sql

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