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

Generated: 2025-11-25 00:34:54.375189 Schema: raw.ettifn Total Rows: 6,368,032 Columns: 25 Completeness: 72.03%

Source Files¶

File	Rows	Size
20251104235214_ettifn_6120.csv	6,368,032	1394.3 MB
Total	6,368,032	1394.3 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	OPERAND	string	VARCHAR(15)	No	0.00%	0
4	SAISON	string	VARCHAR(15)	No	0.00%	0
5	AB	integer	INTEGER	No	0.00%	0
6	ABLFDNR	string	VARCHAR(6)	No	0.00%	0
7	BIS	integer	INTEGER	No	0.00%	0
8	BELNR	string	VARCHAR(18)	No	0.00%	0
9	MBELNR	string	VARCHAR(18)	No	0.00%	0
10	MAUSZUG	string	VARCHAR(1)	Yes	99.52%	0
11	ALTBIS	string	VARCHAR(12)	No	0.00%	0
12	INAKTIV	string	VARCHAR(1)	Yes	99.79%	0
13	MANAEND	string	VARCHAR(1)	Yes	100.00%	0
14	TARIFART	string	VARCHAR(12)	No	0.00%	0
15	KONDIGR	string	VARCHAR(15)	No	0.00%	0
16	WERT1	numeric	NUMERIC(12,2)	No	0.00%	0
17	WERT2	numeric	NUMERIC(12,2)	No	0.00%	0
18	STRING1	string	VARCHAR(15)	No	0.00%	0
19	STRING2	string	VARCHAR(15)	No	0.00%	0
20	STRING3	string	VARCHAR(1)	Yes	100.00%	0
21	STRING4	string	VARCHAR(1)	Yes	100.00%	0
22	ERSATZWERT	integer	INTEGER	Yes	100.00%	0
23	BETRAG	numeric	NUMERIC(12,2)	No	0.00%	0
24	WAERS	string	VARCHAR(7)	No	0.00%	0
25	COLOGRP_INST	string	VARCHAR(1)	Yes	100.00%	0

Detailed Column Profiles¶

1. MANDT¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

2. ANLAGE¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

0001004365, 0001004368, 0001004384, 0001002484, 0001002573

3. OPERAND¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

ZDEM_VERR1, ZQNT_HIST1, ZQUANT_HIS, ZJQUANT__1, ZSCHWELL_1

4. SAISON¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

5. AB¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

20241001, 20091001, 20240401, 20161001, 20231001

6. ABLFDNR¶

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

0000, 0001, 0002, 0003, 0004

7. BIS¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

99991231, 20240930, 20240331, 20010730, 20120930

8. BELNR¶

Type: string → VARCHAR(18)
Nullable: No

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

Sample Values:

            , 000202338695, 000202338691, 000202338679, 000202338704

9. MBELNR¶

Type: string → VARCHAR(18)
Nullable: No

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

Sample Values:

            , 000100529046, 000200117434, 000200127470, 000200127496

10. MAUSZUG¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	6,368,032
Non-null	30,472 (0.5%)
Null	6,337,560 (99.52%)
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: 6,368,032 - Parse Success: 6,368,032 / 6,368,032

Sample Values:

11. ALTBIS¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

00000000, 99991231, 20240930, 20241231, 20171231

12. INAKTIV¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	6,368,032
Non-null	13,197 (0.2%)
Null	6,354,835 (99.79%)
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: 6,368,032 - Parse Success: 6,368,032 / 6,368,032

Sample Values:

13. MANAEND¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	6,368,032
Non-null	15 (0.0%)
Null	6,368,017 (100.00%)
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: 6,368,032 - Parse Success: 6,368,032 / 6,368,032

Sample Values:

14. TARIFART¶

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

        , STAFFEL , RABATT01, BIOGAS  , GRUND_NO

15. KONDIGR¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

          , STAFFEL_02, STAFFEL_03, STAFFEL_01, TARIF

16. WERT1¶

Type: numeric → NUMERIC(12,2)
Nullable: No

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

Sample Values:

0.0, 1.0, 1400.0, 14.0, 11.0

17. WERT2¶

Type: numeric → NUMERIC(12,2)
Nullable: No

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

Sample Values:

0.0, 21.0, 11.0, 307.0, 707.0

18. STRING1¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

          , 000       , GB-300    , GQPR_EHAA2, GB-250

19. STRING2¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

20. STRING3¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	6,368,032
Non-null	136 (0.0%)
Null	6,367,896 (100.00%)
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: 6,368,032 - Parse Success: 6,368,032 / 6,368,032

Sample Values:

X, 1

21. STRING4¶

Type: string → VARCHAR(1)
Nullable: Yes

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

Sample Values:

(no data)

22. ERSATZWERT¶

Type: integer → INTEGER
Nullable: Yes

Metric	Value
Total Rows	6,368,032
Non-null	26 (0.0%)
Null	6,368,006 (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: 6,368,032 - Parse Success: 6,368,032 / 6,368,032

Sample Values:

23. BETRAG¶

Type: numeric → NUMERIC(12,2)
Nullable: No

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

Sample Values:

0.0, 7000.0, 300.0, 7204.8, 14000.0

24. WAERS¶

Type: string → VARCHAR(7)
Nullable: No

Metric	Value
Total Rows	6,368,032
Non-null	6,368,032 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	5
Avg Length	0.0
Buffered Length	7 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 6,368,032 - Parse Success: 6,368,032 / 6,368,032

Sample Values:

     , CHF  , EUR

25. COLOGRP_INST¶

Type: string → VARCHAR(1)
Nullable: Yes

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

Sample Values:

(no data)

PostgreSQL DDL¶

See ettifn_schema.sql

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