Skip to content

Data Profile: sap_vertragskonto

Generated: 2025-11-27 00:26:32.997943 Schema: raw_results.sap_vertragskonto Total Rows: 68,011 Columns: 7 Completeness: 100.00%

Source Files

File Rows Size
sap_vertragskonto.csv 68,011 4.3 MB
Total 68,011 4.3 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 vkont integer INTEGER No 0.00% 0
4 gpart integer INTEGER No 0.00% 0
5 abwrh string VARCHAR(10) No 0.00% 0
6 bukrs integer INTEGER No 0.00% 0
7 MD_prozessiert timestamp TIMESTAMP No 0.00% 0

Detailed Column Profiles

1. OBJECTID

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

32450, 32461, 32462, 32470, 32475

2. recz

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

32450, 32461, 32462, 32470, 32475

3. vkont

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

1095443, 1095467, 1095472, 1095288, 1095296

4. gpart

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

9000032, 9001403, 8321595, 1021305, 9004522

5. abwrh

Type: string → VARCHAR(10)
Nullable: No

Metric Value
Total Rows 68,011
Non-null 68,011 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 7
Avg Length 0.0
Buffered Length 10 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 68,011 - Parse Success: 68,011 / 68,011

Sample Values: 

NULL, 9002352, 9001060, 1120860, 1088634

6. bukrs

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

100, 6000, 300, 500

7. MD_prozessiert

Type: timestamp → TIMESTAMP
Nullable: No

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

Sample Values: 

2025-11-02 00:00:00

PostgreSQL DDL

See sap_vertragskonto_schema.sql

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