DBERDZ - DB Table: Individ. Lines - Print Document
DB Table: Individ. Lines - Print Document information is stored in SAP table DBERDZ.
It is part of development package EE22 in software component IS-U-IN. This development package consists of objects that can be grouped under "IS-U: Bill Printout".
It is part of development package EE22 in software component IS-U-IN. This development package consists of objects that can be grouped under "IS-U: Bill Printout".
Fields for table DBERDZ
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| OPBEL | Number of print document | X | E_PRINTDOC | CHAR | 24 | |
| BELZEILE | Billing line item for billing documents | X | BELZEILE | NUMC | 12 | |
| .INCLUDE | ERDZ_I | 0 | ||||
| BUKRS | Company Code | BUKRS | CHAR | 8 | ||
| KTOSL | Transaction Key | KTOSL | CHAR | 6 | ||
| HKONT | General Ledger Account | HKONT | CHAR | 20 | * | |
| STPRZ | Tax rate in output format | STEUERSATZ | CHAR | 16 | ||
| SBASW | Amount Subject to Tax in Transaction Currency (Tax Base Amt) | SBASW_KK | CURR | 7 | ||
| SBETW | Tax Amount in Transaction Currency with +/- Sign | SBETW_KK | CURR | 7 | ||
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 30 | * | |
| HVORG | Main Transaction for Line Item | HVORG_KK | CHAR | 8 | TFKHVO | |
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 2 | ||
| BLDAT | Document Date in Document | BLDAT | DATS | 16 | ||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 16 | ||
| FAEDN | Due date for net payment | FAEDN_KK | DATS | 16 | ||
| BETRW | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR | 7 | ||
| AUGBW | Clearing Amount in Transaction Currency (With +/- Sign) | AUGBW_KK | CURR | 7 | ||
| FAEDS | Due Date for Cash Discount | FAEDS_KK | DATS | 16 | ||
| SKTOW | Cash discount amount in transaction currency with +/- sign | SKTOW_KK | CURR | 7 | ||
| ASKTW | Proportional Cash Discount in Transaction Currency | ASKTW_KK | CURR | 7 | ||
| SKTPZ | Cash Discount Percentage Rate | SKTPZ_KK | DEC | 3 | ||
| VERTRAG | Contract | VERTRAG | CHAR | 20 | ||
| ABPOPBEL | Budget billing plan | ABPLANNR | CHAR | 24 | ||
| SPARTE | Division | SPARTE | CHAR | 4 | TSPA | |
| XTOTAL_AMNT | Consider Items in Bill Sum Total | XTOTAL_AMNT | CHAR | 2 | ||
| AWTYP | Reference procedure | AWTYP | CHAR | 10 | * | |
| AWKEY | Reference Key | AWKEY | CHAR | 40 | ||
| CA_OPBEL | Number of a FI-CA Document | OPBEL_KK | CHAR | 24 | * | |
| TAXRATE_INTERNAL | Tax rate | STPRZ_KK | NUMC | 12 | ||
| .INCLUDE | ERCHZ_I | 0 | ||||
| CSNO | Sequence number of schema step during billing | CSNO | NUMC | 12 | ||
| BELZART | Line Item Type | BELZART | CHAR | 12 | TE835 | |
| ABSLKZ | Billing Line Item for Budget Billing Amount Determination | ABSLKZ | CHAR | 2 | ||
| DIFFKZ | Indicator: difference line item for discount statistics | DIFFKZ | CHAR | 2 | ||
| BUCHREL | Billing Line Item Relevant to Posting | BUCHREL | CHAR | 2 | ||
| MENGESTREL | Quantity (billed value) is statistically relevant | MENGESTREL | CHAR | 2 | ||
| BETRSTREL | Amount of billing line item is statistically relevant | BETRSTREL | CHAR | 2 | ||
| STGRQNT | Quantity statistics group | STGRQNT | CHAR | 12 | * | |
| STGRAMT | Amount statistics group | STGRAMT | CHAR | 12 | * | |
| PRINTREL | Billing Line Is Print-Relevant | PRINTREL | CHAR | 2 | ||
| BRUTTOZEILE | Blling line item is a gross line item | BRUTTOZEILE | CHAR | 2 | ||
| AKLASSE | Billing Class | AKLASSE | CHAR | 8 | * | |
| BRANCHE | Industry sector | BU_INDSECT | CHAR | 20 | TB023 | |
| TVORG | Subtransaction for Document Item | TVORG_KK | CHAR | 8 | TFKTVO | |
| GEGEN_TVORG | Offsetting trans. for sub-transaction of billing line item | GEGEN_TVORG | CHAR | 8 | TFKTVO | |
| LINESORT | Presorting of billing line items in billing schema | LINESORT | CHAR | 8 | TE530 | |
| AB | Date from which time slice is valid | ABZEITSCH | DATS | 16 | ||
| BIS | Date at Which a Time Slice Expires | BISZEITSCH | DATS | 16 | ||
| TIMTYPZA | Time category (days or months) for billing line item | TIMTYPZA | CHAR | 2 | ||
| SCHEMANR | Number of the billing schema | SCHEMANR | CHAR | 20 | * | |
| SNO | Sequence number of schema step in billing schema | SNO | NUMC | 8 | ||
| PROGRAMM | Variant program | E_PROGRAMM | CHAR | 16 | * | |
| EQUNR | Equipment Number | EQUNR | CHAR | 36 | * | |
| GERAET | Device | GERAET | CHAR | 36 | ||
| MATNR | Material Number | MATNR | CHAR | 80 | * | |
| INDEXNR | Consecutive number of register relationship | INDEXNR | NUMC | 24 | ||
| MASSBILL | Unit of measurement for billing | E_MASSBILL | UNIT | 6 | T006 | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 4 | * | |
| ERMWSKZ | Indicator: Tax Determination Code | ERMWSKZ | CHAR | 4 | * | |
| NETTOBTR | Net amount of billing line item | NETTOBTR | CURR | 7 | ||
| TWAERS | Transaction Currency | TWAERS | CUKY | 10 | TCURC | |
| SAISON | Season | SAISON | CHAR | 20 | * | |
| PREISTUF | Price level | PREISTUF | CHAR | 20 | TE471 | |
| PREISTYP | Price category | PREISTYP | CHAR | 2 | ||
| PREIS | Price | E_PREIS | CHAR | 20 | * | |
| PREISZUS | Indicator: Price Summary | PREISZUS | CHAR | 8 | ||
| VONZONE | From-block | VONZONE | NUMC | 20 | ||
| BISZONE | To-block | BISZONE | NUMC | 20 | ||
| PREISBTR | Price amount | PRSBTR | DEC | 9 | ||
| MNGBASIS | Quantity base for amount | MNGBASIS | DEC | 3 | ||
| TIMBASIS | Time Basis | TIMBASIS | CHAR | 6 | ||
| TIMTYP | Time category (days or months) | TIMTYP | CHAR | 2 | ||
| PREIGKL | Price adjustment clause | PREIGKL | CHAR | 20 | * | |
| URPREIS | Base price to which the price adjustment clause relates | URPREIS | DEC | 9 | ||
| PREIADD | Price to be added for price adjustment | PREIADD | DEC | 9 | ||
| PREIFAKT | Price adjustment factor | PREIFAKT | DEC | 7 | ||
| OPMULT | Addition first | OPMULT | CHAR | 2 | ||
| FRAN_TYPE | Franchise Fee Category | FRAN_TYPE | CHAR | 2 | ||
| KONZIGR | Franchise fee group | KONZIGR | CHAR | 20 | TE241 | |
| ABLESGR | Meter reading reason | ABLESGR | CHAR | 4 | TE609 | |
| ABLESGRV | Previous meter reading reason | ABLESGRV | CHAR | 4 | TE609 | |
| ATIM | Meter reading time (relevant to billing) | ATIM | CHAR | 8 | ||
| ATIMVA | Time of day of previous meter reading | ATIMVA | CHAR | 8 | ||
| ADATMAX | Date of maximum meter reading | ADATMAX | DATS | 16 | ||
| ATIMMAX | Time of maximum meter reading | ATIMMAX | CHAR | 8 | ||
| TARIFTYP | Rate category | TARIFTYP | CHAR | 20 | ||
| TARIFNR | Rate key | TARIFNR | CHAR | 20 | ||
| KONDIGR | Rate fact group | KONDIGR | CHAR | 20 | TE067 | |
| STTARIF | Statistical rate | STTARIF | CHAR | 20 | ||
| GEWKEY | Weighting key | GEWKEY | CHAR | 16 | TE266 | |
| GEWANTZ | Numerator of weighting portion | GEWANTZ | DEC | 9 | ||
| GEWANTN | Denominator of weighting portion | GEWANTN | DEC | 9 | ||
| LEUCHTNR | External lighting number | LEUCHTNR | CHAR | 20 | ||
| BETRART | Operation Type for Lighting Unit | BETRART | CHAR | 8 | TE497 | |
| WDHFAKT | Repetition factor for reference values | WDHFAKT | INT4 | 4 | ||
| TEMP_AREA | Temperature area | TEMP_AREA | CHAR | 16 | TE307 | |
| DRCKSTUF | Gas pressure level | DRCKSTUF | CHAR | 4 | * | |
| THGDATUM | Gas allocation date | THGDATUM | DATS | 16 | ||
| SPGRUND | Disconnection reason | SPGRUND | CHAR | 4 | * | |
| ABGGRND1 | Reason for proration | ABGGRND | CHAR | 8 | * | |
| ABGGRND2 | Reason for proration | ABGGRND | CHAR | 8 | * | |
| ABGGRND3 | Reason for proration | ABGGRND | CHAR | 8 | * | |
| ABGGRND4 | Reason for proration | ABGGRND | CHAR | 8 | * | |
| ABGGRND5 | Reason for proration | ABGGRND | CHAR | 8 | * | |
| ABGGRND6 | Reason for proration | ABGGRND | CHAR | 8 | * | |
| ABGGRND7 | Reason for proration | ABGGRND | CHAR | 8 | * | |
| ABGGRND8 | Reason for proration | ABGGRND | CHAR | 8 | * | |
| ABGGRND9 | Reason for proration | ABGGRND | CHAR | 8 | * | |
| ABGGRND10 | Reason for proration | ABGGRND | CHAR | 8 | * | |
| EIN01 | Input operand | EINOPERAND | CHAR | 20 | * | |
| EIN02 | Input operand | EINOPERAND | CHAR | 20 | * | |
| EIN03 | Input operand | EINOPERAND | CHAR | 20 | * | |
| EIN04 | Input operand | EINOPERAND | CHAR | 20 | * | |
| EIN05 | Input operand | EINOPERAND | CHAR | 20 | * | |
| EIN06 | Input operand | EINOPERAND | CHAR | 20 | * | |
| EIN07 | Input operand | EINOPERAND | CHAR | 20 | * | |
| EIN08 | Input operand | EINOPERAND | CHAR | 20 | * | |
| EIN09 | Input operand | EINOPERAND | CHAR | 20 | * | |
| EIN10 | Input operand | EINOPERAND | CHAR | 20 | * | |
| AUS01 | Output operand | AUSOPERAND | CHAR | 20 | * | |
| AUS02 | Output operand | AUSOPERAND | CHAR | 20 | * | |
| AUS03 | Output operand | AUSOPERAND | CHAR | 20 | * | |
| AUS04 | Output operand | AUSOPERAND | CHAR | 20 | * | |
| AUS05 | Output operand | AUSOPERAND | CHAR | 20 | * | |
| MASS1 | Unit of Measurement | E_MASS | UNIT | 6 | T006 | |
| MASS2 | Unit of Measurement | E_MASS | UNIT | 6 | T006 | |
| MASS3 | Unit of Measurement | E_MASS | UNIT | 6 | T006 | |
| MASS4 | Unit of Measurement | E_MASS | UNIT | 6 | T006 | |
| MASS5 | Unit of Measurement | E_MASS | UNIT | 6 | T006 | |
| MASS6 | Unit of Measurement | E_MASS | UNIT | 6 | T006 | |
| DATUM1 | Date | DATUM | DATS | 16 | ||
| DATUM2 | Date | DATUM | DATS | 16 | ||
| TEXTNR | Text Number | TEXTNR | NUMC | 16 | ||
| TEXTSP | Language key in text processing | TEXTSP | LANG | 2 | T002 | |
| RABZUS | Discount key | RABZUS | CHAR | 20 | * | |
| BACKCANC01 | Indicator: reverse backbilling | BACKCANC01 | CHAR | 8 | * | |
| BACKCANC02 | Indicator: reverse backbilling | BACKCANC02 | CHAR | 8 | * | |
| BACKCANC03 | Indicator: reverse backbilling | BACKCANC03 | CHAR | 8 | * | |
| BACKCANC04 | Indicator: reverse backbilling | BACKCANC04 | CHAR | 8 | * | |
| BACKCANC05 | Indicator: reverse backbilling | BACKCANC05 | CHAR | 8 | * | |
| BACKCANC | Indicator: Reverse Backbilling | BACKCANC | CHAR | 8 | * | |
| BACKEXEC | Indicator: allocate backbilling | BACKEXEC | CHAR | 8 | * | |
| BACKDOCNO | Number of a billing document | BACKDOCNO | CHAR | 24 | ||
| BACKDOCLINE | Billing line item for billing documents | BACKDOCLINE | NUMC | 12 | ||
| LRATESTEP | Logical Number of Rate Step | LRATESTEP | NUMC | 20 | ||
| TXDAT_KK | Decisive Date for Calculating Taxes | TXDAT_KK | DATS | 16 | ||
| REGRELSORT | Sort help for register relationships during bill printout | REGRELSORT | NUMC | 4 | ||
| SC_BELNR | Number of billing document in adjustment reversal | SC_BELNR | CHAR | 24 | ||
| PEB | Indicator: billing line item relates to period-end billing | PEB | CHAR | 2 | ||
| OPLFDNR | Consecutive number of an operand | OPLFDNR | NUMC | 8 | ||
| STAFO | Update Group for statistics update | STAFO | CHAR | 12 | * | |
| ARTMENGE | Classification of billed quantity for statistics | ARTMENGE | CHAR | 2 | ||
| STATTART | Rate type for statistical analysis | STATTART | CHAR | 16 | TE069 | |
| PRCTR | Profit Center | PRCTR | CHAR | 20 | CEPC | |
| KOSTL | Cost Center | KOSTL | CHAR | 20 | CSKS | |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 16 | PRPS | |
| AUFNR | Order Number | AUFNR | CHAR | 24 | AUFK | |
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 20 | ||
| PAOBJNR_S | Profitability Segment No. for CO-PA Post. Acc. to Cons. Mth | RKEOBJNR_S | NUMC | 20 | ||
| GSBER | Business Area | GSBER | CHAR | 8 | TGSB | |
| APERIODIC | Non-Periodic Posting | APERIODIC | CHAR | 2 | ||
| ABLBELNR | Internal ID for meter reading document | ABLBELNR | CHAR | 40 | * | |
| LOGIKZW | Logical register number | LOGIKZW | NUMC | 36 | ||
| ISTABLART | Meter reading type | ISTABLART | CHAR | 4 | ||
| ISTABLARTVA | Meter reading type of previous meter reading | ISTABLARTVA | CHAR | 4 | ||
| EXTPKZ | Simulation Indicator for Meter Reading Results | EXTPKZ | CHAR | 2 | ||
| BEGPROG | Start of forecast period | BEGPROG | DATS | 16 | ||
| ENDEPROG | End of forecast period | ENDEPROG | DATS | 16 | ||
| REFBELZEILE | Reference billing line item for billing documents | REFBELZEILE | NUMC | 12 | ||
| SPERRUNG | Time slice is in a disconnection period | SPERRUNG | CHAR | 2 | ||
| TIMECONTRL | Period control | TIMECONTRL | CHAR | 4 | * | |
| TCNUMTOR | Numerator of the time portion in a time slice | TCNUMTOR | DEC | 5 | ||
| TCDENOMTOR | Denominator of the time portion in a time slice | TCDENOMTOR | DEC | 5 | ||
| TIMTYPQUOT | Time category of meter for time portion of a time slice | TIMTYPQUOT | CHAR | 2 | ||
| NETTOFRMD | Amount in foreign currency with +/- sign | NETTOFRMD | CURR | 7 | ||
| WAERSF | Currency key for amount | WAERSF | CUKY | 10 | * | |
| UMRECHDAT | Conversion Date for Foreign Currency Amount | UMRECHDAT | DATS | 16 | ||
| UMRECHKURS | Exchange rate btwn net amount and foreign currency amount | UMRECHKURS | DEC | 5 | ||
| AKTIV | Meter reading active | E_AKTIV | CHAR | 2 | ||
| REFBELZONE | Ref. billing line item for documents resulting from blocking | REFBELZONE | NUMC | 12 | ||
| ABLHINW | Note from meter reader | ABLHINW | CHAR | 8 | * | |
| KONZVER | Franchise contract | KONZVER | CHAR | 20 | ||
| REFBILLDOCNO | Reference Document Number | REFBILLDOCNO | CHAR | 24 | ||
| PERTYP | Category of the internal billing period | BILLPERTYP | CHAR | 4 | ||
| .INCLUDE | CI_ERCHZ | 0 | ||||
| .INCLUDE | ERCHZ_D | 0 | ||||
| V_ZWSTAND | Places Before Decimal Point in Meter Reading | V_ZWSTAND | DEC | 9 | ||
| N_ZWSTAND | Places After Decimal Point in the Meter Reading | N_ZWSTAND | DEC | 8 | ||
| V_ZWSTNDAB | Predecimal Places in Billed Meter Reading | V_ZWSTNDAB | DEC | 9 | ||
| N_ZWSTNDAB | Decimal Places in the Billed Meter Reading | N_ZWSTNDAB | DEC | 8 | ||
| V_ZWSTVOR | Predecimal places in previous meter reading result | V_ZWSTVOR | DEC | 9 | ||
| N_ZWSTVOR | Decimal places in previous meter reading | N_ZWSTVOR | DEC | 8 | ||
| V_ABRMENGE | Places before decimal point in billing quantity | V_ABRMENGE | DEC | 9 | ||
| N_ABRMENGE | Places after decimal point in billing quantity | N_ABRMENGE | DEC | 8 | ||
| V_ZAHL1 | Pre-decimal places in a number | V_ZAHL | DEC | 9 | ||
| N_ZAHL1 | Decimal places in a number | N_ZAHL | DEC | 8 | ||
| V_ZAHL2 | Pre-decimal places in a number | V_ZAHL | DEC | 9 | ||
| N_ZAHL2 | Decimal places in a number | N_ZAHL | DEC | 8 | ||
| V_ZAHL3 | Pre-decimal places in a number | V_ZAHL | DEC | 9 | ||
| N_ZAHL3 | Decimal places in a number | N_ZAHL | DEC | 8 | ||
| V_ZAHL4 | Pre-decimal places in a number | V_ZAHL | DEC | 9 | ||
| N_ZAHL4 | Decimal places in a number | N_ZAHL | DEC | 8 | ||
| V_ZAHL5 | Pre-decimal places in a number | V_ZAHL | DEC | 9 | ||
| N_ZAHL5 | Decimal places in a number | N_ZAHL | DEC | 8 | ||
| V_ZAHL6 | Pre-decimal places in a number | V_ZAHL | DEC | 9 | ||
| N_ZAHL6 | Decimal places in a number | N_ZAHL | DEC | 8 | ||
| V_ZWSTDIFF | Pre-decimal places for the meter reading difference | V_ZWSTDIFF | DEC | 9 | ||
| N_ZWSTDIFF | Decimal places for the meter reading difference | N_ZWSTDIFF | DEC | 8 | ||
| .INCLUDE | COLOGRP_BP_L_I | 0 | ||||
| COLOGRP_BP_L | Colocation group for Business Partner | E_COLOGRP_BP | CHAR | 24 |