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