DBERDLB

Transparent Table Application Table
16 Fields 1 CDS Views

Reference of a Print Doc. Line Item to a Bill.Doc. Line Item

DBERDLB is an SAP database table in S/4HANA. Reference of a Print Doc. Line Item to a Bill.Doc. Line Item. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
ISU_C4C_V2_BILL_AMOUNT view_entity left_outer Get the Billing amount details

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY printdoc E_PRINTDOC Print document
KEY printdocline BELZEILE Line item
billdoc E_BELNR Billing Doc.No.
billdocline BELZEILE Line item
hvorg HVORG_KK Main Trans.
bukrs BUKRS Company Code
xtotal_amnt XTOTAL_AMNT Items in BST
vertrag VERTRAG Contract
abpopbel ABPLANNR BB Plan
sparte SPARTE Division
txjcd TXJCD Tax Jur.
mwskz MWSKZ Tax Code
nettobtr NETTOBTR Net amount
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.

-- Reference of a Print Doc. Line Item to a Bill.Doc. Line Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DBERDLB (
    MANDT,         -- Client [MANDT]
    PRINTDOC,      -- Print document [E_PRINTDOC]
    PRINTDOCLINE,  -- Line item [BELZEILE]
    BILLDOC,       -- Billing Doc.No. [E_BELNR]
    BILLDOCLINE,   -- Line item [BELZEILE]
    HVORG,         -- Main Trans. [HVORG_KK]
    BUKRS,         -- Company Code [BUKRS]
    XTOTAL_AMNT,   -- Items in BST [XTOTAL_AMNT]
    VERTRAG,       -- Contract [VERTRAG]
    ABPOPBEL,      -- BB Plan [ABPLANNR]
    SPARTE,        -- Division [SPARTE]
    TXJCD,         -- Tax Jur. [TXJCD]
    MWSKZ,         -- Tax Code [MWSKZ]
    NETTOBTR,      -- Net amount [NETTOBTR]
    STTAX,         -- Tax Portion [STTAX_KK]
    COLOGRP_BP_L,  -- Coloc. Grp BP [E_COLOGRP_BP]
    PRIMARY KEY (MANDT, PRINTDOC, PRINTDOCLINE)
);

Learn More