DBERDZ

DB Table: Individ. Lines - Print Document | #transactional | Component: Invoicing

🔑 Keys (3)
💰 Amounts (8)
∑ Quantities
📅 Dates (15)
☰ Categorical (23)
Other (123)
🔗 Relations (30)

Column Name	Description
MANDT	Client
OPBEL	Number of print document
BELZEILE	Billing line item for billing documents

Column Name	Description
SBASW	Amount Subject to Tax in Transaction Currency (Tax Base Amt)
SBETW	Tax Amount in Transaction Currency with +/- Sign
BETRW	Amount in Transaction Currency with +/- Sign
AUGBW	Clearing Amount in Transaction Currency (With +/- Sign)
SKTOW	Cash discount amount in transaction currency with +/- sign
ASKTW	Proportional Cash Discount in Transaction Currency
💲 Transaction Currency (TWAERS):
NETTOBTR	Net amount of billing line item
💲 Currency key for amount (WAERSF):
NETTOFRMD	Amount in foreign currency with +/- sign

Column Name	Description

Column Name	Description
BLDAT	Document Date in Document
BUDAT	Posting Date in the Document
FAEDN	Due date for net payment
FAEDS	Due Date for Cash Discount
AB	Date from which time slice is valid
BIS	Date at Which a Time Slice Expires
ADATMAX	Date of maximum meter reading
THGDATUM	Gas allocation date
ZUORDDAT	Meter reading allocation date
DATUM1	Date
DATUM2	Date
TXDAT_KK	Decisive Date for Calculating Taxes
BEGPROG	Start of forecast period
ENDEPROG	End of forecast period
UMRECHDAT	Conversion Date for Foreign Currency Amount

Column Name	Description
SHKZG	Debit/Credit Indicator	Show values
XTOTAL_AMNT	Consider Items in Bill Sum Total	Show values
ABSLKZ	Billing Line Item for Budget Billing Amount Determination	Show values
DIFFKZ	Indicator: difference line item for discount statistics	Show values
BUCHREL	Billing Line Item Relevant to Posting	Show values
MENGESTREL	Quantity (billed value) is statistically relevant	Show values
BETRSTREL	Amount of billing line item is statistically relevant	Show values
PRINTREL	Billing Line Is Print-Relevant	Show values
BRUTTOZEILE	Blling line item is a gross line item	Show values
TIMTYPZA	Time category (days or months) for billing line item	Show values
PREISTYP	Price category	Show values
TIMTYP	Time category (days or months)	Show values
OPMULT	Addition first	Show values
FRAN_TYPE	Franchise Fee Category	Show values
REGRELSORT	Sort help for register relationships during bill printout	Show values
PEB	Indicator: billing line item relates to period-end billing	Show values
ARTMENGE	Classification of billed quantity for statistics	Show values
APERIODIC	Non-Periodic Posting	Show values
EXTPKZ	Simulation Indicator for Meter Reading Results	Show values
SPERRUNG	Time slice is in a disconnection period	Show values
TIMTYPQUOT	Time category of meter for time portion of a time slice	Show values
AKTIV	Meter reading active	Show values
PERTYP	Category of the internal billing period	Show values

Column Name	Description	Domain name
BUKRS	Company Code	BUKRS
KTOSL	Transaction Key	CHAR3
HKONT	General Ledger Account	SAKNR
STPRZ	Tax rate in output format	CHAR8
TXJCD	Tax Jurisdiction	TXJCD
SKTPZ	Cash Discount Percentage Rate	PRZ23
VERTRAG	Contract	VERTRAG
ABPOPBEL	Budget billing plan	OPBEL_KK
AWTYP	Reference procedure	AWTYP
AWKEY	Reference Key	AWKEY
CA_OPBEL	Number of a FI-CA Document	OPBEL_KK
TAXRATE_INTERNAL	Tax rate	STPRZ_KK
CSNO	Sequence number of schema step during billing	LFDSCHEM
STGRQNT	Quantity statistics group	STGRQNT
STGRAMT	Amount statistics group	STGRAMT
ZEITANT	Time portion, billing period in days or months	E_ZEITANT
SNO	Sequence number of schema step in billing schema	LFDNR4
GERAET	Device	GERNR
ZWNUMMER	Register	LFDNR3
INDEXNR	Consecutive number of register relationship	INDEXNR
MWSKZ	Tax on sales/purchases code	MWSKZ
ERMWSKZ	Indicator: Tax Determination Code	ERMWSKZ
SAISON	Season	E_OPERAND
PREISZUS	Indicator: Price Summary	KENNZ4
VONZONE	From-block	E_ZONE
BISZONE	To-block	E_ZONE
ZONENNR	Number of price block or price scale	E_ZONENNR
PREISBTR	Price amount	PRSBTR
MNGBASIS	Quantity base for amount	MNGBASIS
TIMBASIS	Time Basis	TIMBASIS
PREIGKL	Price adjustment clause	PREIGKL
URPREIS	Base price to which the price adjustment clause relates	PRSBTR
PREIADD	Price to be added for price adjustment	PRSBTR
PREIFAKT	Price adjustment factor	PREIFAKT
ATIM	Meter reading time (relevant to billing)	HHMM
ATIMVA	Time of day of previous meter reading	HHMM
ATIMMAX	Time of maximum meter reading	HHMM
TARIFTYP	Rate category	TARIFTYP
TARIFNR	Rate key	TARIFNR
STTARIF	Statistical rate	STTARIFNR
GEWANTZ	Numerator of weighting portion	GEWANTZ
GEWANTN	Denominator of weighting portion	GEWANTN
LEUCHTNR	External lighting number	LEUCHTNR
WDHFAKT	Repetition factor for reference values	E_FAKTOR
DRCKSTUF	Gas pressure level	DRCKSTUF_GRID
ABGGRND1	Reason for proration	ABGGRND
ABGGRND2	Reason for proration	ABGGRND
ABGGRND3	Reason for proration	ABGGRND
ABGGRND4	Reason for proration	ABGGRND
ABGGRND5	Reason for proration	ABGGRND
ABGGRND6	Reason for proration	ABGGRND
ABGGRND7	Reason for proration	ABGGRND
ABGGRND8	Reason for proration	ABGGRND
ABGGRND9	Reason for proration	ABGGRND
ABGGRND10	Reason for proration	ABGGRND
EIN01	Input operand	E_OPERAND
EIN02	Input operand	E_OPERAND
EIN03	Input operand	E_OPERAND
EIN04	Input operand	E_OPERAND
EIN05	Input operand	E_OPERAND
EIN06	Input operand	E_OPERAND
EIN07	Input operand	E_OPERAND
EIN08	Input operand	E_OPERAND
EIN09	Input operand	E_OPERAND
EIN10	Input operand	E_OPERAND
AUS01	Output operand	E_OPERAND
AUS02	Output operand	E_OPERAND
AUS03	Output operand	E_OPERAND
AUS04	Output operand	E_OPERAND
AUS05	Output operand	E_OPERAND
TEXTNR	Text Number	NUM08
RABZUS	Discount key	RABZUS
BACKCANC01	Indicator: reverse backbilling	BACKGROUP
BACKCANC02	Indicator: reverse backbilling	BACKGROUP
BACKCANC03	Indicator: reverse backbilling	BACKGROUP
BACKCANC04	Indicator: reverse backbilling	BACKGROUP
BACKCANC05	Indicator: reverse backbilling	BACKGROUP
BACKCANC	Indicator: Reverse Backbilling	BACKGROUP
BACKEXEC	Indicator: allocate backbilling	BACKGROUP
BACKDOCNO	Number of a billing document	E_BELNR
BACKDOCLINE	Billing line item for billing documents	LFDNR6
LRATESTEP	Logical Number of Rate Step	LRATESTEP
SC_BELNR	Number of billing document in adjustment reversal	E_BELNR
OPLFDNR	Consecutive number of an operand	LFDNR4
STAFO	Update Group for statistics update	STAFO
PAOBJNR	Profitability Segment Number (CO-PA)	RKEOBJNR
PAOBJNR_S	Profitability Segment No. for CO-PA Post. Acc. to Cons. Mth	RKEOBJNR
ABLBELNR	Internal ID for meter reading document	ABLBELNR
LOGIKZW	Logical register number	LOGIKZW
ISTABLART	Meter reading type	ISTABLART
ISTABLARTVA	Meter reading type of previous meter reading	ISTABLART
REFBELZEILE	Reference billing line item for billing documents	LFDNR6
TIMECONTRL	Period control	TIMECONTRL
TCNUMTOR	Numerator of the time portion in a time slice	TCNUMTOR
TCDENOMTOR	Denominator of the time portion in a time slice	TCDENOMTOR
UMRECHKURS	Exchange rate btwn net amount and foreign currency amount	KURSF
REFBELZONE	Ref. billing line item for documents resulting from blocking	LFDNR6
ABLHINW	Note from meter reader	ABLHINW
KONZVER	Franchise contract	KONZVER
REFBILLDOCNO	Reference Document Number	E_BELNR
V_ZWSTAND	Places Before Decimal Point in Meter Reading	V_ZWSTAND
N_ZWSTAND	Places After Decimal Point in the Meter Reading	N_ZWSTAND
V_ZWSTNDAB	Predecimal Places in Billed Meter Reading	V_ZWSTAND
N_ZWSTNDAB	Decimal Places in the Billed Meter Reading	N_ZWSTAND
V_ZWSTVOR	Predecimal places in previous meter reading result	V_ZWSTAND
N_ZWSTVOR	Decimal places in previous meter reading	N_ZWSTAND
V_ABRMENGE	Places before decimal point in billing quantity	V_ABRMENGE
N_ABRMENGE	Places after decimal point in billing quantity	N_ABRMENGE
V_ZAHL1	Pre-decimal places in a number	V_ZAHL
N_ZAHL1	Decimal places in a number	N_ZAHL
V_ZAHL2	Pre-decimal places in a number	V_ZAHL
N_ZAHL2	Decimal places in a number	N_ZAHL
V_ZAHL3	Pre-decimal places in a number	V_ZAHL
N_ZAHL3	Decimal places in a number	N_ZAHL
V_ZAHL4	Pre-decimal places in a number	V_ZAHL
N_ZAHL4	Decimal places in a number	N_ZAHL
V_ZAHL5	Pre-decimal places in a number	V_ZAHL
N_ZAHL5	Decimal places in a number	N_ZAHL
V_ZAHL6	Pre-decimal places in a number	V_ZAHL
N_ZAHL6	Decimal places in a number	N_ZAHL
V_ZWSTDIFF	Pre-decimal places for the meter reading difference	V_ZWSTDIFF
N_ZWSTDIFF	Decimal places for the meter reading difference	N_ZWSTDIFF
COLOGRP_BP_L	Colocation group for Business Partner	COLOGRP_KK

Master Data Relations	Join Conditions
Meter reading reason	`DBERDZ.ABLESGR == TE609.ABLESGR`
Previous meter reading reason	`DBERDZ.ABLESGRV == TE609.ABLESGR`
Order Number Order Number Client	`DBERDZ.AUFNR == AUFK.AUFNR` `DBERDZ.MANDT == AUFK.MANDT`
Line Item Type	`DBERDZ.MANDT == TE835.MANDT` `DBERDZ.BELZART == TE835.BELZART`
Operation Type for Lighting Unit	`DBERDZ.MANDT == TE497.MANDT` `DBERDZ.BETRART == TE497.BETRART`
Offsetting trans. for sub-transaction of billing line item ? ? Offsetting trans. for sub-transaction of billing line item	`DBERDZ.MANDT == TFKTVO.MANDT` `DBERDZ.[column in domain "HVORG_KK"] == TFKTVO.HVORG` `DBERDZ.[column in domain "APPLK_KK"] == TFKTVO.APPLK` `DBERDZ.GEGEN_TVORG == TFKTVO.TVORG`
Weighting key	`DBERDZ.MANDT == TE266.MANDT` `DBERDZ.GEWKEY == TE266.GEWKEY`
F4 help	`DBERDZ.MANDT == TGSB.MANDT` `DBERDZ.GSBER == TGSB.GSBER`
Main Transaction for Line Item ? Main Transaction for Line Item	`DBERDZ.MANDT == TFKHVO.MANDT` `DBERDZ.[column in domain "APPLK_KK"] == TFKHVO.APPLK` `DBERDZ.HVORG == TFKHVO.HVORG`
Rate fact group Rate fact group Client	`DBERDZ.KONDIGR == TE067.KONDIGR` `DBERDZ.MANDT == TE067.MANDT`
Franchise Fee Group	`DBERDZ.MANDT == TE241.MANDT` `DBERDZ.KONZIGR == TE241.KONZIGR`
Cost Center ? Cost Center ?	`DBERDZ.MANDT == CSKS.MANDT` `DBERDZ.[column in domain "DATBI"] == CSKS.DATBI` `DBERDZ.KOSTL == CSKS.KOSTL` `DBERDZ.[column in domain "KOKRS"] == CSKS.KOKRS`
Presorting of billing line items in billing schema Presorting of billing line items in billing schema Client	`DBERDZ.LINESORT == TE530.LINESORT` `DBERDZ.MANDT == TE530.MANDT`
Unit of Measurement	`DBERDZ.MANDT == T006.MANDT` `DBERDZ.MASS1 == T006.MSEHI`
Unit of Measurement	`DBERDZ.MANDT == T006.MANDT` `DBERDZ.MASS2 == T006.MSEHI`
Unit of Measurement	`DBERDZ.MANDT == T006.MANDT` `DBERDZ.MASS3 == T006.MSEHI`
Unit of Measurement	`DBERDZ.MANDT == T006.MANDT` `DBERDZ.MASS4 == T006.MSEHI`
Unit of Measurement	`DBERDZ.MANDT == T006.MANDT` `DBERDZ.MASS5 == T006.MSEHI`
Unit of Measurement	`DBERDZ.MANDT == T006.MANDT` `DBERDZ.MASS6 == T006.MSEHI`
Unit of measurement for billing	`DBERDZ.MANDT == T006.MANDT` `DBERDZ.MASSBILL == T006.MSEHI`
Profit Center ? ? Profit Center	`DBERDZ.MANDT == CEPC.MANDT` `DBERDZ.[column in domain "DATBI"] == CEPC.DATBI` `DBERDZ.[column in domain "KOKRS"] == CEPC.KOKRS` `DBERDZ.PRCTR == CEPC.PRCTR`
Price level	`DBERDZ.MANDT == TE471.MANDT` `DBERDZ.PREISTUF == TE471.PREISTUF`
Division	`DBERDZ.MANDT == TSPA.MANDT` `DBERDZ.SPARTE == TSPA.SPART`
Rate type for statistical analysis	`DBERDZ.MANDT == TE069.MANDT` `DBERDZ.STATTART == TE069.TARIFART`
Temperature area Temperature area Client	`DBERDZ.TEMP_AREA == TE307.TEMP_AREA` `DBERDZ.MANDT == TE307.MANDT`
Language key in text processing	`DBERDZ.TEXTSP == T002.SPRAS`
Subtransaction for Document Item ? ? Subtransaction for Document Item	`DBERDZ.MANDT == TFKTVO.MANDT` `DBERDZ.[column in domain "HVORG_KK"] == TFKTVO.HVORG` `DBERDZ.[column in domain "APPLK_KK"] == TFKTVO.APPLK` `DBERDZ.TVORG == TFKTVO.TVORG`
Transaction Currency	`DBERDZ.MANDT == TCURC.MANDT` `DBERDZ.TWAERS == TCURC.WAERS`