DBERDL

Print Document Line Items | #itemdata | Component: Invoicing
Column Name Description
MANDT Client
PRINTDOC Number of print document
PRINTDOCLINE Billing line item for billing documents
Column Name Description
💲 Transaction Currency (TWAERS):
NETTOBTR Net amount of billing line item
BETRW Amount in Transaction Currency with +/- Sign
AUGBW Clearing Amount in Transaction Currency (With +/- Sign)
SBASW Amount Subject to Tax in Transaction Currency (Tax Base Amt)
SBETW Tax Amount in Transaction Currency with +/- Sign
SKTOW Cash discount amount in transaction currency with +/- sign
STTAX Tax Amount as Statistical Information in Document Currency
Column Name Description
Column Name Description
TXDAT_KK Decisive Date for Calculating Taxes
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
Column Name Description
REFDOCSOURCE Origin of source document Show values
BUCHREL Billing Line Item Relevant to Posting Show values
BRUTTOZEILE Blling line item is a gross line item Show values
SHKZG Debit/Credit Indicator Show values
APERIODIC Non-Periodic Posting Show values
XTOTAL_AMNT Consider Items in Bill Sum Total Show values
Column Name Description Domain name
REFDOCSOURCEKEYA Main key of source document
REFDOCSOURCEKEYB Service key of source document
BUKRS Company Code BUKRS
KTOSL Transaction Key CHAR3
VERTRAG Contract VERTRAG
MWSKZ Tax on sales/purchases code MWSKZ
ERMWSKZ Indicator: Tax Determination Code ERMWSKZ
STPRZ Tax rate in output format CHAR8
TXJCD Tax Jurisdiction TXJCD
SKTPZ Cash Discount Percentage Rate PRZ23
ABPOPBEL Budget billing plan OPBEL_KK
GSBER Business Area GSBER
CA_OPBEL Number of a FI-CA Document OPBEL_KK
LINESORT Presorting of billing line items in billing schema LINESORT
TAXRATE_INTERNAL Tax rate STPRZ_KK
COLOGRP_BP_L Colocation group for Business Partner COLOGRP_KK
Master Data Relations Join Conditions
Line Item Type
  • DBERDL.MANDT == TE835.MANDT
  • DBERDL.BELZART == TE835.BELZART
Main Transaction for Line Item
  • ?
  • Main Transaction for Line Item
  • DBERDL.MANDT == TFKHVO.MANDT
  • DBERDL.[column in domain "APPLK_KK"] == TFKHVO.APPLK
  • DBERDL.HVORG == TFKHVO.HVORG
Division
  • DBERDL.MANDT == TSPA.MANDT
  • DBERDL.SPARTE == TSPA.SPART
Subtransaction for Document Item
  • ?
  • ?
  • Subtransaction for Document Item
  • DBERDL.MANDT == TFKTVO.MANDT
  • DBERDL.[column in domain "HVORG_KK"] == TFKTVO.HVORG
  • DBERDL.[column in domain "APPLK_KK"] == TFKTVO.APPLK
  • DBERDL.TVORG == TFKTVO.TVORG
Transaction Currency
  • DBERDL.MANDT == TCURC.MANDT
  • DBERDL.TWAERS == TCURC.WAERS