ICUSTMATDRAFT

Transparent Table Application Table
33 Fields 1 CDS Views

I_CUSTOMERMATERIALTP I_CUSTOMERMATERIALTP

ICUSTMATDRAFT is an SAP database table in S/4HANA. I_CUSTOMERMATERIALTP I_CUSTOMERMATERIALTP. It contains 33 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_CL_SDM_SD_KNMT_SORTL view union_all BASIC

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY draftuuid /bobf/uuid Key
salesorganization vkorg Sales Org.
distributionchannel vtweg Distr. Channel
customer kunnr_v Customer
material productnumber Product
salesorganizationname salesorganizationname Sales Organization Description
salesorganizationforedit vkorg Sales Org.
distributionchannelforedit vtweg Distr. Channel
customerforedit kunnr_v Customer
materialforedit productnumber Product
customermaterialsearchterm sortl Search term
materialbycustomer matnr_ku Cust. Material
materialbycustomerforedit matnr_ku Cust. Material
materialname maktx Description
materialdescriptionbycustomer kdptx Customer Descr.
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
hasactiveentity sdraft_has_active Has active

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.

-- I_CUSTOMERMATERIALTP I_CUSTOMERMATERIALTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICUSTMATDRAFT (
    MANDT,                           -- Client [mandt]
    DRAFTUUID,                       -- Key [/bobf/uuid]
    SALESORGANIZATION,               -- Sales Org. [vkorg]
    DISTRIBUTIONCHANNEL,             -- Distr. Channel [vtweg]
    CUSTOMER,                        -- Customer [kunnr_v]
    MATERIAL,                        -- Product [productnumber]
    SALESORGANIZATIONNAME,           -- Sales Organization Description [salesorganizationname]
    SALESORGANIZATIONFOREDIT,        -- Sales Org. [vkorg]
    DISTRIBUTIONCHANNELFOREDIT,      -- Distr. Channel [vtweg]
    CUSTOMERFOREDIT,                 -- Customer [kunnr_v]
    MATERIALFOREDIT,                 -- Product [productnumber]
    CUSTOMERMATERIALSEARCHTERM,      -- Search term [sortl]
    MATERIALBYCUSTOMER,              -- Cust. Material [matnr_ku]
    MATERIALBYCUSTOMERFOREDIT,       -- Cust. Material [matnr_ku]
    MATERIALNAME,                    -- Description [maktx]
    MATERIALDESCRIPTIONBYCUSTOMER,   -- Customer Descr. [kdptx]
    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]
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More