Skip to content

Data Profile: jest

Generated: 2025-11-25 01:43:14.423745 Schema: raw.jest Total Rows: 24,059,716 Columns: 6 Completeness: 88.60%

Source Files

File Rows Size
20251106233808_jest_6183.csv 24,059,716 1399.7 MB
Total 24,059,716 1399.7 MB

Column Summary

# Column Type PostgreSQL Nullable Nulls Unique
1 MANDT integer INTEGER No 0.00% 0
2 OBJNR string VARCHAR(33) No 0.00% 0
3 STAT string VARCHAR(7) No 0.00% 0
4 INACT string VARCHAR(1) Yes 68.42% 0
5 CHGNR string VARCHAR(4) No 0.00% 0
6 _DATAAGING string VARCHAR(12) No 0.00% 0

Detailed Column Profiles

1. MANDT

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

100

2. OBJNR

Type: string → VARCHAR(33)
Nullable: No

Metric Value
Total Rows 24,059,716
Non-null 24,059,716 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 22
Avg Length 0.0
Buffered Length 33 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 24,059,716 - Parse Success: 24,059,716 / 24,059,716

Sample Values: 

OR000003217629        , OR000003217636        , OR000003217639        , OR000003217619        , OR000003217626

3. STAT

Type: string → VARCHAR(7)
Nullable: No

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

Sample Values: 

I0002, I0001, I0045, I0154, I0235

4. INACT

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 24,059,716
Non-null 7,597,285 (31.6%)
Null 16,462,431 (68.42%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 24,059,716 - Parse Success: 24,059,716 / 24,059,716

Sample Values: 

X

5. CHGNR

Type: string → VARCHAR(4)
Nullable: No

Metric Value
Total Rows 24,059,716
Non-null 24,059,716 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 3
Avg Length 0.0
Buffered Length 4 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 24,059,716 - Parse Success: 24,059,716 / 24,059,716

Sample Values: 

001, 002, 003, 000, 005

6. _DATAAGING

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 24,059,716
Non-null 24,059,716 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 24,059,716 - Parse Success: 24,059,716 / 24,059,716

Sample Values: 

00000000

PostgreSQL DDL

See jest_schema.sql

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