SUPP_DUNN_D

Transparent Table Application Table

Draft table for entity I_SUPPLIERDUNNINGTP

SUPP_DUNN_D is an SAP database table in S/4HANA. Draft table for entity I_SUPPLIERDUNNINGTP. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SupplierDunningDraft view_entity from BASIC Supplier Dunning - Draft

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY businesspartner bu_partner Busn. Partner
KEY supplier lifnr Supplier
KEY companycode bukrs Company Code
KEY dunningarea maber Dunning Area
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
businesspartnerforedit bu_partner Busn. Partner
supplierforedit lifnr Supplier
companycodeforedit bukrs Company Code
dunningareaforedit maber Dunning Area
dunningrecipient lfrma Dunn.recipient
legdunningprocedureon gmvdt Leg.Dunn.Proc.
lastdunnedon madat Last Dunned
dunningprocedure mahna Dunn.Procedure
dunninglevel mahns_d Dunning Level
dunningblock mansp Dunn. Block
dunningclerk busab_ma Dunning Clerk
authorizationgroup brgru Authorization
supplieraccountgroup ktokk Account group
isbusinesspurposecompleted cvp_xblck Purpose Completed
standardusage boole_d TRUE
bpsupplierdraftuuid sdraft_uuid Draft Document ID
businesspartnerdraftuuid sdraft_uuid Draft Document ID

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.

-- Draft table for entity I_SUPPLIERDUNNINGTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SUPP_DUNN_D (
    MANDT,                       -- Client [mandt]
    BUSINESSPARTNER,             -- Busn. Partner [bu_partner]
    SUPPLIER,                    -- Supplier [lifnr]
    COMPANYCODE,                 -- Company Code [bukrs]
    DUNNINGAREA,                 -- Dunning Area [maber]
    DRAFTUUID,                   -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,             -- Draft Document ID [sdraft_uuid]
    BUSINESSPARTNERFOREDIT,      -- Busn. Partner [bu_partner]
    SUPPLIERFOREDIT,             -- Supplier [lifnr]
    COMPANYCODEFOREDIT,          -- Company Code [bukrs]
    DUNNINGAREAFOREDIT,          -- Dunning Area [maber]
    DUNNINGRECIPIENT,            -- Dunn.recipient [lfrma]
    LEGDUNNINGPROCEDUREON,       -- Leg.Dunn.Proc. [gmvdt]
    LASTDUNNEDON,                -- Last Dunned [madat]
    DUNNINGPROCEDURE,            -- Dunn.Procedure [mahna]
    DUNNINGLEVEL,                -- Dunning Level [mahns_d]
    DUNNINGBLOCK,                -- Dunn. Block [mansp]
    DUNNINGCLERK,                -- Dunning Clerk [busab_ma]
    AUTHORIZATIONGROUP,          -- Authorization [brgru]
    SUPPLIERACCOUNTGROUP,        -- Account group [ktokk]
    ISBUSINESSPURPOSECOMPLETED,  -- Purpose Completed [cvp_xblck]
    STANDARDUSAGE,               -- TRUE [boole_d]
    BPSUPPLIERDRAFTUUID,         -- Draft Document ID [sdraft_uuid]
    BUSINESSPARTNERDRAFTUUID,    -- Draft Document ID [sdraft_uuid]
    PRIMARY KEY (MANDT, BUSINESSPARTNER, SUPPLIER, COMPANYCODE, DUNNINGAREA, DRAFTUUID)
);