SDCUSTMAT_D

Transparent Table Application Table
29 Fields 2 CDS Views

Draft table for entity R_CUSTOMERMATERIALTP

SDCUSTMAT_D is an SAP database table in S/4HANA. Draft table for entity R_CUSTOMERMATERIALTP. It contains 29 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CustomerMaterialDraft view_entity from EXTENSION Customer Material drft - Extension
R_CustomerMaterialDraft view_entity from BASIC Customer Material - Draft

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY salesorganization vkorg Sales Org.
KEY distributionchannel vtweg Distr. Channel
KEY customer kunnr_v Customer
KEY product productnumber Product
KEY draftuuid sdraft_uuid Draft Document ID
salesorganizationforedit vkorg Sales Org.
distributionchannelforedit vtweg Distr. Channel
customerforedit kunnr_v Customer
productforedit productnumber Product
materialbycustomer matnr_ku Cust. Material
materialdescriptionbycustomer kdptx Customer Descr.
customermaterialsearchterm sortl Search term
roundingprofile rdprf Rnding Profile
plant werks_ext Plant
deliverypriority lprio Delivery Prior.
mindeliveryqtyinbaseunit minlf Min. Dely Qty
baseunit meins Base Unit
partialdeliveryisallowed kztlf Part.dlv./item
maxnmbrofpartialdelivery antlf Max.Part.Deliv.
underdelivtolrtdlmtratioinpct untto Underdel. Tol.
overdelivtolrtdlmtratioinpct uebto Overdeliv. Tol.
unlimitedoverdeliveryisallowed uebtk_v Unlimited Tol.
customermaterialitemusage vwpos Item Usage
salesunit vrkme Sales Unit
salesqtytobaseqtydnmntr umvkn Denominat.
salesqtytobaseqtynmrtr umvkz Numerator
lastchangedbyuser last_changed_by_user Last Changed By
lastchangedatetime last_changed_date_time Last Changed On

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 R_CUSTOMERMATERIALTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDCUSTMAT_D (
    MANDT,                           -- Client [mandt]
    SALESORGANIZATION,               -- Sales Org. [vkorg]
    DISTRIBUTIONCHANNEL,             -- Distr. Channel [vtweg]
    CUSTOMER,                        -- Customer [kunnr_v]
    PRODUCT,                         -- Product [productnumber]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    SALESORGANIZATIONFOREDIT,        -- Sales Org. [vkorg]
    DISTRIBUTIONCHANNELFOREDIT,      -- Distr. Channel [vtweg]
    CUSTOMERFOREDIT,                 -- Customer [kunnr_v]
    PRODUCTFOREDIT,                  -- Product [productnumber]
    MATERIALBYCUSTOMER,              -- Cust. Material [matnr_ku]
    MATERIALDESCRIPTIONBYCUSTOMER,   -- Customer Descr. [kdptx]
    CUSTOMERMATERIALSEARCHTERM,      -- Search term [sortl]
    ROUNDINGPROFILE,                 -- Rnding Profile [rdprf]
    PLANT,                           -- Plant [werks_ext]
    DELIVERYPRIORITY,                -- Delivery Prior. [lprio]
    MINDELIVERYQTYINBASEUNIT,        -- Min. Dely Qty [minlf]
    BASEUNIT,                        -- Base Unit [meins]
    PARTIALDELIVERYISALLOWED,        -- Part.dlv./item [kztlf]
    MAXNMBROFPARTIALDELIVERY,        -- Max.Part.Deliv. [antlf]
    UNDERDELIVTOLRTDLMTRATIOINPCT,   -- Underdel. Tol. [untto]
    OVERDELIVTOLRTDLMTRATIOINPCT,    -- Overdeliv. Tol. [uebto]
    UNLIMITEDOVERDELIVERYISALLOWED,  -- Unlimited Tol. [uebtk_v]
    CUSTOMERMATERIALITEMUSAGE,       -- Item Usage [vwpos]
    SALESUNIT,                       -- Sales Unit [vrkme]
    SALESQTYTOBASEQTYDNMNTR,         -- Denominat. [umvkn]
    SALESQTYTOBASEQTYNMRTR,          -- Numerator [umvkz]
    LASTCHANGEDBYUSER,               -- Last Changed By [last_changed_by_user]
    LASTCHANGEDATETIME,              -- Last Changed On [last_changed_date_time]
    PRIMARY KEY (MANDT, SALESORGANIZATION, DISTRIBUTIONCHANNEL, CUSTOMER, PRODUCT, DRAFTUUID)
);

Learn More