Skip to content

Data Profile: ever

Generated: 2025-11-25 00:46:13.977878 Schema: raw.ever Total Rows: 171,267 Columns: 129 Completeness: 71.62%

Source Files

File Rows Size
20251029122853_ever_5978.csv 171,267 177.9 MB
Total 171,267 177.9 MB

Column Summary

# Column Type PostgreSQL Nullable Nulls Unique
1 MANDT integer INTEGER No 0.00% 0
2 VERTRAG string VARCHAR(15) No 0.00% 0
3 BUKRS string VARCHAR(6) No 0.00% 0
4 SPARTE string VARCHAR(3) No 0.00% 0
5 EIGENVERBR string VARCHAR(1) Yes 100.00% 0
6 KOFIZ string VARCHAR(3) No 0.00% 0
7 PORTION string VARCHAR(12) No 0.00% 0
8 ABSLANFO integer INTEGER Yes 76.98% 0
9 ABSZYK string VARCHAR(3) Yes 98.65% 0
10 ABSMNANP string VARCHAR(1) Yes 99.61% 0
11 GEMFAKT integer INTEGER No 0.00% 0
12 MANABR string VARCHAR(1) Yes 100.00% 0
13 ABRSPERR string VARCHAR(3) Yes 99.83% 0
14 ABRFREIG string VARCHAR(3) Yes 100.00% 0
15 BSTATUS string VARCHAR(3) Yes 50.46% 0
16 KOSTL string VARCHAR(15) No 0.00% 0
17 VBEZ string VARCHAR(52) No 0.00% 0
18 VBEGINN string VARCHAR(12) No 0.00% 0
19 EINZDAT_ALT string VARCHAR(12) No 0.00% 0
20 VENDE string VARCHAR(12) No 0.00% 0
21 KUENDDAT string VARCHAR(12) No 0.00% 0
22 KFRIST string VARCHAR(4) No 0.00% 0
23 KUENPER integer INTEGER Yes 93.00% 0
24 VBISDAT string VARCHAR(12) No 0.00% 0
25 VERLAENG string VARCHAR(4) No 0.00% 0
26 VERPER integer INTEGER Yes 93.11% 0
27 VABSCHLEVU string VARCHAR(12) No 0.00% 0
28 VABSCHLKND string VARCHAR(12) No 0.00% 0
29 VABSCHLKNDTI string VARCHAR(9) No 0.00% 0
30 PERSNR string VARCHAR(12) No 0.00% 0
31 VREFER string VARCHAR(30) No 0.00% 0
32 ERDAT integer INTEGER No 0.00% 0
33 ERNAM string VARCHAR(18) No 0.00% 0
34 AEDAT string VARCHAR(12) No 0.00% 0
35 AENAM string VARCHAR(18) No 0.00% 0
36 BEGRU string VARCHAR(6) No 0.00% 0
37 LOEVM string VARCHAR(1) Yes 92.74% 0
38 TXJCD string VARCHAR(22) No 0.00% 0
39 MANOUTSORT string VARCHAR(12) No 0.00% 0
40 FAKTURIERT string VARCHAR(1) Yes 29.11% 0
41 AUFNR string VARCHAR(18) No 0.00% 0
42 PS_PSP_PNR string VARCHAR(12) No 0.00% 0
43 PRCTR string VARCHAR(15) No 0.00% 0
44 COPAKONT string VARCHAR(1) No 0.00% 0
45 AUSGRUP string VARCHAR(12) No 0.00% 0
46 OUTCOUNT string VARCHAR(3) No 0.00% 0
47 PYPLT string VARCHAR(6) No 0.00% 0
48 PYPLS string VARCHAR(3) No 0.00% 0
49 GSBER string VARCHAR(6) No 0.00% 0
50 SEGMENT string VARCHAR(15) No 0.00% 0
51 SERVICEID string VARCHAR(15) No 0.00% 0
52 SRVPRVREF string VARCHAR(45) No 0.00% 0
53 BILLMETHOD string VARCHAR(1) Yes 100.00% 0
54 STAGRUVER string VARCHAR(3) Yes 0.00% 0
55 PYPLA string VARCHAR(3) No 0.00% 0
56 BILLFINIT string VARCHAR(1) Yes 29.10% 0
57 BFA_DEB_STAT string VARCHAR(1) Yes 100.00% 0
58 BFA_CRED_STAT string VARCHAR(1) Yes 100.00% 0
59 SALESEMPLOYEE string VARCHAR(12) No 0.00% 0
60 SALESPARTNER string VARCHAR(15) No 0.00% 0
61 SALESDOCUMENT string VARCHAR(15) No 0.00% 0
62 PS_STARTDAT string VARCHAR(12) No 0.00% 0
63 SERVPROV_PAY string VARCHAR(6) No 0.00% 0
64 INVOICING_PARTY string VARCHAR(15) No 0.00% 0
65 COKEY string VARCHAR(15) No 0.00% 0
66 BUPLA string VARCHAR(6) No 0.00% 0
67 CONTRACTCLASS string VARCHAR(6) No 0.00% 0
68 CANCREASON string VARCHAR(1) Yes 100.00% 0
69 CANCREASON_NEW string VARCHAR(6) No 0.00% 0
70 EXTRAPOLWASTE string VARCHAR(1) Yes 100.00% 0
71 PPM_CONTRACT string VARCHAR(1) Yes 100.00% 0
72 OSB_GROUP string VARCHAR(1) Yes 100.00% 0
73 OUCONT string VARCHAR(1) Yes 100.00% 0
74 RULEGR string VARCHAR(15) No 0.00% 0
75 REGIOGROUP string VARCHAR(12) No 0.00% 0
76 CMGRP string VARCHAR(1) Yes 100.00% 0
77 STRAT string VARCHAR(1) Yes 100.00% 0
78 CPERS string VARCHAR(15) No 0.00% 0
79 ANLAGE string VARCHAR(15) No 0.00% 0
80 VKONTO string VARCHAR(18) No 0.00% 0
81 KZSONDEINZ integer INTEGER Yes 100.00% 0
82 KZSONDAUSZ integer INTEGER Yes 99.99% 0
83 AUTEIGEINZ string VARCHAR(1) Yes 100.00% 0
84 EINZDAT string VARCHAR(12) No 0.00% 0
85 AUSZDAT string VARCHAR(12) No 0.00% 0
86 ABSSTOPDAT string VARCHAR(12) No 0.00% 0
87 SCHLFAKT string VARCHAR(1) Yes 100.00% 0
88 MAHNV string VARCHAR(3) Yes 97.51% 0
89 MAHNVUMZ string VARCHAR(1) Yes 100.00% 0
90 MANSP string VARCHAR(1) Yes 100.00% 0
91 BEZUG string VARCHAR(1) Yes 99.99% 0
92 TRANSVER string VARCHAR(15) No 0.00% 0
93 SSWTCREASON string VARCHAR(1) Yes 100.00% 0
94 XVERA string VARCHAR(1) Yes 71.48% 0
95 COLOGRP_INST string VARCHAR(18) No 0.00% 0
96 ZZBEGLEITBRIEF integer INTEGER Yes 30.14% 0
97 ZZERIDAT1 string VARCHAR(12) No 0.00% 0
98 ZZERIDAT2 string VARCHAR(12) No 0.00% 0
99 ZZPERNR string VARCHAR(12) No 0.00% 0
100 ZZFAEDA string VARCHAR(12) No 0.00% 0
101 ZZPRAE string VARCHAR(1) Yes 99.91% 0
102 ZZFOEB string VARCHAR(1) Yes 99.54% 0
103 ZZRVERTRAG string VARCHAR(15) No 0.00% 0
104 ZZKOSTL string VARCHAR(15) No 0.00% 0
105 ZZOUTL_CONT string VARCHAR(15) No 0.00% 0
106 ZZOUCONT string VARCHAR(1) Yes 99.90% 0
107 /SAPCE/FKRU_IND string VARCHAR(15) No 0.00% 0
108 /SAPCE/FKRU_MIN string VARCHAR(7) No 0.00% 0
109 /SAPCE/FKRU_COT string VARCHAR(3) No 0.00% 0
110 /SAPCE/IURU_RAO string VARCHAR(7) No 0.00% 0
111 /SAPCE/BBWK string VARCHAR(12) No 0.00% 0
112 /SAPCE/FIX string VARCHAR(1) Yes 100.00% 0
113 /SAPCE/WAERS string VARCHAR(7) No 0.00% 0
114 /SAPCE/TRAPBP numeric NUMERIC(12,2) No 0.00% 0
115 /SAPCE/LIMAMT numeric NUMERIC(12,2) No 0.00% 0
116 /SAPCE/DUEDAY string VARCHAR(3) No 0.00% 0
117 /SAPCE/DUEDAY1 string VARCHAR(3) No 0.00% 0
118 /SAPCE/PERC1 numeric NUMERIC(12,2) No 0.00% 0
119 /SAPCE/DUEDAY2 string VARCHAR(3) No 0.00% 0
120 /SAPCE/PERC2 numeric NUMERIC(12,2) No 0.00% 0
121 /SAPCE/DUEDAY3 string VARCHAR(3) No 0.00% 0
122 /SAPCE/PERC3 numeric NUMERIC(12,2) No 0.00% 0
123 /SAPCE/DUEDAY4 string VARCHAR(3) No 0.00% 0
124 /SAPCE/PERC4 numeric NUMERIC(12,2) No 0.00% 0
125 /SAPCE/DUEDAY5 string VARCHAR(3) No 0.00% 0
126 /SAPCE/PERC5 numeric NUMERIC(12,2) No 0.00% 0
127 /SAPCE/BILPER_AP string VARCHAR(1) Yes 100.00% 0
128 /SAPCE/V_ABRMENGE numeric NUMERIC(12,2) No 0.00% 0
129 /SAPCE/Q_UOM string VARCHAR(1) Yes 100.00% 0

Detailed Column Profiles

1. MANDT

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

100

2. VERTRAG

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

0001334400, 0001034348, 0001313179, 0001334439, 0001286479

3. BUKRS

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values: 

0100, 6000, 0300, 0500

4. SPARTE

Type: string → VARCHAR(3)
Nullable: No

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

Sample Values: 

01, 03, 06, 07

5. EIGENVERBR

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 0 (0.0%)
Null 171,267 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

(no data)

6. KOFIZ

Type: string → VARCHAR(3)
Nullable: No

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

Sample Values: 

01, 21, 04, 02, 03

7. PORTION

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

8. ABSLANFO

Type: integer → INTEGER
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 39,430 (23.0%)
Null 131,837 (76.98%)
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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

3, 2, 1

9. ABSZYK

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 2,311 (1.3%)
Null 168,956 (98.65%)
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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

00, 06, 03, 02, 01

10. ABSMNANP

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 667 (0.4%)
Null 170,600 (99.61%)
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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

X

11. GEMFAKT

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

3, 1, 2

12. MANABR

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 4 (0.0%)
Null 171,263 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

X

13. ABRSPERR

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 286 (0.2%)
Null 170,981 (99.83%)
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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

01, 03, 05, 02

14. ABRFREIG

Type: string → VARCHAR(3)
Nullable: Yes

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

Sample Values: 

01

15. BSTATUS

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 84,847 (49.5%)
Null 86,420 (50.46%)
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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

08, 03, 07, 05, 02

16. KOSTL

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

17. VBEZ

Type: string → VARCHAR(52)
Nullable: No

Metric Value
Total Rows 171,267
Non-null 171,267 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 35
Avg Length 0.0
Buffered Length 52 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

                                   , Vertrag Erdgas Zürich AG           , Vertrag Liegenschaftenverwaltung ST, Staffel                            , Vertrag 09902  Regionalwerke AG Bad

18. VBEGINN

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000, 19000101, 20160701, 20190101, 20010403

19. EINZDAT_ALT

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000, 20130107, 20210303, 20130211, 20130809

20. VENDE

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000, 19000101, 99991231, 20190630, 20191231

21. KUENDDAT

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000, 20181231, 20060930, 20190831, 20210630

22. KFRIST

Type: string → VARCHAR(4)
Nullable: No

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

Sample Values: 

000, 006, 012, 004, 001

23. KUENPER

Type: integer → INTEGER
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 11,990 (7.0%)
Null 159,277 (93.00%)
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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

1, 2, 0

24. VBISDAT

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000, 20210630, 20201231, 20090930, 20231231

25. VERLAENG

Type: string → VARCHAR(4)
Nullable: No

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

Sample Values: 

000, 001, 002, 012, 024

26. VERPER

Type: integer → INTEGER
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 11,801 (6.9%)
Null 159,466 (93.11%)
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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

2, 0, 1, 3

27. VABSCHLEVU

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000, 20160531, 20181127, 20110330, 20100721

28. VABSCHLKND

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000, 20160607, 20181203, 20110331, 20100721

29. VABSCHLKNDTI

Type: string → VARCHAR(9)
Nullable: No

Metric Value
Total Rows 171,267
Non-null 171,267 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 6
Avg Length 0.0
Buffered Length 9 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

000000,       , 102743

30. PERSNR

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000, 08050298, 08047589

31. VREFER

Type: string → VARCHAR(30)
Nullable: No

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

Sample Values: 

                    , Staffel             , Fernwärme           , VorVtrg Staffel     , VorVtrg Fernwärme

32. ERDAT

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

20010419, 20010420, 20081220, 20131016, 20241010

33. ERNAM

Type: string → VARCHAR(18)
Nullable: No

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

Sample Values: 

HALBHERR    , JOGGI       , VOGEL       , ZUPPIGER    , JOBADMIN

34. AEDAT

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

20180612, 00000000, 20180613, 20180611, 20181117

35. AENAM

Type: string → VARCHAR(18)
Nullable: No

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

Sample Values: 

JOBADMIN    , FINK        ,             , ZUPPIGER    , ERNI01

36. BEGRU

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

37. LOEVM

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 12,440 (7.3%)
Null 158,827 (92.74%)
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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

X

38. TXJCD

Type: string → VARCHAR(22)
Nullable: No

Metric Value
Total Rows 171,267
Non-null 171,267 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 15
Avg Length 0.0
Buffered Length 22 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 171,267 - Parse Success: 171,267 / 171,267

Sample Values:

39. MANOUTSORT

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

40. FAKTURIERT

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 121,417 (70.9%)
Null 49,850 (29.11%)
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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

X

41. AUFNR

Type: string → VARCHAR(18)
Nullable: No

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

Sample Values:

42. PS_PSP_PNR

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000

43. PRCTR

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

          , PC_1_G    , PC_1_HT

44. COPAKONT

Type: string → VARCHAR(1)
Nullable: No

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

Sample Values: 

X

45. AUSGRUP

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

        , 0100    , 0101    , 0102    , 0103

46. OUTCOUNT

Type: string → VARCHAR(3)
Nullable: No

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

Sample Values: 

00

47. PYPLT

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

48. PYPLS

Type: string → VARCHAR(3)
Nullable: No

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

Sample Values: 

00

49. GSBER

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

50. SEGMENT

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

51. SERVICEID

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

GN_EGZ    ,           , GL_EGZ    , GL_ENER360, GN_SÄNTISE

52. SRVPRVREF

Type: string → VARCHAR(45)
Nullable: No

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

Sample Values:

53. BILLMETHOD

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 0 (0.0%)
Null 171,267 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

(no data)

54. STAGRUVER

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 171,264 (100.0%)
Null 3 (0.00%)
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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

01

55. PYPLA

Type: string → VARCHAR(3)
Nullable: No

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

Sample Values: 

00

56. BILLFINIT

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 121,425 (70.9%)
Null 49,842 (29.10%)
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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

X

57. BFA_DEB_STAT

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 0 (0.0%)
Null 171,267 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

(no data)

58. BFA_CRED_STAT

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 0 (0.0%)
Null 171,267 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

(no data)

59. SALESEMPLOYEE

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000

60. SALESPARTNER

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

61. SALESDOCUMENT

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

62. PS_STARTDAT

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000

63. SERVPROV_PAY

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

64. INVOICING_PARTY

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

GN_EGZ    ,           , GL_EGZ    , GL_ENER360, GN_SÄNTISE

65. COKEY

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

P101000001, P101000004, P101000002, KONT_UE   ,

66. BUPLA

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

67. CONTRACTCLASS

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

68. CANCREASON

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 0 (0.0%)
Null 171,267 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

(no data)

69. CANCREASON_NEW

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

70. EXTRAPOLWASTE

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 0 (0.0%)
Null 171,267 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

(no data)

71. PPM_CONTRACT

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 0 (0.0%)
Null 171,267 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

(no data)

72. OSB_GROUP

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 0 (0.0%)
Null 171,267 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

(no data)

73. OUCONT

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 0 (0.0%)
Null 171,267 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

(no data)

74. RULEGR

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

75. REGIOGROUP

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

        , K0011

76. CMGRP

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 0 (0.0%)
Null 171,267 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

(no data)

77. STRAT

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 0 (0.0%)
Null 171,267 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

(no data)

78. CPERS

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

79. ANLAGE

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

          , 0002022237, 0002007043, 0002016551, 0002016412

80. VKONTO

Type: string → VARCHAR(18)
Nullable: No

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

Sample Values: 

000001077539, 000001104648, 000001065520, 000001121394, 000001121173

81. KZSONDEINZ

Type: integer → INTEGER
Nullable: Yes

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

Sample Values: 

8

82. KZSONDAUSZ

Type: integer → INTEGER
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 13 (0.0%)
Null 171,254 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

1, 8

83. AUTEIGEINZ

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 0 (0.0%)
Null 171,267 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

(no data)

84. EINZDAT

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000, 20090101, 20131001, 20241001, 20010403

85. AUSZDAT

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

99991231, 00000000, 20240930, 20130930, 20250331

86. ABSSTOPDAT

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000, 20240930, 20130930, 20250331, 20250430

87. SCHLFAKT

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 0 (0.0%)
Null 171,267 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

(no data)

88. MAHNV

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 4,261 (2.5%)
Null 167,006 (97.51%)
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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

M1, M4

89. MAHNVUMZ

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 0 (0.0%)
Null 171,267 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

(no data)

90. MANSP

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 0 (0.0%)
Null 171,267 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

(no data)

91. BEZUG

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 14 (0.0%)
Null 171,253 (99.99%)
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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

X

92. TRANSVER

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

93. SSWTCREASON

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 0 (0.0%)
Null 171,267 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

(no data)

94. XVERA

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 48,850 (28.5%)
Null 122,417 (71.48%)
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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

X

95. COLOGRP_INST

Type: string → VARCHAR(18)
Nullable: No

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

Sample Values:

96. ZZBEGLEITBRIEF

Type: integer → INTEGER
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 119,647 (69.9%)
Null 51,620 (30.14%)
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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

1, 9, 2, 0, 7

97. ZZERIDAT1

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000, 20110804, 20290901, 20290717, 20300817

98. ZZERIDAT2

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000, 20260630, 20120813, 20120216, 20120810

99. ZZPERNR

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000, 00000710, 00000867, 00000927, 00000853

100. ZZFAEDA

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000, 20120915, 20120830, 20120515, 20120401

101. ZZPRAE

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 160 (0.1%)
Null 171,107 (99.91%)
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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

X

102. ZZFOEB

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 785 (0.5%)
Null 170,482 (99.54%)
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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

X

103. ZZRVERTRAG

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

          , 0008034445, 0008044501, 0008045210, 0008019787

104. ZZKOSTL

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

          , 0000015100, 0000015062, 0000050003, 0000005978

105. ZZOUTL_CONT

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

          , 0001210159, 0001331562, 0001316534, 0001309298

106. ZZOUCONT

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 174 (0.1%)
Null 171,093 (99.90%)
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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

X

107. /SAPCE/FKRU_IND

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

108. /SAPCE/FKRU_MIN

Type: string → VARCHAR(7)
Nullable: No

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

Sample Values: 

00000

109. /SAPCE/FKRU_COT

Type: string → VARCHAR(3)
Nullable: No

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

Sample Values: 

00

110. /SAPCE/IURU_RAO

Type: string → VARCHAR(7)
Nullable: No

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

Sample Values:

111. /SAPCE/BBWK

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

112. /SAPCE/FIX

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 0 (0.0%)
Null 171,267 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

(no data)

113. /SAPCE/WAERS

Type: string → VARCHAR(7)
Nullable: No

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

Sample Values:

114. /SAPCE/TRAPBP

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

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

Sample Values: 

0.0

115. /SAPCE/LIMAMT

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

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

Sample Values: 

0.0

116. /SAPCE/DUEDAY

Type: string → VARCHAR(3)
Nullable: No

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

Sample Values: 

00

117. /SAPCE/DUEDAY1

Type: string → VARCHAR(3)
Nullable: No

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

Sample Values: 

00

118. /SAPCE/PERC1

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

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

Sample Values: 

0.0

119. /SAPCE/DUEDAY2

Type: string → VARCHAR(3)
Nullable: No

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

Sample Values: 

00

120. /SAPCE/PERC2

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

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

Sample Values: 

0.0

121. /SAPCE/DUEDAY3

Type: string → VARCHAR(3)
Nullable: No

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

Sample Values: 

00

122. /SAPCE/PERC3

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

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

Sample Values: 

0.0

123. /SAPCE/DUEDAY4

Type: string → VARCHAR(3)
Nullable: No

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

Sample Values: 

00

124. /SAPCE/PERC4

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

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

Sample Values: 

0.0

125. /SAPCE/DUEDAY5

Type: string → VARCHAR(3)
Nullable: No

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

Sample Values: 

00

126. /SAPCE/PERC5

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

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

Sample Values: 

0.0

127. /SAPCE/BILPER_AP

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 0 (0.0%)
Null 171,267 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

(no data)

128. /SAPCE/V_ABRMENGE

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

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

Sample Values: 

0.0

129. /SAPCE/Q_UOM

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 171,267
Non-null 0 (0.0%)
Null 171,267 (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: 171,267 - Parse Success: 171,267 / 171,267

Sample Values: 

(no data)

PostgreSQL DDL

See ever_schema.sql

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