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