SAP ABAP Table ERCHZ_I (Substructure for Individual Line Items)
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_I   Table Relationship Diagram
Short Description Substructure for Individual Line Items    
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 CSNO CSNO LFDSCHEM NUMC 6   0   Sequence number of schema step during billing  
2 BELZART BELZART BELZART CHAR 6   0   Line Item Type TE835
3 ABSLKZ ABSLKZ KENNZX CHAR 1   0   Billing Line Item for Budget Billing Amount Determination  
4 DIFFKZ DIFFKZ KENNZX CHAR 1   0   Indicator: difference line item for discount statistics  
5 BUCHREL BUCHREL KENNZX CHAR 1   0   Billing Line Item Relevant to Posting  
6 MENGESTREL MENGESTREL MENGREL CHAR 1   0   Quantity (billed value) is statistically relevant  
7 BETRSTREL BETRSTREL KENNZX CHAR 1   0   Amount of billing line item is statistically relevant  
8 STGRQNT STGRQNT STGRQNT CHAR 6   0   Quantity statistics group *
9 STGRAMT STGRAMT STGRAMT CHAR 6   0   Amount statistics group *
10 PRINTREL PRINTREL KENNZX CHAR 1   0   Billing Line Is Print-Relevant  
11 BRUTTOZEILE BRUTTOZEILE KENNZX CHAR 1   0   Blling line item is a gross line item  
12 AKLASSE AKLASSE AKLASSE CHAR 4   0   Billing class *
13 BRANCHE BU_INDSECT BU_INDSECT CHAR 10   0   Industry sector TB023
14 TVORG TVORG_KK TVORG_KK CHAR 4   0   Subtransaction for Document Item TFKTVO
15 GEGEN_TVORG GEGEN_TVORG TVORG_KK CHAR 4   0   Offsetting trans. for sub-transaction of billing line item TFKTVO
16 LINESORT LINESORT LINESORT CHAR 4   0   Presorting of billing line items in billing schema TE530
17 AB ABZEITSCH DATUM DATS 8   0   Date from which time slice is valid  
18 BIS BISZEITSCH DATUM DATS 8   0   Date at Which a Time Slice Expires  
19 ZEITANT E_ZEITANT E_ZEITANT DEC 8   4   Time portion, billing period in days or months  
20 TIMTYPZA TIMTYPZA TIMTYP CHAR 1   0   Time category (days or months) for billing line item  
21 SCHEMANR SCHEMANR SCHEMANR CHAR 10   0   Number of the billing schema *
22 SNO SNO LFDNR4 NUMC 4   0   Sequence number of schema step in billing schema  
23 PROGRAMM E_PROGRAMM E_PROGRAMM CHAR 8   0   Variant program *
24 EQUNR EQUNR EQUNR CHAR 18   0   Equipment Number *
25 GERAET GERAET GERNR CHAR 18   0   Device  
26 MATNR MATNR MATNR CHAR 18   0   Material Number *
27 ZWNUMMER E_ZWNUMMER LFDNR3 NUMC 3   0   Register  
28 INDEXNR INDEXNR INDEXNR NUMC 12   0   Consecutive number of register relationship  
29 MASSBILL E_MASSBILL MEINS UNIT 3   0   Unit of measurement for billing T006
30 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code *
31 ERMWSKZ ERMWSKZ ERMWSKZ CHAR 2   0   Indicator: Tax Determination Code *
32 NETTOBTR NETTOBTR WRTV7 CURR 13   2   Net amount of billing line item  
33 TWAERS TWAERS WAERS CUKY 5   0   Transaction Currency TCURC
34 SAISON SAISON E_OPERAND CHAR 10   0   Season *
35 PREISTUF PREISTUF PREISTUF CHAR 10   0   Price level TE471
36 PREISTYP PREISTYP PREISTYP CHAR 1   0   Price category  
37 PREIS E_PREIS E_PREIS CHAR 10   0   Price *
38 PREISZUS PREISZUS KENNZ4 CHAR 4   0   Indicator: Price Summary  
39 VONZONE VONZONE E_ZONE NUMC 10   0   From-block  
40 BISZONE BISZONE E_ZONE NUMC 10   0   To-block  
41 ZONENNR E_ZONENNR E_ZONENNR NUMC 3   0   Number of price block or price scale  
42 PREISBTR PRSBTR PRSBTR DEC 17   8   Price amount  
43 MNGBASIS MNGBASIS MNGBASIS DEC 5   2   Quantity base for amount  
44 TIMBASIS TIMBASIS TIMBASIS CHAR 3   0   Time Basis  
45 TIMTYP TIMTYP TIMTYP CHAR 1   0   Time category (days or months)  
46 PREIGKL PREIGKL PREIGKL CHAR 10   0   Price adjustment clause *
47 URPREIS URPREIS PRSBTR DEC 17   8   Base price to which the price adjustment clause relates  
48 PREIADD PREIADD PRSBTR DEC 17   8   Price to be added for price adjustment  
49 PREIFAKT PREIFAKT PREIFAKT DEC 12   7   Price adjustment factor  
50 OPMULT OPMULT KENZX CHAR 1   0   Addition first  
51 FRAN_TYPE FRAN_TYPE FRAN_TYPE CHAR 1   0   Franchise Fee Category  
52 KONZIGR KONZIGR KONZIGR CHAR 10   0   Franchise fee group TE241
53 ABLESGR ABLESGR ABLESGR CHAR 2   0   Meter reading reason TE609
54 ABLESGRV ABLESGRV ABLESGR CHAR 2   0   Previous meter reading reason TE609
55 ATIM ATIM HHMM CHAR 4   0   Meter reading time (relevant to billing)  
56 ATIMVA ATIMVA HHMM CHAR 4   0   Time of day of previous meter reading  
57 ADATMAX ADATMAX DATUM DATS 8   0   Date of maximum meter reading  
58 ATIMMAX ATIMMAX HHMM CHAR 4   0   Time of maximum meter reading  
59 TARIFTYP TARIFTYP TARIFTYP CHAR 10   0   Rate category *
60 TARIFNR TARIFNR TARIFNR CHAR 10   0   Rate key *
61 KONDIGR KONDIGR KONDIGR CHAR 10   0   Rate fact group TE067
62 STTARIF STTARIF STTARIFNR CHAR 10   0   Statistical rate  
63 GEWKEY GEWKEY GEWKEY CHAR 8   0   Weighting key TE266
64 GEWANTZ GEWANTZ GEWANTZ DEC 17   0   Numerator of weighting portion  
65 GEWANTN GEWANTN GEWANTN DEC 17   0   Denominator of weighting portion  
66 LEUCHTNR LEUCHTNR LEUCHTNR CHAR 10   0   External lighting number  
67 BETRART BETRART BETRART CHAR 4   0   Operation Type for Lighting Unit TE497
68 WDHFAKT WDHFAKT E_FAKTOR INT4 10   0   Repetition factor for reference values  
69 TEMP_AREA TEMP_AREA TEMP_AREA CHAR 8   0   Temperature area TE307
70 DRCKSTUF DRCKSTUF DRCKSTUF CHAR 2   0   Gas pressure level  
71 THGDATUM THGDATUM DATUM DATS 8   0   Gas allocation date  
72 ZUORDDAT E_ZUORDDAT DATUM DATS 8   0   Meter reading allocation date  
73 SPGRUND SPGRUND SPGRUND CHAR 2   0   Disconnection reason  
74 ABGGRND1 ABGGRND ABGGRND CHAR 4   0   Reason for proration *
75 ABGGRND2 ABGGRND ABGGRND CHAR 4   0   Reason for proration *
76 ABGGRND3 ABGGRND ABGGRND CHAR 4   0   Reason for proration *
77 ABGGRND4 ABGGRND ABGGRND CHAR 4   0   Reason for proration *
78 ABGGRND5 ABGGRND ABGGRND CHAR 4   0   Reason for proration *
79 ABGGRND6 ABGGRND ABGGRND CHAR 4   0   Reason for proration *
80 ABGGRND7 ABGGRND ABGGRND CHAR 4   0   Reason for proration *
81 ABGGRND8 ABGGRND ABGGRND CHAR 4   0   Reason for proration *
82 ABGGRND9 ABGGRND ABGGRND CHAR 4   0   Reason for proration *
83 ABGGRND10 ABGGRND ABGGRND CHAR 4   0   Reason for proration *
84 EIN01 EINOPERAND E_OPERAND CHAR 10   0   Input operand *
85 EIN02 EINOPERAND E_OPERAND CHAR 10   0   Input operand *
86 EIN03 EINOPERAND E_OPERAND CHAR 10   0   Input operand *
87 EIN04 EINOPERAND E_OPERAND CHAR 10   0   Input operand *
88 EIN05 EINOPERAND E_OPERAND CHAR 10   0   Input operand *
89 EIN06 EINOPERAND E_OPERAND CHAR 10   0   Input operand *
90 EIN07 EINOPERAND E_OPERAND CHAR 10   0   Input operand *
91 EIN08 EINOPERAND E_OPERAND CHAR 10   0   Input operand *
92 EIN09 EINOPERAND E_OPERAND CHAR 10   0   Input operand *
93 EIN10 EINOPERAND E_OPERAND CHAR 10   0   Input operand *
94 AUS01 AUSOPERAND E_OPERAND CHAR 10   0   Output operand *
95 AUS02 AUSOPERAND E_OPERAND CHAR 10   0   Output operand *
96 AUS03 AUSOPERAND E_OPERAND CHAR 10   0   Output operand *
97 AUS04 AUSOPERAND E_OPERAND CHAR 10   0   Output operand *
98 AUS05 AUSOPERAND E_OPERAND CHAR 10   0   Output operand *
99 MASS1 E_MASS MEINS UNIT 3   0   Unit of Measurement T006
100 MASS2 E_MASS MEINS UNIT 3   0   Unit of Measurement T006
101 MASS3 E_MASS MEINS UNIT 3   0   Unit of Measurement T006
102 MASS4 E_MASS MEINS UNIT 3   0   Unit of Measurement T006
103 MASS5 E_MASS MEINS UNIT 3   0   Unit of Measurement T006
104 MASS6 E_MASS MEINS UNIT 3   0   Unit of Measurement T006
105 DATUM1 DATUM DATUM DATS 8   0   Date  
106 DATUM2 DATUM DATUM DATS 8   0   Date  
107 TEXTNR TEXTNR NUM08 NUMC 8   0   Text Number  
108 TEXTSP TEXTSP SPRAS LANG 1   0   Language key in text processing T002
109 RABZUS RABZUS RABZUS CHAR 10   0   Discount key *
110 BACKCANC01 BACKCANC01 BACKGROUP CHAR 4   0   Indicator: reverse backbilling *
111 BACKCANC02 BACKCANC02 BACKGROUP CHAR 4   0   Indicator: reverse backbilling *
112 BACKCANC03 BACKCANC03 BACKGROUP CHAR 4   0   Indicator: reverse backbilling *
113 BACKCANC04 BACKCANC04 BACKGROUP CHAR 4   0   Indicator: reverse backbilling *
114 BACKCANC05 BACKCANC05 BACKGROUP CHAR 4   0   Indicator: reverse backbilling *
115 BACKCANC BACKCANC BACKGROUP CHAR 4   0   Indicator: Reverse Backbilling *
116 BACKEXEC BACKEXEC BACKGROUP CHAR 4   0   Indicator: allocate backbilling *
117 BACKDOCNO BACKDOCNO E_BELNR CHAR 12   0   Number of a billing document  
118 BACKDOCLINE BACKDOCLINE LFDNR6 NUMC 6   0   Billing line item for billing documents  
119 LRATESTEP LRATESTEP LRATESTEP NUMC 10   0   Logical Number of Rate Step  
120 TXDAT_KK TXDAT_KK DATUM DATS 8   0   Decisive Date for Calculating Taxes  
121 REGRELSORT REGRELSORT REGRELSORT NUMC 2   0   Sort help for register relationships during bill printout  
122 SC_BELNR SC_BELNR E_BELNR CHAR 12   0   Number of billing document in adjustment reversal  
123 PEB PEB KENNZX CHAR 1   0   Indicator: billing line item relates to period-end billing  
124 OPLFDNR OPLFDNR LFDNR4 NUMC 4   0   Consecutive number of an operand  
125 STAFO STAFO STAFO CHAR 6   0   Update group for statistics update *
126 ARTMENGE ARTMENGE ARTMENGE CHAR 1   0   Classification of billed quantity for statistics  
127 STATTART STATTART TARIFART CHAR 8   0   Rate type for statistical analysis TE069
128 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center CEPC
129 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center CSKS
130 PS_PSP_PNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) PRPS
131 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
132 PAOBJNR RKEOBJNR RKEOBJNR NUMC 10   0   Profitability Segment Number (CO-PA)  
133 PAOBJNR_S RKEOBJNR_S RKEOBJNR NUMC 10   0   Profitability Segment No. for CO-PA Post. Acc. to Cons. Mth  
134 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
135 APERIODIC APERIODIC KENNZX CHAR 1   0   Non-Periodic Posting  
136 ABLBELNR ABLBELNR ABLBELNR CHAR 20   0   Internal ID for meter reading document *
137 LOGIKZW LOGIKZW LOGIKZW NUMC 18   0   Logical register number  
138 ISTABLART ISTABLART ISTABLART CHAR 2   0   Meter reading type *
139 ISTABLARTVA ISTABLARTVA ISTABLART CHAR 2   0   Meter reading type of previous meter reading *
140 EXTPKZ EXTPKZ ORIGIN_ESTIM CHAR 1   0   Simulation indicator for meter reading results  
141 BEGPROG BEGPROG DATUM DATS 8   0   Start of forecast period  
142 ENDEPROG ENDEPROG DATUM DATS 8   0   End of forecast period  
143 REFBELZEILE REFBELZEILE LFDNR6 NUMC 6   0   Reference billing line item for billing documents  
144 SPERRUNG SPERRUNG KENNZX CHAR 1   0   Time slice is in a disconnection period  
145 TIMECONTRL TIMECONTRL TIMECONTRL CHAR 2   0   Period control *
146 TCNUMTOR TCNUMTOR TCNUMTOR DEC 8   4   Numerator of the time portion in a time slice  
147 TCDENOMTOR TCDENOMTOR TCDENOMTOR DEC 8   4   Denominator of the time portion in a time slice  
148 TIMTYPQUOT TIMTYPQUOT TIMTYP CHAR 1   0   Time category of meter for time portion of a time slice  
149 NETTOFRMD NETTOFRMD WRTV7 CURR 13   2   Amount in foreign currency with +/- sign  
150 WAERSF WAERSF WAERS CUKY 5   0   Currency key for amount *
151 UMRECHDAT UMRECHDAT UMRECHDAT DATS 8   0   Conversion Date for Foreign Currency Amount  
152 UMRECHKURS UMRECHKURS KURSF DEC 9   5   Exchange rate btwn net amount and foreign currency amount  
153 AKTIV E_AKTIV E_AKTIV CHAR 1   0   Meter reading active  
154 REFBELZONE REFBELZONE LFDNR6 NUMC 6   0   Ref. billing line item for documents resulting from blocking  
155 ABLHINW ABLHINW ABLHINW CHAR 4   0   Note from meter reader *
156 KONZVER KONZVER KONZVER CHAR 10   0   Franchise contract *
157 REFBILLDOCNO REFBILLDOCNO E_BELNR CHAR 12   0   Reference Document Number  
158 PERTYP BILLPERTYP BILLPERTYP CHAR 2   0   Category of the internal billing period  
159 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ERCHZ_I ABLESGR TE609 ABLESGR    
2 ERCHZ_I ABLESGRV TE609 ABLESGR    
3 ERCHZ_I AUFNR AUFK AUFNR    
4 ERCHZ_I BELZART TE835 BELZART KEY    
5 ERCHZ_I BETRART TE497 BETRART KEY    
6 ERCHZ_I BRANCHE TB023 IND_SECTOR    
7 ERCHZ_I GEGEN_TVORG TFKTVO TVORG    
8 ERCHZ_I GEWKEY TE266 GEWKEY KEY    
9 ERCHZ_I GSBER TGSB GSBER    
10 ERCHZ_I KONDIGR TE067 KONDIGR KEY    
11 ERCHZ_I KONZIGR TE241 KONZIGR KEY    
12 ERCHZ_I KOSTL CSKS KOSTL    
13 ERCHZ_I LINESORT TE530 LINESORT KEY    
14 ERCHZ_I MASS1 T006 MSEHI KEY    
15 ERCHZ_I MASS2 T006 MSEHI KEY    
16 ERCHZ_I MASS3 T006 MSEHI KEY    
17 ERCHZ_I MASS4 T006 MSEHI KEY    
18 ERCHZ_I MASS5 T006 MSEHI KEY    
19 ERCHZ_I MASS6 T006 MSEHI KEY    
20 ERCHZ_I MASSBILL T006 MSEHI KEY    
21 ERCHZ_I PRCTR CEPC PRCTR    
22 ERCHZ_I PREISTUF TE471 PREISTUF KEY    
23 ERCHZ_I PS_PSP_PNR PRPS PSPNR    
24 ERCHZ_I STATTART TE069 TARIFART    
25 ERCHZ_I TEMP_AREA TE307 TEMP_AREA KEY    
26 ERCHZ_I TEXTSP T002 SPRAS    
27 ERCHZ_I TVORG TFKTVO TVORG    
28 ERCHZ_I TWAERS TCURC WAERS KEY    
History
Last changed by/on SAP  20130529 
SAP Release Created in