Skip to content

Data Profile: sap_vertrag

Generated: 2025-11-27 00:26:26.023814 Schema: raw_results.sap_vertrag Total Rows: 78,058 Columns: 10 Completeness: 100.00%

Source Files

File Rows Size
sap_vertrag.csv 78,058 9.7 MB
Total 78,058 9.7 MB

Column Summary

# Column Type PostgreSQL Nullable Nulls Unique
1 OBJECTID integer INTEGER No 0.00% 0
2 recz integer INTEGER No 0.00% 0
3 vertrag integer INTEGER No 0.00% 0
4 anlage integer INTEGER No 0.00% 0
5 vkonto integer INTEGER No 0.00% 0
6 einzdat timestamp TIMESTAMP No 0.00% 0
7 auszdat timestamp TIMESTAMP No 0.00% 0
8 bukrs integer INTEGER No 0.00% 0
9 MD_prozessiert timestamp TIMESTAMP No 0.00% 0
10 zzkostl string VARCHAR(7) No 0.00% 0

Detailed Column Profiles

1. OBJECTID

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

47279, 47292, 47294, 47297, 47301

2. recz

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

47279, 47292, 47294, 47297, 47301

3. vertrag

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

1240032, 1240059, 1240104, 1239642, 1239666

4. anlage

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

2035265, 2028367, 1007635, 2006355, 2019297

5. vkonto

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

1077539, 1019578, 1093375, 1092948, 1093492

6. einzdat

Type: timestamp → TIMESTAMP
Nullable: No

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

Sample Values: 

2009-01-01 00:00:00, 2013-10-01 00:00:00, 2024-10-01 00:00:00, 2015-10-01 00:00:00, 2016-01-01 00:00:00

7. auszdat

Type: timestamp → TIMESTAMP
Nullable: No

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

Sample Values: 

9999-12-31 00:00:00, 2024-09-30 00:00:00, 2021-06-30 00:00:00, 2016-09-30 00:00:00, 2019-03-31 00:00:00

8. bukrs

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

100, 6000, 300, 500

9. MD_prozessiert

Type: timestamp → TIMESTAMP
Nullable: No

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

Sample Values: 

2025-11-02 00:00:00

10. zzkostl

Type: string → VARCHAR(7)
Nullable: No

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

Sample Values: 

NULL, 15100, 15062, 5987, 50003

PostgreSQL DDL

See sap_vertrag_schema.sql

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