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

Generated: 2025-11-25 04:34:58.199710 Schema: raw.zisutariftypb Total Rows: 227 Columns: 19 Completeness: 72.66%

Source Files¶

File	Rows	Size
20251105002122_zisutariftypb_6120.csv	227	0.1 MB
Total	227	0.1 MB

Column Summary¶

#	Column	Type	PostgreSQL	Nullable	Nulls	Unique
1	MANDT	integer	INTEGER	No	0.00%	0
2	TARIFTYP	string	VARCHAR(15)	No	0.00%	0
3	ZLEIST_LOW	integer	INTEGER	No	0.00%	0
4	ZLEIST_HIGH	integer	INTEGER	No	0.00%	0
5	ZSPEZTARIFTYP	string	VARCHAR(1)	Yes	74.01%	0
6	ZTARIFTYP_T1	string	VARCHAR(60)	No	0.00%	0
7	ZTARIFTYP_T2	string	VARCHAR(60)	No	0.00%	0
8	ZTARIFTYP_T3	string	VARCHAR(60)	No	0.00%	0
9	ZTARIFTYP_T4	string	VARCHAR(60)	No	0.00%	0
10	ZTARIFTYP_T4B	string	VARCHAR(60)	No	0.00%	0
11	ZOPERAND	string	VARCHAR(15)	No	0.00%	0
12	TARIFTYP_RESET	string	VARCHAR(15)	No	0.00%	0
13	ZCO2BEFREIT	integer	INTEGER	Yes	25.55%	0
14	BEGLEITBRIEF	string	VARCHAR(1)	Yes	72.69%	0
15	NOPRINT	string	VARCHAR(1)	Yes	99.12%	0
16	WELCOME_BRIEF	string	VARCHAR(1)	Yes	100.00%	0
17	STEUKZ_HS	string	VARCHAR(3)	Yes	48.46%	0
18	NOPRINT_0	string	VARCHAR(1)	Yes	99.56%	0
19	ZZCRM_ERMITTLUNG_GASABSATZ	string	VARCHAR(3)	No	0.00%	0

Detailed Column Profiles¶

1. MANDT¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

2. TARIFTYP¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

3WP.LP    , EKC01     , EKC04     , EKC06     , EKC07

3. ZLEIST_LOW¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

0, 50

4. ZLEIST_HIGH¶

Type: integer → INTEGER
Nullable: No

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

Sample Values:

99999999, 49

5. ZSPEZTARIFTYP¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	227
Non-null	59 (26.0%)
Null	168 (74.01%)
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: 227 - Parse Success: 227 / 227

Sample Values:

6. ZTARIFTYP_T1¶

Type: string → VARCHAR(60)
Nullable: No

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

Sample Values:

                                        , erdgas                                  , UZ                                      , V419                                    , V420

7. ZTARIFTYP_T2¶

Type: string → VARCHAR(60)
Nullable: No

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

Sample Values:

                                        ,  Business                               ,  Haushalt                               ,  Prozess                                ,  Wärme

8. ZTARIFTYP_T3¶

Type: string → VARCHAR(60)
Nullable: No

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

Sample Values:

9. ZTARIFTYP_T4¶

Type: string → VARCHAR(60)
Nullable: No

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

Sample Values:

                                        , Energielösung                           , Netznutzung                             , Erdgas Spezial                          , Erdgas Prozess Zweistoff

10. ZTARIFTYP_T4B¶

Type: string → VARCHAR(60)
Nullable: No

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

Sample Values:

                                        , Erdgas mit &1% Biogas Spezial           , Erdgas mit &1% Biogas Wärme Privat      , Erdgas mit &1% Biogas Wärme             , Erdgas mit &1% Biogas Haushalt

11. ZOPERAND¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

          , ZFAC_FREIB, ZFAC_ANTEB

12. TARIFTYP_RESET¶

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

          , EH.BST    , EP.BST    , EPD.BST   , EW.BST

13. ZCO2BEFREIT¶

Type: integer → INTEGER
Nullable: Yes

Metric	Value
Total Rows	227
Non-null	169 (74.4%)
Null	58 (25.55%)
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: 227 - Parse Success: 227 / 227

Sample Values:

2, 1, 3

14. BEGLEITBRIEF¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	227
Non-null	62 (27.3%)
Null	165 (72.69%)
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: 227 - Parse Success: 227 / 227

Sample Values:

15. NOPRINT¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	227
Non-null	2 (0.9%)
Null	225 (99.12%)
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: 227 - Parse Success: 227 / 227

Sample Values:

16. WELCOME_BRIEF¶

Type: string → VARCHAR(1)
Nullable: Yes

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

Sample Values:

(no data)

17. STEUKZ_HS¶

Type: string → VARCHAR(3)
Nullable: Yes

Metric	Value
Total Rows	227
Non-null	117 (51.5%)
Null	110 (48.46%)
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: 227 - Parse Success: 227 / 227

Sample Values:

18. NOPRINT_0¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	227
Non-null	1 (0.4%)
Null	226 (99.56%)
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: 227 - Parse Success: 227 / 227

Sample Values:

19. ZZCRM_ERMITTLUNG_GASABSATZ¶

Type: string → VARCHAR(3)
Nullable: No

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

Sample Values:

02, 00, 01, X

PostgreSQL DDL¶

See zisutariftypb_schema.sql

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