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 |