Skip to content

Data Profile: sap_einb_tech

Generated: 2025-11-27 00:24:18.899326 Schema: raw_results.sap_einb_tech Total Rows: 208,918 Columns: 8 Completeness: 100.00%

Source Files

File Rows Size
sap_einb_tech.csv 208,918 28.2 MB
Total 208,918 28.2 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 integer INTEGER No 0.00% 0
4 ausbdat timestamp TIMESTAMP No 0.00% 0
5 einbdat timestamp TIMESTAMP No 0.00% 0
6 tplnr string VARCHAR(43) No 0.00% 0
7 MD_prozessiert timestamp TIMESTAMP No 0.00% 0
8 logiknr integer INTEGER No 0.00% 0

Detailed Column Profiles

1. OBJECTID

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

208915, 208917, 208818, 208835, 208846

2. recz

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

208915, 208917, 208818, 208835, 208846

3. equnr

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

7076654, 7076815, 7076292, 7076316, 7076416

4. ausbdat

Type: timestamp → TIMESTAMP
Nullable: No

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

Sample Values: 

9999-12-31 00:00:00, 2022-10-20 00:00:00, 2024-05-21 00:00:00, 2025-11-02 00:00:00, 2025-08-21 00:00:00

5. einbdat

Type: timestamp → TIMESTAMP
Nullable: No

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

Sample Values: 

2008-10-01 00:00:00, 2025-07-03 00:00:00, 2025-03-20 00:00:00, 2025-09-30 00:00:00, 2025-10-10 00:00:00

6. tplnr

Type: string → VARCHAR(43)
Nullable: No

Metric Value
Total Rows 208,918
Non-null 208,918 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 29
Avg Length 0.0
Buffered Length 43 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 208,918 - Parse Success: 208,918 / 208,918

Sample Values: 

Z/0001.00116.0006    .005, Z/0001.00388.0028    .005, B/0074.07112.0004    .005, B/0074.07112.0012    .010, B/0074.07114.0009    .005

7. MD_prozessiert

Type: timestamp → TIMESTAMP
Nullable: No

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

Sample Values: 

2025-11-09 00:00:00

8. logiknr

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

1259410, 1259450, 1259455, 1229057, 1207449

PostgreSQL DDL

See sap_einb_tech_schema.sql

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