SAP ABAP Table ERCHZ (Individual Line Items: Internal)
Hierarchy
IS-UT (Software Component) SAP Utilities/Telecommunication
   IS-U-BI (Application Component) Contract Billing
     EE20 (Package) IS-U: Billing
Basic Data
Table Category INTTAB    Structure 
Structure ERCHZ   Table Relationship Diagram
Short Description Individual Line Items: Internal    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client *
2 BELNR E_BELNR E_BELNR CHAR 12   0   Number of a billing document  
3 BELZEILE BELZEILE LFDNR6 NUMC 6   0   Billing line item for billing documents  
4 .INCLUDE       0   0   Internal billing fields of ERCHZ  
5 UNIMPORTANT UNIMPORTANT KENNZX CHAR 1   0   Internal only: Do not archive line item  
6 GROSSBLOCK GROSSBLOCK GROSSBLOCK CHAR 4   0   Gross row block  
7 OLD_ERCHZ OLD_ERCHZ KENNZX CHAR 1   0   ERCHZ was read from the old structure  
8 ISTYPE BU_ISTYPE BU_ISTYPE CHAR 4   0   Industry System TB038
9 .INCLUDE       0   0   Substructure of document line items: Always filled data  
10 CSNO CSNO LFDSCHEM NUMC 6   0   Sequence number of schema step during billing  
11 BELZART BELZART BELZART CHAR 6   0   Line Item Type TE835
12 ABSLKZ ABSLKZ KENNZX CHAR 1   0   Billing Line Item for Budget Billing Amount Determination  
13 DIFFKZ DIFFKZ KENNZX CHAR 1   0   Indicator: difference line item for discount statistics  
14 BUCHREL BUCHREL KENNZX CHAR 1   0   Billing Line Item Relevant to Posting  
15 MENGESTREL MENGESTREL MENGREL CHAR 1   0   Quantity (billed value) is statistically relevant  
16 BETRSTREL BETRSTREL KENNZX CHAR 1   0   Amount of billing line item is statistically relevant  
17 STGRQNT STGRQNT STGRQNT CHAR 6   0   Quantity statistics group *
18 STGRAMT STGRAMT STGRAMT CHAR 6   0   Amount statistics group *
19 PRINTREL PRINTREL KENNZX CHAR 1   0   Billing Line Is Print-Relevant  
20 AKLASSE AKLASSE AKLASSE CHAR 4   0   Billing class *
21 BRANCHE BU_IND_SECTOR BU_INDSECTOR CHAR 10   0   Industry TB038A
22 TVORG TVORG_KK TVORG_KK CHAR 4   0   Subtransaction for Document Item TFKTVO
23 GEGEN_TVORG GEGEN_TVORG TVORG_KK CHAR 4   0   Offsetting trans. for sub-transaction of billing line item TFKTVO
24 TAX_TVORG TAX_TVORG TVORG_KK CHAR 4   0   Subtransaction for tax determination for BB line items *
25 LINESORT LINESORT LINESORT CHAR 4   0   Presorting of billing line items in billing schema TE530
26 AB ABZEITSCH DATUM DATS 8   0   Date from which time slice is valid  
27 BIS BISZEITSCH DATUM DATS 8   0   Date at Which a Time Slice Expires  
28 TIMTYPZA TIMTYPZA TIMTYP CHAR 1   0   Time category (days or months) for billing line item  
29 SCHEMANR SCHEMANR SCHEMANR CHAR 10   0   Number of the billing schema *
30 SNO SNO LFDNR4 NUMC 4   0   Sequence number of schema step in billing schema  
31 PROGRAMM E_PROGRAMM E_PROGRAMM CHAR 8   0   Variant program *
32 MASSBILL E_MASSBILL MEINS UNIT 3   0   Unit of measurement for billing T006
33 SAISON SAISON E_OPERAND CHAR 10   0   Season *
34 TIMBASIS TIMBASIS TIMBASIS CHAR 3   0   Time Basis  
35 TIMTYP TIMTYP TIMTYP CHAR 1   0   Time category (days or months)  
36 FRAN_TYPE FRAN_TYPE FRAN_TYPE CHAR 1   0   Franchise Fee Category  
37 KONZIGR KONZIGR KONZIGR CHAR 10   0   Franchise fee group TE241
38 TARIFTYP TARIFTYP TARIFTYP CHAR 10   0   Rate category *
39 TARIFNR TARIFNR TARIFNR CHAR 10   0   Rate key *
40 KONDIGR KONDIGR KONDIGR CHAR 10   0   Rate fact group TE067
41 STTARIF STTARIF STTARIFNR CHAR 10   0   Statistical rate  
42 GEWKEY GEWKEY GEWKEY CHAR 8   0   Weighting key TE266
43 WDHFAKT WDHFAKT E_FAKTOR INT4 10   0   Repetition factor for reference values  
44 TEMP_AREA TEMP_AREA TEMP_AREA CHAR 8   0   Temperature area TE307
45 DRCKSTUF DRCKSTUF DRCKSTUF CHAR 2   0   Gas pressure level  
46 ABGGRND1 ABGGRND ABGGRND CHAR 4   0   Reason for proration TE661
47 ABGGRND2 ABGGRND ABGGRND CHAR 4   0   Reason for proration TE661
48 ABGGRND3 ABGGRND ABGGRND CHAR 4   0   Reason for proration TE661
49 ABGGRND4 ABGGRND ABGGRND CHAR 4   0   Reason for proration TE661
50 ABGGRND5 ABGGRND ABGGRND CHAR 4   0   Reason for proration TE661
51 ABGGRND6 ABGGRND ABGGRND CHAR 4   0   Reason for proration TE661
52 ABGGRND7 ABGGRND ABGGRND CHAR 4   0   Reason for proration TE661
53 ABGGRND8 ABGGRND ABGGRND CHAR 4   0   Reason for proration TE661
54 ABGGRND9 ABGGRND ABGGRND CHAR 4   0   Reason for proration TE661
55 ABGGRND10 ABGGRND ABGGRND CHAR 4   0   Reason for proration TE661
56 EIN01 EINOPERAND E_OPERAND CHAR 10   0   Input operand *
57 EIN02 EINOPERAND E_OPERAND CHAR 10   0   Input operand *
58 EIN03 EINOPERAND E_OPERAND CHAR 10   0   Input operand *
59 EIN04 EINOPERAND E_OPERAND CHAR 10   0   Input operand *
60 AUS01 AUSOPERAND E_OPERAND CHAR 10   0   Output operand *
61 AUS02 AUSOPERAND E_OPERAND CHAR 10   0   Output operand *
62 MASS1 E_MASS MEINS UNIT 3   0   Unit of Measurement T006
63 MASS2 E_MASS MEINS UNIT 3   0   Unit of Measurement T006
64 MASS3 E_MASS MEINS UNIT 3   0   Unit of Measurement T006
65 MASS4 E_MASS MEINS UNIT 3   0   Unit of Measurement T006
66 DATUM1 DATUM DATUM DATS 8   0   Date  
67 DATUM2 DATUM DATUM DATS 8   0   Date  
68 RABZUS RABZUS RABZUS CHAR 10   0   Discount key *
69 BACKCANC01 BACKCANC01 BACKGROUP CHAR 4   0   Indicator: reverse backbilling *
70 BACKCANC02 BACKCANC02 BACKGROUP CHAR 4   0   Indicator: reverse backbilling *
71 BACKCANC03 BACKCANC03 BACKGROUP CHAR 4   0   Indicator: reverse backbilling *
72 BACKCANC04 BACKCANC04 BACKGROUP CHAR 4   0   Indicator: reverse backbilling *
73 BACKCANC05 BACKCANC05 BACKGROUP CHAR 4   0   Indicator: reverse backbilling *
74 BACKCANC BACKCANC BACKGROUP CHAR 4   0   Indicator: Reverse Backbilling *
75 BACKEXEC BACKEXEC BACKGROUP CHAR 4   0   Indicator: allocate backbilling *
76 BACKDOCNO BACKDOCNO E_BELNR CHAR 12   0   Number of a billing document  
77 BACKDOCLINE BACKDOCLINE LFDNR6 NUMC 6   0   Billing line item for billing documents  
78 DYNCANC01 DYNCANC01 DYNGROUP CHAR 4   0   Schema steps for reversal in dynamic period control 1 *
79 DYNCANC02 DYNCANC02 DYNGROUP CHAR 4   0   Reversal indicator, dynamic period control 2 *
80 DYNCANC03 DYNCANC03 DYNGROUP CHAR 4   0   Reversal indicator, dynamic period control 3 *
81 DYNCANC04 DYNCANC04 DYNGROUP CHAR 4   0   Reversal Indicator, Dynamic Period Control 4 *
82 DYNCANC05 DYNCANC05 DYNGROUP CHAR 4   0   Reversal indicator, dynamic period control 5 *
83 DYNCANC DYNCANC DYNGROUP CHAR 4   0   Indicator: Reverse Backbilling *
84 DYNEXEC DYNEXEC DYNGROUP CHAR 4   0   Indicator: Allocate Backbilling *
85 LRATESTEP LRATESTEP LRATESTEP NUMC 10   0   Logical Number of Rate Step  
86 PEB PEB KENNZX CHAR 1   0   Indicator: billing line item relates to period-end billing  
87 OPLFDNR OPLFDNR LFDNR4 NUMC 4   0   Consecutive number of an operand  
88 STAFO STAFO STAFO CHAR 6   0   Update group for statistics update *
89 ARTMENGE ARTMENGE ARTMENGE CHAR 1   0   Classification of billed quantity for statistics  
90 STATTART STATTART TARIFART CHAR 8   0   Rate type for statistical analysis TE069
91 TIMECONTRL TIMECONTRL TIMECONTRL CHAR 2   0   Period control *
92 TCNUMTOR TCNUMTOR TCNUMTOR DEC 8   4   Numerator of the time portion in a time slice  
93 TCDENOMTOR TCDENOMTOR TCDENOMTOR DEC 8   4   Denominator of the time portion in a time slice  
94 TIMTYPQUOT TIMTYPQUOT TIMTYP CHAR 1   0   Time category of meter for time portion of a time slice  
95 AKTIV E_AKTIV E_AKTIV CHAR 1   0   Meter reading active  
96 KONZVER KONZVER KONZVER CHAR 10   0   Franchise contract *
97 PERTYP BILLPERTYP BILLPERTYP CHAR 2   0   Category of the internal billing period  
98 ERCHV_ANCHOR ERCHV_ANCHOR KENNZX CHAR 1   0   Anchor Line for DBERCHV Entry  
99 OUCONTRACT OUCONTRACT VERTRAG CHAR 10   0   Master Agreement for Individual Contract *
100 .INCLUDE       0   0    
101 .INCLUDE       0   0   Substructure of document line items, device data  
102 EQUNR EQUNR EQUNR CHAR 18   0   Equipment Number *
103 GERAET GERAET GERNR CHAR 18   0   Device  
104 MATNR MATNR MATNR CHAR 18   0   Material Number *
105 ZWNUMMER E_ZWNUMMER LFDNR3 NUMC 3   0   Register  
106 INDEXNR INDEXNR INDEXNR NUMC 12   0   Consecutive number of register relationship  
107 ABLESGR ABLESGR ABLESGR CHAR 2   0   Meter reading reason TE609
108 ABLESGRV ABLESGRV ABLESGR CHAR 2   0   Previous meter reading reason TE609
109 ATIM ATIM HHMM CHAR 4   0   Meter reading time (relevant to billing)  
110 ATIMVA ATIMVA HHMM CHAR 4   0   Time of day of previous meter reading  
111 ADATMAX ADATMAX DATUM DATS 8   0   Date of maximum meter reading  
112 ATIMMAX ATIMMAX HHMM CHAR 4   0   Time of maximum meter reading  
113 THGDATUM THGDATUM DATUM DATS 8   0   Gas allocation date  
114 ZUORDDAT E_ZUORDDAT DATUM DATS 8   0   Meter reading allocation date  
115 REGRELSORT REGRELSORT REGRELSORT NUMC 2   0   Sort help for register relationships during bill printout  
116 ABLBELNR ABLBELNR ABLBELNR CHAR 20   0   Internal ID for meter reading document *
117 LOGIKNR LOGIKNR LOGIKNR NUMC 18   0   Logical device number  
118 LOGIKZW LOGIKZW LOGIKZW NUMC 18   0   Logical register number  
119 ISTABLART ISTABLART ISTABLART CHAR 2   0   Meter reading type *
120 ISTABLARTVA ISTABLARTVA ISTABLART CHAR 2   0   Meter reading type of previous meter reading *
121 EXTPKZ EXTPKZ ORIGIN_ESTIM CHAR 1   0   Simulation indicator for meter reading results  
122 BEGPROG BEGPROG DATUM DATS 8   0   Start of forecast period  
123 ENDEPROG ENDEPROG DATUM DATS 8   0   End of forecast period  
124 ABLHINW ABLHINW ABLHINW CHAR 4   0   Note from meter reader *
125 .INCLUDE       0   0   Substructure of document line items, amounts and prices  
126 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code *
127 ERMWSKZ ERMWSKZ ERMWSKZ CHAR 2   0   Indicator: Tax Determination Code *
128 NETTOBTR NETTOBTR WRTV7 CURR 13   2   Net amount of billing line item  
129 TWAERS TWAERS WAERS CUKY 5   0   Transaction Currency TCURC
130 PREISTUF PREISTUF PREISTUF CHAR 10   0   Price level TE471
131 PREISTYP PREISTYP PREISTYP CHAR 1   0   Price category  
132 PREIS E_PREIS E_PREIS CHAR 10   0   Price *
133 PREISZUS PREISZUS KENNZ4 CHAR 4   0   Indicator: Price Summary  
134 VONZONE VONZONE E_ZONE NUMC 10   0   From-block  
135 BISZONE BISZONE E_ZONE NUMC 10   0   To-block  
136 ZONENNR E_ZONENNR E_ZONENNR NUMC 3   0   Number of price block or price scale  
137 PREISBTR PRSBTR PRSBTR DEC 17   8   Price amount  
138 MNGBASIS MENGENBAS MENGENBAS DEC 9   2   Long quantity base for amount  
139 PREIGKL PREIGKL PREIGKL CHAR 10   0   Price adjustment clause *
140 URPREIS URPREIS PRSBTR DEC 17   8   Base price to which the price adjustment clause relates  
141 PREIADD PREIADD PRSBTR DEC 17   8   Price to be added for price adjustment  
142 PREIFAKT PREIFAKT PREIFAKT DEC 12   7   Price adjustment factor  
143 OPMULT OPMULT KENZX CHAR 1   0   Addition first  
144 TXDAT_KK TXDAT_KK DATUM DATS 8   0   Decisive Date for Calculating Taxes  
145 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center CEPC
146 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center CSKS
147 PS_PSP_PNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) PRPS
148 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
149 PAOBJNR RKEOBJNR RKEOBJNR NUMC 10   0   Profitability Segment Number (CO-PA)  
150 PAOBJNR_S RKEOBJNR_S RKEOBJNR NUMC 10   0   Profitability Segment No. for CO-PA Post. Acc. to Cons. Mth  
151 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
152 APERIODIC APERIODIC KENNZX CHAR 1   0   Non-Periodic Posting  
153 GROSSGROUP GROSSGROUP GROSSGROUP CHAR 4   0   Gross group  
154 BRUTTOZEILE BRUTTOZEILE KENNZX CHAR 1   0   Blling line item is a gross line item  
155 BUPLA BUPLA J_1BBRANCH CHAR 4   0   Business Place *
156 LINE_CLASS LINE_CLASS LINE_CLASS CHAR 4   0   Classification Criteria for Billing Line  
157 PREISART E_PREISART E_PREISART CHAR 1   0   Price type  
158 .INCLUDE       0   0   Substructure of document line items, rarely used fields  
159 LEUCHTNR LEUCHTNR LEUCHTNR CHAR 10   0   External lighting number  
160 BETRART BETRART BETRART CHAR 4   0   Operation Type for Lighting Unit TE497
161 SPGRUND SPGRUND SPGRUND CHAR 2   0   Disconnection reason *
162 EIN05 EINOPERAND E_OPERAND CHAR 10   0   Input operand *
163 EIN06 EINOPERAND E_OPERAND CHAR 10   0   Input operand *
164 EIN07 EINOPERAND E_OPERAND CHAR 10   0   Input operand *
165 EIN08 EINOPERAND E_OPERAND CHAR 10   0   Input operand *
166 EIN09 EINOPERAND E_OPERAND CHAR 10   0   Input operand *
167 EIN10 EINOPERAND E_OPERAND CHAR 10   0   Input operand *
168 AUS03 AUSOPERAND E_OPERAND CHAR 10   0   Output operand *
169 AUS04 AUSOPERAND E_OPERAND CHAR 10   0   Output operand *
170 AUS05 AUSOPERAND E_OPERAND CHAR 10   0   Output operand *
171 MASS5 E_MASS MEINS UNIT 3   0   Unit of Measurement T006
172 MASS6 E_MASS MEINS UNIT 3   0   Unit of Measurement T006
173 SC_BELNR SC_BELNR E_BELNR CHAR 12   0   Number of billing document in adjustment reversal  
174 SC_BELZEILE SC_BELZEILE LFDNR6 NUMC 6   0   Billing line item for billing documents  
175 REFBELZEILE REFBELZEILE LFDNR6 NUMC 6   0   Reference billing line item for billing documents  
176 SPERRUNG SPERRUNG KENNZX CHAR 1   0   Time slice is in a disconnection period  
177 NETTOFRMD NETTOFRMD WRTV7 CURR 13   2   Amount in foreign currency with +/- sign  
178 WAERSF WAERSF WAERS CUKY 5   0   Currency key for amount TCURC
179 UMRECHDAT UMRECHDAT UMRECHDAT DATS 8   0   Conversion Date for Foreign Currency Amount  
180 UMRECHKURS UMRECHKURS KURSF DEC 9   5   Exchange rate btwn net amount and foreign currency amount  
181 REFBELZONE REFBELZONE LFDNR6 NUMC 6   0   Ref. billing line item for documents resulting from blocking  
182 REFBILLDOCNO REFBILLDOCNO E_BELNR CHAR 12   0   Reference Document Number  
183 FIRSTBELNR FIRSTBELNR E_BELNR CHAR 12   0   Billing Document Number of First Invoiced Document  
184 TAXREL TAXREL KENNZX CHAR 1   0   Line Contains Tax Determination Quantity for Invoicing  
185 TAXGROUP TAXGROUP KENNZ4 CHAR 4   0   Categorize Amounts for Tax Determination  
186 BILLTYPE EBILLTYPE BILLTYPE_ID CHAR 6   0   Waste Billing Category  
187 OBJNR EOBJNR EOBJNR CHAR 10   0   Number of service frequency *
188 ORDERNR EORDERNR EORDERNR CHAR 20   0   Internal Number for Identifying a Waste Disposal Order *
189 LAUFNR LAUFNR NUMC5 NUMC 5   0   Consecutive number of service frequency  
190 ORDER_LAUFNR ORDER_LAUFNR NUMC4 NUMC 4   0   Consecutive Number for Waste Disposal Order Item  
191 GGVERTRAG E_GUARANTOR_CONTRACT E_GUARANTOR_CONTRACT CHAR 18   0   Guarantor Contract  
192 OLD_BELNR E_BELNR E_BELNR CHAR 12   0   Number of a billing document  
193 .INCLUDE       0   0   Substruct. for Numerical Fields ERCHZ/ERDZ  
194 I_ZWSTAND I_ZWSTAND I_ZWSTAND DEC 31   14   Meter reading recorded  
195 I_ZWSTNDAB I_ZWSTNDAB I_ZWSTAND DEC 31   14   Billed meter reading  
196 I_ZWSTVOR I_ZWSTVOR I_ZWSTAND DEC 31   14   Previous meter reading  
197 I_ABRMENGE I_ABRMENGE I_ABRMENGE DEC 31   14   Billing quantity for internal billing format  
198 I_ABRMENGEVOR I_ABRMENGEVOR I_ABRMENGE DEC 31   14   Billing Quantity: Internal Format of Previous Billing  
199 I_ZWSTDIFF I_ZWSTDIFF I_ZWSTDIFF DEC 31   14   Meter reading difference in internal format  
200 I_ZAHL1 I_ZAHL I_ZAHL DEC 31   14   Number fields in internal billing format  
201 I_ZAHL2 I_ZAHL I_ZAHL DEC 31   14   Number fields in internal billing format  
202 I_ZAHL3 I_ZAHL I_ZAHL DEC 31   14   Number fields in internal billing format  
203 I_ZAHL4 I_ZAHL I_ZAHL DEC 31   14   Number fields in internal billing format  
204 I_ZAHL5 I_ZAHL I_ZAHL DEC 31   14   Number fields in internal billing format  
205 I_ZAHL6 I_ZAHL I_ZAHL DEC 31   14   Number fields in internal billing format  
206 ZEITANT E_ZEITANT_L E_ZEITANT_L DEC 31   14   Time portion, billing period in days or months  
207 I_NETTOBTR_L I_NETTOBTR_L I_NETTOBTR_L DEC 31   14   Long Net Amount - Internal Billing Format  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ERCHZ ABGGRND1 TE661 ABGGRND    
2 ERCHZ ABGGRND10 TE661 ABGGRND    
3 ERCHZ ABGGRND2 TE661 ABGGRND    
4 ERCHZ ABGGRND3 TE661 ABGGRND    
5 ERCHZ ABGGRND4 TE661 ABGGRND    
6 ERCHZ ABGGRND5 TE661 ABGGRND    
7 ERCHZ ABGGRND6 TE661 ABGGRND    
8 ERCHZ ABGGRND7 TE661 ABGGRND    
9 ERCHZ ABGGRND8 TE661 ABGGRND    
10 ERCHZ ABGGRND9 TE661 ABGGRND    
11 ERCHZ ABLESGR TE609 ABLESGR    
12 ERCHZ ABLESGRV TE609 ABLESGR    
13 ERCHZ AUFNR AUFK AUFNR    
14 ERCHZ BELZART TE835 BELZART KEY    
15 ERCHZ BETRART TE497 BETRART KEY    
16 ERCHZ BRANCHE TB038A IND_SECTOR KEY    
17 ERCHZ GEGEN_TVORG TFKTVO TVORG    
18 ERCHZ GEWKEY TE266 GEWKEY KEY    
19 ERCHZ GSBER TGSB GSBER    
20 ERCHZ ISTYPE TB038 ISTYPE    
21 ERCHZ KONDIGR TE067 KONDIGR KEY    
22 ERCHZ KONZIGR TE241 KONZIGR KEY    
23 ERCHZ KOSTL CSKS KOSTL    
24 ERCHZ LINESORT TE530 LINESORT KEY    
25 ERCHZ MASS1 T006 MSEHI KEY    
26 ERCHZ MASS2 T006 MSEHI KEY    
27 ERCHZ MASS3 T006 MSEHI KEY    
28 ERCHZ MASS4 T006 MSEHI KEY    
29 ERCHZ MASS5 T006 MSEHI KEY    
30 ERCHZ MASS6 T006 MSEHI KEY    
31 ERCHZ MASSBILL T006 MSEHI KEY    
32 ERCHZ PRCTR CEPC PRCTR    
33 ERCHZ PREISTUF TE471 PREISTUF KEY    
34 ERCHZ PS_PSP_PNR PRPS PSPNR    
35 ERCHZ STATTART TE069 TARIFART    
36 ERCHZ TEMP_AREA TE307 TEMP_AREA KEY    
37 ERCHZ TVORG TFKTVO TVORG    
38 ERCHZ TWAERS TCURC WAERS KEY    
39 ERCHZ WAERSF TCURC WAERS    
History
Last changed by/on SAP  20130529 
SAP Release Created in