DBERDL

Transparent Table Application Table
44 Fields 2 CDS Views

Print Document Line Items

DBERDL is an SAP database table in S/4HANA. Print Document Line Items. It contains 44 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
/UCOM/I_DBERDL view from BASIC Print Document Line Items
ISU_C4C_V2_BILL_AMOUNT view_entity left_outer Get the Billing amount details

Fields (44)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY printdoc E_PRINTDOC Print document
KEY printdocline BELZEILE Line item
refdocsource ISU_REFDOCSOURCE Orig. of source doc
refdocsourcekeya ISU_REFDOCSOURCEKEYA MainKey of SourceDoc
refdocsourcekeyb ISU_REFDOCSOURCEKEYB ServKey SourceDoc
belzart BELZART Line item type
bukrs BUKRS Company Code
sparte SPARTE Division
ktosl KTOSL Transaction
vertrag VERTRAG Contract
buchrel BUCHREL Line it.rel.pos
bruttozeile BRUTTOZEILE Gross line item
shkzg SHKZG Debit/Credit
aperiodic APERIODIC Non-Per.Posting
xtotal_amnt XTOTAL_AMNT Items in BST
nettobtr NETTOBTR Net amount
betrw BETRW_KK Amount
augbw AUGBW_KK TC Clearing Amt
sbasw SBASW_KK Tax Base Amount
sbetw SBETW_KK Tax Amount
sktow SKTOW_KK Discount in FC
twaers TWAERS Trans. currency
mwskz MWSKZ Tax Code
ermwskz ERMWSKZ Tax Determination
stprz STEUERSATZ Tax rate
txjcd TXJCD Tax Jur.
txdat_kk TXDAT_KK Tax Date
hvorg HVORG_KK Main Trans.
tvorg TVORG_KK Subtransaction
bldat BLDAT Document Date
budat BUDAT Posting Date
faedn FAEDN_KK Net Due Date
faeds FAEDS_KK Disct Due Date
sktpz SKTPZ_KK Discount rate
abpopbel ABPLANNR BB Plan
gsber GSBER Business Area
ca_opbel OPBEL_KK Document Number
linesort LINESORT Presorting
ab ABZEITSCH Valid From
bis BISZEITSCH Valid to
taxrate_internal STPRZ_KK Tax rate
sttax STTAX_KK Tax Portion
cologrp_bp_l E_COLOGRP_BP Coloc. Grp BP

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Print Document Line Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DBERDL (
    MANDT,             -- Client [MANDT]
    PRINTDOC,          -- Print document [E_PRINTDOC]
    PRINTDOCLINE,      -- Line item [BELZEILE]
    REFDOCSOURCE,      -- Orig. of source doc [ISU_REFDOCSOURCE]
    REFDOCSOURCEKEYA,  -- MainKey of SourceDoc [ISU_REFDOCSOURCEKEYA]
    REFDOCSOURCEKEYB,  -- ServKey SourceDoc [ISU_REFDOCSOURCEKEYB]
    BELZART,           -- Line item type [BELZART]
    BUKRS,             -- Company Code [BUKRS]
    SPARTE,            -- Division [SPARTE]
    KTOSL,             -- Transaction [KTOSL]
    VERTRAG,           -- Contract [VERTRAG]
    BUCHREL,           -- Line it.rel.pos [BUCHREL]
    BRUTTOZEILE,       -- Gross line item [BRUTTOZEILE]
    SHKZG,             -- Debit/Credit [SHKZG]
    APERIODIC,         -- Non-Per.Posting [APERIODIC]
    XTOTAL_AMNT,       -- Items in BST [XTOTAL_AMNT]
    NETTOBTR,          -- Net amount [NETTOBTR]
    BETRW,             -- Amount [BETRW_KK]
    AUGBW,             -- TC Clearing Amt [AUGBW_KK]
    SBASW,             -- Tax Base Amount [SBASW_KK]
    SBETW,             -- Tax Amount [SBETW_KK]
    SKTOW,             -- Discount in FC [SKTOW_KK]
    TWAERS,            -- Trans. currency [TWAERS]
    MWSKZ,             -- Tax Code [MWSKZ]
    ERMWSKZ,           -- Tax Determination [ERMWSKZ]
    STPRZ,             -- Tax rate [STEUERSATZ]
    TXJCD,             -- Tax Jur. [TXJCD]
    TXDAT_KK,          -- Tax Date [TXDAT_KK]
    HVORG,             -- Main Trans. [HVORG_KK]
    TVORG,             -- Subtransaction [TVORG_KK]
    BLDAT,             -- Document Date [BLDAT]
    BUDAT,             -- Posting Date [BUDAT]
    FAEDN,             -- Net Due Date [FAEDN_KK]
    FAEDS,             -- Disct Due Date [FAEDS_KK]
    SKTPZ,             -- Discount rate [SKTPZ_KK]
    ABPOPBEL,          -- BB Plan [ABPLANNR]
    GSBER,             -- Business Area [GSBER]
    CA_OPBEL,          -- Document Number [OPBEL_KK]
    LINESORT,          -- Presorting [LINESORT]
    AB,                -- Valid From [ABZEITSCH]
    BIS,               -- Valid to [BISZEITSCH]
    TAXRATE_INTERNAL,  -- Tax rate [STPRZ_KK]
    STTAX,             -- Tax Portion [STTAX_KK]
    COLOGRP_BP_L,      -- Coloc. Grp BP [E_COLOGRP_BP]
    PRIMARY KEY (MANDT, PRINTDOC, PRINTDOCLINE)
);

Learn More