1. Home
  2. Resources
  3. SAP Tables
  4. DBERDL - Print Document Line Items

SAP Table DBERDL

Print Document Line Items

DBERDL (Print Document Line Items) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link DBERDL to other SAP tables.

DBERDL table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
PRINTDOC Number of print document E_PRINTDOC CHAR 12 0
PRINTDOCLINE Billing line item for billing documents BELZEILE NUMC 6 0
REFDOCSOURCE Origin of source document ISU_REFDOCSOURCE CHAR 1 0
S SD document
I Invoicing
V Document with undefined origin
P Reference to Print Document
REFDOCSOURCEKEYA Main key of source document ISU_REFDOCSOURCEKEYA CHAR 20 0
REFDOCSOURCEKEYB Service key of source document ISU_REFDOCSOURCEKEYB CHAR 6 0
BELZART Line Item Type BELZART TE835 CHAR 6 0
BUKRS Company Code BUKRS CHAR 4 0
SPARTE Division SPARTE TSPA CHAR 2 0
KTOSL Transaction Key KTOSL CHAR 3 0
VERTRAG Contract VERTRAG CHAR 10 0
BUCHREL Billing Line Item Relevant to Posting BUCHREL CHAR 1 0
NULL Field inactive
X Field active
BRUTTOZEILE Blling line item is a gross line item BRUTTOZEILE CHAR 1 0
NULL Field inactive
X Field active
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
APERIODIC Non-Periodic Posting APERIODIC CHAR 1 0
NULL Field inactive
X Field active
XTOTAL_AMNT Consider Items in Bill Sum Total XTOTAL_AMNT CHAR 1 0
NULL Do not Include Item in the Final Bill Amount
X Item Always Included in Final Bill Amount
B Only Include Item Once in Final Bill Amount
NETTOBTR Net amount of billing line item NETTOBTR CURR 13 2
BETRW Amount in Transaction Currency with +/- Sign BETRW_KK CURR 13 2
AUGBW Clearing Amount in Transaction Currency (With +/- Sign) AUGBW_KK CURR 13 2
SBASW Amount Subject to Tax in Transaction Currency (Tax Base Amt) SBASW_KK CURR 13 2
SBETW Tax Amount in Transaction Currency with +/- Sign SBETW_KK CURR 13 2
SKTOW Cash discount amount in transaction currency with +/- sign SKTOW_KK CURR 13 2
TWAERS Transaction Currency TWAERS TCURC CUKY 5 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
ERMWSKZ Indicator: Tax Determination Code ERMWSKZ CHAR 2 0
STPRZ Tax rate in output format STEUERSATZ CHAR 8 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
TXDAT_KK Decisive Date for Calculating Taxes TXDAT_KK DATS 8 0
HVORG Main Transaction for Line Item HVORG_KK TFKHVO CHAR 4 0
TVORG Subtransaction for Document Item TVORG_KK TFKTVO CHAR 4 0
BLDAT Document Date in Document BLDAT DATS 8 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
FAEDN Due date for net payment FAEDN_KK DATS 8 0
FAEDS Due Date for Cash Discount FAEDS_KK DATS 8 0
SKTPZ Cash discount rate SKTPZ_KK DEC 5 3
ABPOPBEL Budget billing plan ABPLANNR CHAR 12 0
GSBER Business Area GSBER CHAR 4 0
CA_OPBEL Number of Contract Accts Rec. & Payable Doc. OPBEL_KK CHAR 12 0
LINESORT Presorting of billing line items in billing schema LINESORT CHAR 4 0
AB Date from which time slice is valid ABZEITSCH DATS 8 0
BIS Date at Which a Time Slice Expires BISZEITSCH DATS 8 0
TAXRATE_INTERNAL Tax rate STPRZ_KK NUMC 6 0

DBERDL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DBERDL BELZART ERDZ MANDT TE835 Line Item Type MANDT
DBERDL BELZART DBERDL BELZART TE835 Line Item Type BELZART
DBERDL HVORG SY MANDT TFKHVO Main transactions in contract accts receivable and payable MANDT
DBERDL HVORG 'R' TFKHVO Main transactions in contract accts receivable and payable APPLK
DBERDL HVORG DBERDL HVORG TFKHVO Main transactions in contract accts receivable and payable HVORG
DBERDL SPARTE DBERDL SPARTE TSPA Organizational Unit: Sales Divisions SPART
DBERDL SPARTE ERDZ MANDT TSPA Organizational Unit: Sales Divisions MANDT
DBERDL TVORG * TFKTVO Sub-transactions in Contract Accounts Receivable and Payable MANDT
DBERDL TVORG * TFKTVO Sub-transactions in Contract Accounts Receivable and Payable APPLK
DBERDL TVORG * TFKTVO Sub-transactions in Contract Accounts Receivable and Payable HVORG
DBERDL TVORG DBERDL TVORG TFKTVO Sub-transactions in Contract Accounts Receivable and Payable TVORG
DBERDL TWAERS SYST MANDT TCURC Currency Codes MANDT
DBERDL TWAERS DBERDL TWAERS TCURC Currency Codes WAERS