Skip to content

Data Profile: sap_einb_abrt

Generated: 2025-11-27 00:24:10.157866 Schema: raw_results.sap_einb_abrt Total Rows: 116,627 Columns: 8 Completeness: 100.00%

Source Files

File Rows Size
sap_einb_abrt.csv 116,627 13.1 MB
Total 116,627 13.1 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 equnr string VARCHAR(6) No 0.00% 0
4 anlage integer INTEGER No 0.00% 0
5 ausbdat timestamp TIMESTAMP No 0.00% 0
6 einbdat timestamp TIMESTAMP No 0.00% 0
7 logiknr integer INTEGER No 0.00% 0
8 MD_prozessiert timestamp TIMESTAMP No 0.00% 0

Detailed Column Profiles

1. OBJECTID

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

862, 863, 897, 899, 902

2. recz

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

862, 863, 897, 899, 902

3. equnr

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values: 

NULL

4. anlage

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

2045482, 2046356, 1000393, 1000459, 1000291

5. ausbdat

Type: timestamp → TIMESTAMP
Nullable: No

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

Sample Values: 

9999-12-31 00:00:00, 2024-09-30 00:00:00, 2022-10-20 00:00:00, 2021-06-30 00:00:00, 2017-01-16 00:00:00

6. einbdat

Type: timestamp → TIMESTAMP
Nullable: No

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

Sample Values: 

1994-01-01 00:00:00, 2008-10-01 00:00:00, 2005-05-18 00:00:00, 2001-04-03 00:00:00, 2024-10-01 00:00:00

7. logiknr

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

1124217, 1125372, 1123907, 1194675, 1124344

8. MD_prozessiert

Type: timestamp → TIMESTAMP
Nullable: No

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

Sample Values: 

2025-11-09 00:00:00

PostgreSQL DDL

See sap_einb_abrt_schema.sql

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