DBERDL SAP (Print Document Line Items) Table details
Dictionary Type: Table
Description: Print Document Line Items
Description: Print Document Line Items
Table field list including key, data, relationships and ABAP select examples
DBERDL is a standard SAP Table which is used to store Print Document Line Items data and is available within R/3 SAP systems depending on the version and release level.
The DBERDL table consists of various fields, each holding specific information or linking keys about Print Document Line Items data available in SAP. These include PRINTDOC (Number of print document), PRINTDOCLINE (Billing line item for billing documents), REFDOCSOURCE (Origin of source document), REFDOCSOURCEKEYA (Main key of source document).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP DBERDL table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
PRINTDOC | Number of print document | E_PRINTDOC | CHAR | 12 | Assigned to domain | ALPHA | E_PRINTDOC | E_PRINTDOC | |
PRINTDOCLINE | Billing line item for billing documents | BELZEILE | NUMC | 6 | LFDNR6 | ||||
REFDOCSOURCE | Origin of source document | ISU_REFDOCSOURCE | CHAR | 1 | ISU_REFDOCSOURCE | ||||
REFDOCSOURCEKEYA | Main key of source document | ISU_REFDOCSOURCEKEYA | CHAR | 20 | |||||
REFDOCSOURCEKEYB | Service key of source document | ISU_REFDOCSOURCEKEYB | CHAR | 6 | |||||
BELZART | Line Item Type | BELZART | CHAR | 6 | TE835 | BELZART | ISU_BELZART | ||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
SPARTE | Division | SPARTE | CHAR | 2 | TSPA | SPART | SPA | ||
KTOSL | Transaction Key | KTOSL | CHAR | 3 | CHAR3 | ||||
VERTRAG | Contract | VERTRAG | CHAR | 10 | Assigned to domain | ALPHA | VERTRAG | VTG | EVER |
BUCHREL | Billing Line Item Relevant to Posting | BUCHREL | CHAR | 1 | KENNZX | ||||
BRUTTOZEILE | Blling line item is a gross line item | BRUTTOZEILE | CHAR | 1 | KENNZX | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
APERIODIC | Non-Periodic Posting | APERIODIC | CHAR | 1 | KENNZX | ||||
XTOTAL_AMNT | Consider Items in Bill Sum Total | XTOTAL_AMNT | CHAR | 1 | E_XTOTAL_AMNT | ||||
NETTOBTR | Net amount of billing line item | NETTOBTR | CURR | 13(2) | WRTV7 | ||||
BETRW | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR | 13(2) | WRTV7 | ||||
AUGBW | Clearing Amount in Transaction Currency (With +/- Sign) | AUGBW_KK | CURR | 13(2) | WRTV7 | ||||
SBASW | Amount Subject to Tax in Transaction Currency (Tax Base Amt) | SBASW_KK | CURR | 13(2) | WRTV7 | ||||
SBETW | Tax Amount in Transaction Currency with +/- Sign | SBETW_KK | CURR | 13(2) | WRTV7 | ||||
SKTOW | Cash discount amount in transaction currency with +/- sign | SKTOW_KK | CURR | 13(2) | WRTV7 | ||||
TWAERS | Transaction Currency | TWAERS | CUKY | 5 | TCURC | WAERS | PCU | ||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
ERMWSKZ | Indicator: Tax Determination Code | ERMWSKZ | CHAR | 2 | Assigned to domain | ERMWSKZ | |||
STPRZ | Tax rate in output format | STEUERSATZ | CHAR | 8 | CHAR8 | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
TXDAT_KK | Decisive Date for Calculating Taxes | TXDAT_KK | DATS | 8 | DATUM | ||||
HVORG | Main Transaction for Line Item | HVORG_KK | CHAR | 4 | TFKHVO | HVORG_KK | 8HV | ||
TVORG | Subtransaction for Document Item | TVORG_KK | CHAR | 4 | TFKTVO | TVORG_KK | |||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
FAEDN | Due date for net payment | FAEDN_KK | DATS | 8 | DATUM | ||||
FAEDS | Due Date for Cash Discount | FAEDS_KK | DATS | 8 | DATUM | ||||
SKTPZ | Cash discount rate | SKTPZ_KK | DEC | 5(3) | PRZ23 | ||||
ABPOPBEL | Budget billing plan | ABPLANNR | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | OP1 | EABP |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
CA_OPBEL | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | 80B | |
LINESORT | Presorting of billing line items in billing schema | LINESORT | CHAR | 4 | Assigned to domain | LINESORT | |||
AB | Date from which time slice is valid | ABZEITSCH | DATS | 8 | DATUM | ||||
BIS | Date at Which a Time Slice Expires | BISZEITSCH | DATS | 8 | DATUM | ||||
TAXRATE_INTERNAL | Tax rate | STPRZ_KK | NUMC | 6 | STPRZ_KK |
Key field | Non-key field |
How do I retrieve data from SAP table DBERDL using ABAP code
The following ABAP code Example will allow you to do a basic selection on DBERDL to SELECT all data from the tableDATA: WA_DBERDL TYPE DBERDL.
SELECT SINGLE *
FROM DBERDL
INTO CORRESPONDING FIELDS OF WA_DBERDL
WHERE...
How to access SAP table DBERDL
Within an ECC or HANA version of SAP you can also view further information about DBERDL and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects