Skip to content

Data Profile: sap_fakten

Generated: 2025-11-27 00:24:30.352518 Schema: raw_results.sap_fakten Total Rows: 104,364 Columns: 10 Completeness: 100.00%

Source Files

File Rows Size
sap_fakten.csv 104,364 14.4 MB
Total 104,364 14.4 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 anlage integer INTEGER No 0.00% 0
4 operand string VARCHAR(15) No 0.00% 0
5 ab timestamp TIMESTAMP No 0.00% 0
6 bis timestamp TIMESTAMP No 0.00% 0
7 ablfdnr numeric NUMERIC(12,2) No 0.00% 0
8 wert1 numeric NUMERIC(12,2) No 0.00% 0
9 kondigr string VARCHAR(15) No 0.00% 0
10 MD_prozessiert timestamp TIMESTAMP No 0.00% 0

Detailed Column Profiles

1. OBJECTID

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

491, 501, 376, 378, 391

2. recz

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

491, 501, 376, 378, 391

3. anlage

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

1000198, 1000133, 1000141, 1000115, 1000140

4. operand

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

ZDEM_INST1, ZFAC_FREIB, ZRTY_PRE01, ZDEM_INDV1

5. ab

Type: timestamp → TIMESTAMP
Nullable: No

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

Sample Values: 

2024-10-01 00:00:00, 2009-10-01 00:00:00, 2009-07-08 00:00:00, 2020-01-01 00:00:00, 2009-07-09 00:00:00

6. bis

Type: timestamp → TIMESTAMP
Nullable: No

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

Sample Values: 

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

7. ablfdnr

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

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

Sample Values: 

0.0, 1.0

8. wert1

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

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

Sample Values: 

0.0, 0.1, 0.5, 14.0, 25.0

9. kondigr

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

NULL, STAFFEL_02, STAFFEL_03, STAFFEL_01, MESSDIEN02

10. MD_prozessiert

Type: timestamp → TIMESTAMP
Nullable: No

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

Sample Values: 

2025-11-09 00:00:00

PostgreSQL DDL

See sap_fakten_schema.sql

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