Data Profile: sap_objv¶
Generated: 2025-11-27 00:25:11.145458 Schema: raw_results.sap_objv Total Rows: 43,574 Columns: 12 Completeness: 100.00%
Source Files¶
| File | Rows | Size |
|---|---|---|
| sap_objv.csv | 43,574 | 7.6 MB |
| Total | 43,574 | 7.6 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 | kante | integer | INTEGER | No | 0.00% | 0 |
| 4 | lvorm | string | VARCHAR(6) | No | 0.00% | 0 |
| 5 | kanxt | string | VARCHAR(36) | No | 0.00% | 0 |
| 6 | tpvon | string | VARCHAR(43) | No | 0.00% | 0 |
| 7 | tpnach | string | VARCHAR(37) | No | 0.00% | 0 |
| 8 | netyp | string | VARCHAR(1) | No | 0.00% | 0 |
| 9 | netid | string | VARCHAR(12) | No | 0.00% | 0 |
| 10 | datva | timestamp | TIMESTAMP | No | 0.00% | 0 |
| 11 | datvb | timestamp | TIMESTAMP | No | 0.00% | 0 |
| 12 | MD_prozessiert | timestamp | TIMESTAMP | No | 0.00% | 0 |
Detailed Column Profiles¶
1. OBJECTID¶
Type: integer → INTEGER
Nullable: No
| Metric | Value |
|---|---|
| Total Rows | 43,574 |
| Non-null | 43,574 (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: 43,574 - Parse Success: 43,574 / 43,574
Sample Values:
2. recz¶
Type: integer → INTEGER
Nullable: No
| Metric | Value |
|---|---|
| Total Rows | 43,574 |
| Non-null | 43,574 (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: 43,574 - Parse Success: 43,574 / 43,574
Sample Values:
3. kante¶
Type: integer → INTEGER
Nullable: No
| Metric | Value |
|---|---|
| Total Rows | 43,574 |
| Non-null | 43,574 (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: 43,574 - Parse Success: 43,574 / 43,574
Sample Values:
4. lvorm¶
Type: string → VARCHAR(6)
Nullable: No
| Metric | Value |
|---|---|
| Total Rows | 43,574 |
| Non-null | 43,574 (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: 43,574 - Parse Success: 43,574 / 43,574
Sample Values:
5. kanxt¶
Type: string → VARCHAR(36)
Nullable: No
| Metric | Value |
|---|---|
| Total Rows | 43,574 |
| Non-null | 43,574 (100.0%) |
| Unique | 0 (0.0%) |
| Min Length | 0 |
| Max Length | 24 |
| Avg Length | 0.0 |
| Buffered Length | 36 (50% buffer) |
Type Inference: - Confidence: 100% - Rows Analyzed: 43,574 - Parse Success: 43,574 / 43,574
Sample Values:
Schluessel-Tresor zu Hau, Schlüssel-Tresor zu Haus, Schlüsseltresor zu Haus, HZ: Schweighofstrasse 29, HZ: Hegianwandweg 73
6. tpvon¶
Type: string → VARCHAR(43)
Nullable: No
| Metric | Value |
|---|---|
| Total Rows | 43,574 |
| Non-null | 43,574 (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: 43,574 - Parse Success: 43,574 / 43,574
Sample Values:
Z/0001.00066.0035 .000, Z/0001.00035.0022 .000, X/2027.C7557.0019F, A/0067.F5526.0017, Z/0001.00247.0176
7. tpnach¶
Type: string → VARCHAR(37)
Nullable: No
| Metric | Value |
|---|---|
| Total Rows | 43,574 |
| Non-null | 43,574 (100.0%) |
| Unique | 0 (0.0%) |
| Min Length | 0 |
| Max Length | 25 |
| Avg Length | 0.0 |
| Buffered Length | 37 (50% buffer) |
Type Inference: - Confidence: 100% - Rows Analyzed: 43,574 - Parse Success: 43,574 / 43,574
Sample Values:
8. netyp¶
Type: string → VARCHAR(1)
Nullable: No
| Metric | Value |
|---|---|
| Total Rows | 43,574 |
| Non-null | 43,574 (100.0%) |
| 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: 43,574 - Parse Success: 43,574 / 43,574
Sample Values:
9. netid¶
Type: string → VARCHAR(12)
Nullable: No
| Metric | Value |
|---|---|
| Total Rows | 43,574 |
| Non-null | 43,574 (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: 43,574 - Parse Success: 43,574 / 43,574
Sample Values:
10. datva¶
Type: timestamp → TIMESTAMP
Nullable: No
| Metric | Value |
|---|---|
| Total Rows | 43,574 |
| Non-null | 43,574 (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: 43,574 - Parse Success: 43,574 / 43,574
Sample Values:
2002-02-20 00:00:00, 2007-11-27 00:00:00, 2023-02-02 00:00:00, 1998-03-09 00:00:00, 2010-01-01 00:00:00
11. datvb¶
Type: timestamp → TIMESTAMP
Nullable: No
| Metric | Value |
|---|---|
| Total Rows | 43,574 |
| Non-null | 43,574 (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: 43,574 - Parse Success: 43,574 / 43,574
Sample Values:
9999-12-31 00:00:00, 2021-11-21 00:00:00, 2016-12-31 00:00:00, 2023-12-31 00:00:00, 2024-06-13 00:00:00
12. MD_prozessiert¶
Type: timestamp → TIMESTAMP
Nullable: No
| Metric | Value |
|---|---|
| Total Rows | 43,574 |
| Non-null | 43,574 (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: 43,574 - Parse Success: 43,574 / 43,574
Sample Values:
PostgreSQL DDL¶
See sap_objv_schema.sql
Generated by process-csv-to-postgres v1.0.0