CUST_DUNN_D

Transparent Table Application Table
25 Fields 1 CDS Views

Draft table for entity I_CUSTOMERDUNNINGTP

CUST_DUNN_D is an SAP database table in S/4HANA. Draft table for entity I_CUSTOMERDUNNINGTP. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_CustomerDunningDraft view_entity from BASIC Customer Dunning - Draft

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY businesspartner bu_partner Busn. Partner
KEY companycode bukrs Company Code
KEY customer kunnr Customer
KEY dunningarea maber Dunning Area
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
businesspartnerforedit bu_partner Busn. Partner
customerforedit kunnr Customer
companycodeforedit bukrs Company Code
dunningareaforedit maber Dunning Area
businesspartneruuid bu_partner_guid BP GUID
lastdunnedon madat Last Dunned
dunningprocedure mahna Dunn.Procedure
dunninglevel mahns_d Dunning Level
dunningblock mansp Dunn. Block
dunningrecipient knrma Dunn.Recipient
legdunningprocedureon gmvdt Leg.Dunn.Proc.
dunningclerk busab_ma Dunning Clerk
customercompanyauthzngroup brgru Authorization
authorizationgroup bu_augrp Authorization Group
isbusinesspurposecompleted bu_xpcpt Purpose Completed
standardusage boole_d TRUE
buspartcustomerdraftuuid 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_CUSTOMERDUNNINGTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CUST_DUNN_D (
    MANDT,                       -- Client [mandt]
    BUSINESSPARTNER,             -- Busn. Partner [bu_partner]
    COMPANYCODE,                 -- Company Code [bukrs]
    CUSTOMER,                    -- Customer [kunnr]
    DUNNINGAREA,                 -- Dunning Area [maber]
    DRAFTUUID,                   -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,             -- Draft Document ID [sdraft_uuid]
    BUSINESSPARTNERFOREDIT,      -- Busn. Partner [bu_partner]
    CUSTOMERFOREDIT,             -- Customer [kunnr]
    COMPANYCODEFOREDIT,          -- Company Code [bukrs]
    DUNNINGAREAFOREDIT,          -- Dunning Area [maber]
    BUSINESSPARTNERUUID,         -- BP GUID [bu_partner_guid]
    LASTDUNNEDON,                -- Last Dunned [madat]
    DUNNINGPROCEDURE,            -- Dunn.Procedure [mahna]
    DUNNINGLEVEL,                -- Dunning Level [mahns_d]
    DUNNINGBLOCK,                -- Dunn. Block [mansp]
    DUNNINGRECIPIENT,            -- Dunn.Recipient [knrma]
    LEGDUNNINGPROCEDUREON,       -- Leg.Dunn.Proc. [gmvdt]
    DUNNINGCLERK,                -- Dunning Clerk [busab_ma]
    CUSTOMERCOMPANYAUTHZNGROUP,  -- Authorization [brgru]
    AUTHORIZATIONGROUP,          -- Authorization Group [bu_augrp]
    ISBUSINESSPURPOSECOMPLETED,  -- Purpose Completed [bu_xpcpt]
    STANDARDUSAGE,               -- TRUE [boole_d]
    BUSPARTCUSTOMERDRAFTUUID,    -- Draft Document ID [sdraft_uuid]
    BUSINESSPARTNERDRAFTUUID,    -- Draft Document ID [sdraft_uuid]
    PRIMARY KEY (MANDT, BUSINESSPARTNER, COMPANYCODE, CUSTOMER, DUNNINGAREA, DRAFTUUID)
);

Learn More