ICUSTMATDRAFT

Transparent Table Application Table
39 Fields 1 CDS Views

I_CUSTOMERMATERIALTP I_CUSTOMERMATERIALTP

ICUSTMATDRAFT is an SAP database table in S/4HANA. I_CUSTOMERMATERIALTP I_CUSTOMERMATERIALTP. It contains 39 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 (39)

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
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code
dummy_slscusmat_incl_eew_ps DUMMY Dummy function in length 1

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]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    DUMMY_SLSCUSMAT_INCL_EEW_PS,     -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More