Skip to content

Data Profile: iflot

Generated: 2025-11-27 10:03:16.373080 Schema: raw.iflot Total Rows: 842,456 Columns: 105 Completeness: 81.24%

Source Files

File Rows Size
20251029124923_iflot_5978.csv 842,456 1186.5 MB
Total 842,456 1186.5 MB

Column Summary

# Column Type PostgreSQL Nullable Nulls Unique
1 MANDT integer INTEGER No 0.00% 0
2 TPLNR string VARCHAR(45) No 0.00% 0
3 MLANG string VARCHAR(1) No 0.00% 0
4 TPLKZ string VARCHAR(7) No 0.00% 0
5 FLTYP string VARCHAR(1) No 0.00% 0
6 TPLMA string VARCHAR(45) No 0.00% 0
7 ERDAT string VARCHAR(12) No 0.00% 0
8 ERNAM string VARCHAR(18) No 0.00% 0
9 AEDAT string VARCHAR(12) No 0.00% 0
10 AENAM string VARCHAR(18) No 0.00% 0
11 DATAB string VARCHAR(12) No 0.00% 0
12 BEGRU string VARCHAR(6) No 0.00% 0
13 TRPNR string VARCHAR(45) No 0.00% 0
14 PSTAE string VARCHAR(6) No 0.00% 0
15 STNAM string VARCHAR(18) No 0.00% 0
16 LVORM string VARCHAR(1) Yes 100.00% 0
17 SUBMT string VARCHAR(60) No 0.00% 0
18 SUBMTI string VARCHAR(1) No 0.00% 0
19 MAPAR string VARCHAR(45) No 0.00% 0
20 MAPARI string VARCHAR(1) Yes 53.13% 0
21 IEQUI string VARCHAR(1) Yes 0.00% 0
22 IEQUII string VARCHAR(1) Yes 0.69% 0
23 EINZL string VARCHAR(1) Yes 100.00% 0
24 EINZLI string VARCHAR(1) No 0.00% 0
25 IWERK string VARCHAR(6) No 0.00% 0
26 IWERKI string VARCHAR(1) No 0.00% 0
27 INGRP string VARCHAR(4) Yes 99.99% 0
28 INGRPI string VARCHAR(1) No 0.00% 0
29 PM_OBJTY string VARCHAR(3) Yes 99.91% 0
30 LGWID string VARCHAR(12) No 0.00% 0
31 LGWIDI string VARCHAR(1) No 0.00% 0
32 RBNR string VARCHAR(13) No 0.00% 0
33 RBNR_I string VARCHAR(1) No 0.00% 0
34 ILOAN string VARCHAR(18) No 0.00% 0
35 OBJNR string VARCHAR(33) No 0.00% 0
36 POSNR string VARCHAR(6) No 0.00% 0
37 ISTYP string VARCHAR(1) Yes 16.68% 0
38 PREMS string VARCHAR(15) No 0.00% 0
39 EQART string VARCHAR(15) No 0.00% 0
40 INVNR string VARCHAR(37) No 0.00% 0
41 GROES string VARCHAR(27) No 0.00% 0
42 BRGEW numeric NUMERIC(12,2) No 0.00% 0
43 GEWEI string VARCHAR(1) Yes 100.00% 0
44 ANSWT numeric NUMERIC(12,2) No 0.00% 0
45 WAERS string VARCHAR(7) No 0.00% 0
46 ANSDT string VARCHAR(12) No 0.00% 0
47 HERST string VARCHAR(45) No 0.00% 0
48 HERLD string VARCHAR(1) Yes 100.00% 0
49 BAUJJ string VARCHAR(6) No 0.00% 0
50 BAUMM string VARCHAR(1) Yes 100.00% 0
51 TYPBZ string VARCHAR(30) No 0.00% 0
52 EMATN string VARCHAR(60) No 0.00% 0
53 SERGE string VARCHAR(45) No 0.00% 0
54 HANDLE string VARCHAR(33) No 0.00% 0
55 TSEGTP string VARCHAR(15) No 0.00% 0
56 CHANGEDDATETIME string VARCHAR(21) No 0.00% 0
57 ENDOFUSE string VARCHAR(12) No 0.00% 0
58 ZZHAUSART string VARCHAR(12) No 0.00% 0
59 ZZFWGEB string VARCHAR(60) No 0.00% 0
60 ZZSLGEB string VARCHAR(15) No 0.00% 0
61 ZZVORDR numeric NUMERIC(12,2) No 0.00% 0
62 ZZEGID string VARCHAR(13) No 0.00% 0
63 ZZDRMNR string VARCHAR(18) No 0.00% 0
64 ZZDRMSCH string VARCHAR(1) Yes 99.84% 0
65 ZZENERGIEZONE string VARCHAR(15) No 0.00% 0
66 ZZBAUZONE string VARCHAR(150) No 0.00% 0
67 ZZN_SAN_JAHR string VARCHAR(6) No 0.00% 0
68 ZZN_SAN_DAEMM string VARCHAR(1) Yes 100.00% 0
69 ZZN_SAN_FENSTER string VARCHAR(1) Yes 100.00% 0
70 ZZN_SAN_DACH string VARCHAR(1) Yes 100.00% 0
71 ZZL_SAN_JAHR string VARCHAR(6) No 0.00% 0
72 ZZL_SAN_DAEMM string VARCHAR(1) Yes 100.00% 0
73 ZZL_SAN_FENSTER string VARCHAR(1) Yes 100.00% 0
74 ZZL_SAN_DACH string VARCHAR(1) Yes 100.00% 0
75 ZZANZ_WOHNUNGEN string VARCHAR(6) No 0.00% 0
76 ZZEXZONE integer INTEGER Yes 99.99% 0
77 ZMAXAUSLASTHAK string VARCHAR(12) No 0.00% 0
78 ZANSCHLSICHHAK string VARCHAR(12) No 0.00% 0
79 ZABSICHHV string VARCHAR(12) No 0.00% 0
80 ZVERTEILNETZB string VARCHAR(15) No 0.00% 0
81 ZLASTABWURF string VARCHAR(6) No 0.00% 0
82 ZPPOBJEKT_B string VARCHAR(12) No 0.00% 0
83 ZMAXABSICHEMOB string VARCHAR(12) No 0.00% 0
84 ZERSCHLART string VARCHAR(15) No 0.00% 0
85 ZLASTMANAGEMENT string VARCHAR(15) No 0.00% 0
86 ZKONEKTIVITAET string VARCHAR(15) No 0.00% 0
87 ZBETREIBMOD string VARCHAR(60) No 0.00% 0
88 ZPROJEKTBEZ string VARCHAR(90) No 0.00% 0
89 VBELN_MOB string VARCHAR(15) No 0.00% 0
90 ZINBETRIEBSETZUNGSDATUM string VARCHAR(12) No 0.00% 0
91 ZSTROMPRODUKT string VARCHAR(30) No 0.00% 0
92 ZNACHW_GRUENSTROM string VARCHAR(6) No 0.00% 0
93 ZKUNDENNUMMER_VNB string VARCHAR(30) No 0.00% 0
94 ZINSTANDHALTUNGSVERTRAG string VARCHAR(6) No 0.00% 0
95 ZINSTANDHALTUNGSINTERVALL string VARCHAR(3) No 0.00% 0
96 ZPARKPLATZBEZEICHNUNG string VARCHAR(30) No 0.00% 0
97 ZPARKPLATZZUSATZBEZ string VARCHAR(30) No 0.00% 0
98 ZPARKPLATZVORSICHERUNG string VARCHAR(30) No 0.00% 0
99 ZZVBELN_NACHWEIS_TP string VARCHAR(15) No 0.00% 0
100 ZZBEMERKUNG_TP string VARCHAR(60) No 0.00% 0
101 DUMMY_IFLOT_INCL_EEW_PS string VARCHAR(1) Yes 100.00% 0
102 FLLB_DUTY string VARCHAR(1) Yes 100.00% 0
103 FLLB_HIDE string VARCHAR(1) Yes 100.00% 0
104 IFLOT_SRTYPE string VARCHAR(15) No 0.00% 0
105 IFLOT_SNTYPE string VARCHAR(1) Yes 100.00% 0

Detailed Column Profiles

1. MANDT

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

100

2. TPLNR

Type: string → VARCHAR(45)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 30
Avg Length 0.0
Buffered Length 45 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

X/1377.A7418.0048             , X/1377.A7418.0056             , X/1377.A7419.0014             , X/1377.A7419.0016             , X/1377.A7419.0025

3. MLANG

Type: string → VARCHAR(1)
Nullable: No

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

Sample Values: 

D

4. TPLKZ

Type: string → VARCHAR(7)
Nullable: No

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

Sample Values: 

AO_GP, GEO  , NET

5. FLTYP

Type: string → VARCHAR(1)
Nullable: No

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

Sample Values: 

A, G, S, T, O

6. TPLMA

Type: string → VARCHAR(45)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 30
Avg Length 0.0
Buffered Length 45 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

X                             , Z/0001                        , X/1377.52425                  , X/1377.A6998                  , X/1377.A7419

7. ERDAT

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

20131004, 20250218, 20010418, 19980308, 19980424

8. ERNAM

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 12
Avg Length 0.0
Buffered Length 18 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

FINK        , JOBADMIN    , FISCHERN    , HALBHERR    , GAHLER

9. AEDAT

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000, 20030217, 20021213, 20010425, 20080925

10. AENAM

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 12
Avg Length 0.0
Buffered Length 18 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

            , SCHREFEL    , STALDER     , IRNIGER     , JOBADMIN

11. DATAB

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000, 20221201, 19000101, 20000502, 20220905

12. BEGRU

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values: 

    , IHA

13. TRPNR

Type: string → VARCHAR(45)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 30
Avg Length 0.0
Buffered Length 45 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values:

14. PSTAE

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

15. STNAM

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 12
Avg Length 0.0
Buffered Length 18 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values:

16. LVORM

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 0 (0.0%)
Null 842,456 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

(no data)

17. SUBMT

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values:

18. SUBMTI

Type: string → VARCHAR(1)
Nullable: No

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

Sample Values: 

D

19. MAPAR

Type: string → VARCHAR(45)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 30
Avg Length 0.0
Buffered Length 45 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values:

20. MAPARI

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 394,869 (46.9%)
Null 447,587 (53.13%)
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: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

D

21. IEQUI

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 842,440 (100.0%)
Null 16 (0.00%)
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: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

X

22. IEQUII

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 836,669 (99.3%)
Null 5,787 (0.69%)
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: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

D

23. EINZL

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 1 (0.0%)
Null 842,455 (100.00%)
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: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

X

24. EINZLI

Type: string → VARCHAR(1)
Nullable: No

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

Sample Values: 

H, D

25. IWERK

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values: 

0100,     , 0300

26. IWERKI

Type: string → VARCHAR(1)
Nullable: No

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

Sample Values: 

D, H

27. INGRP

Type: string → VARCHAR(4)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 50 (0.0%)
Null 842,406 (99.99%)
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: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

094

28. INGRPI

Type: string → VARCHAR(1)
Nullable: No

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

Sample Values: 

D, H

29. PM_OBJTY

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 743 (0.1%)
Null 841,713 (99.91%)
Unique 0 (0.0%)
Min Length 0
Max Length 2
Avg Length 0.0
Buffered Length 3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

A

30. LGWID

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000, 10000167, 10000234

31. LGWIDI

Type: string → VARCHAR(1)
Nullable: No

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

Sample Values: 

H, D

32. RBNR

Type: string → VARCHAR(13)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 9
Avg Length 0.0
Buffered Length 13 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values:

33. RBNR_I

Type: string → VARCHAR(1)
Nullable: No

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

Sample Values: 

H, D

34. ILOAN

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 12
Avg Length 0.0
Buffered Length 18 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

000003384853, 000001260017, 000003384925, 000003384939, 000003384959

35. OBJNR

Type: string → VARCHAR(33)
Nullable: No

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

Sample Values: 

IF00000000000001371950, IF00000000000001371953, IF00000000000001371822, IF00000000000001371836, IF00000000000001371837

36. POSNR

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values: 

    , 430 , 450 , 375 , 155

37. ISTYP

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 701,911 (83.3%)
Null 140,545 (16.68%)
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: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

C, D

38. PREMS

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

          , 0002010304, 0001019260, 0001023475, 0001014066

39. EQART

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

          , Y-ERDGAS  , Y-ÖL      , Y-FERNW   , Y-PELLETS

40. INVNR

Type: string → VARCHAR(37)
Nullable: No

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

Sample Values:

41. GROES

Type: string → VARCHAR(27)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 18
Avg Length 0.0
Buffered Length 27 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values:

42. BRGEW

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

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

Sample Values: 

0.0

43. GEWEI

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 0 (0.0%)
Null 842,456 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

(no data)

44. ANSWT

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

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

Sample Values: 

0.0

45. WAERS

Type: string → VARCHAR(7)
Nullable: No

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

Sample Values:

46. ANSDT

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000, 19000101

47. HERST

Type: string → VARCHAR(45)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 30
Avg Length 0.0
Buffered Length 45 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

                              , Roland Leuthold

48. HERLD

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 0 (0.0%)
Null 842,456 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

(no data)

49. BAUJJ

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values: 

    , 1931, 1947, 1948, 1946

50. BAUMM

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 0 (0.0%)
Null 842,456 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

(no data)

51. TYPBZ

Type: string → VARCHAR(30)
Nullable: No

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

Sample Values: 

                    , feines Raclette

52. EMATN

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values:

53. SERGE

Type: string → VARCHAR(45)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 30
Avg Length 0.0
Buffered Length 45 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values:

54. HANDLE

Type: string → VARCHAR(33)
Nullable: No

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

Sample Values:

55. TSEGTP

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

56. CHANGEDDATETIME

Type: string → VARCHAR(21)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 14
Avg Length 0.0
Buffered Length 21 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

0, 20250912113608, 20250912113619, 20250912113603, 20250912113506

57. ENDOFUSE

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000

58. ZZHAUSART

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

        , MFH     , EFH     , BG      , ÖG

59. ZZFWGEB

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

                                        , GA_2.08_Limmatstrasse                   , GA_5.04_Nürenbergstrasse                , GA_5.02_Thurwiesenstrasse               , GA_2.04_Röntgenplatz

60. ZZSLGEB

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

          , Oerlikon  , Seebach   , Schwamendi, Neuaffolte

61. ZZVORDR

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

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

Sample Values: 

0.0, 4.5

62. ZZEGID

Type: string → VARCHAR(13)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 9
Avg Length 0.0
Buffered Length 13 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

000000000, 000121168, 000648840, 000648393, 000648990

63. ZZDRMNR

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 12
Avg Length 0.0
Buffered Length 18 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

            , 6.080       , 8.007       , 14.005      , 1.395

64. ZZDRMSCH

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 1,307 (0.2%)
Null 841,149 (99.84%)
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: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

A, -, B, Z, C

65. ZZENERGIEZONE

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

          , B 11      , F 11      , F 23      , K 11

66. ZZBAUZONE

Type: string → VARCHAR(150)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 100
Avg Length 0.0
Buffered Length 150 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

                                                                                                    , Wohnzonen                                                                                           , Mischzonen                                                                                          , Zentrumszonen                                                                                       , Arbeitszonen

67. ZZN_SAN_JAHR

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

68. ZZN_SAN_DAEMM

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 0 (0.0%)
Null 842,456 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

(no data)

69. ZZN_SAN_FENSTER

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 0 (0.0%)
Null 842,456 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

(no data)

70. ZZN_SAN_DACH

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 0 (0.0%)
Null 842,456 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

(no data)

71. ZZL_SAN_JAHR

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

72. ZZL_SAN_DAEMM

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 0 (0.0%)
Null 842,456 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

(no data)

73. ZZL_SAN_FENSTER

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 0 (0.0%)
Null 842,456 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

(no data)

74. ZZL_SAN_DACH

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 0 (0.0%)
Null 842,456 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

(no data)

75. ZZANZ_WOHNUNGEN

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values: 

0000, 0012, 0024, 0033, 0020

76. ZZEXZONE

Type: integer → INTEGER
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 57 (0.0%)
Null 842,399 (99.99%)
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: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

2, 0, 1

77. ZMAXAUSLASTHAK

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

        , k.A.    , 160     , 125     , 100

78. ZANSCHLSICHHAK

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

        , k.A.    , 125     , 160     , 80

79. ZABSICHHV

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

        , k.A.    , 80      , 125     , 160

80. ZVERTEILNETZB

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

          , EKZ       , EWZ       , BKW       , SIL

81. ZLASTABWURF

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values: 

    , Ja  , Nein

82. ZPPOBJEKT_B

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

        , 12      , 75      , 33      , 20

83. ZMAXABSICHEMOB

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

        , 63      , K.A.    , 80      , 160

84. ZERSCHLART

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

          , FB        , STERN     , SF        , SS

85. ZLASTMANAGEMENT

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

          , Dynamisch , Statisch

86. ZKONEKTIVITAET

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

          , LTE-Router, LAN       , SIM

87. ZBETREIBMOD

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

                                        , start                                   , smart                                   , smart+                                  , keines

88. ZPROJEKTBEZ

Type: string → VARCHAR(90)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 60
Avg Length 0.0
Buffered Length 90 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

                                                            , Ladeinfrastruktur charge@immo

89. VBELN_MOB

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

          , 0007026400, 0007025703, 0007026500, 0007026356

90. ZINBETRIEBSETZUNGSDATUM

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000

91. ZSTROMPRODUKT

Type: string → VARCHAR(30)
Nullable: No

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

Sample Values:

92. ZNACHW_GRUENSTROM

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

93. ZKUNDENNUMMER_VNB

Type: string → VARCHAR(30)
Nullable: No

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

Sample Values:

94. ZINSTANDHALTUNGSVERTRAG

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

95. ZINSTANDHALTUNGSINTERVALL

Type: string → VARCHAR(3)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 2
Avg Length 0.0
Buffered Length 3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

00

96. ZPARKPLATZBEZEICHNUNG

Type: string → VARCHAR(30)
Nullable: No

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

Sample Values:

97. ZPARKPLATZZUSATZBEZ

Type: string → VARCHAR(30)
Nullable: No

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

Sample Values: 

                    , Bugnion Chi Meei

98. ZPARKPLATZVORSICHERUNG

Type: string → VARCHAR(30)
Nullable: No

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

Sample Values:

99. ZZVBELN_NACHWEIS_TP

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

          , 0008057180, 0008057095

100. ZZBEMERKUNG_TP

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 842,456
Non-null 842,456 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values:

101. DUMMY_IFLOT_INCL_EEW_PS

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 0 (0.0%)
Null 842,456 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

(no data)

102. FLLB_DUTY

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 0 (0.0%)
Null 842,456 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

(no data)

103. FLLB_HIDE

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 0 (0.0%)
Null 842,456 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

(no data)

104. IFLOT_SRTYPE

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

105. IFLOT_SNTYPE

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,456
Non-null 0 (0.0%)
Null 842,456 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,456 - Parse Success: 842,456 / 842,456

Sample Values: 

(no data)

PostgreSQL DDL

See iflot_schema.sql

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