PROD_SCM

Transparent Table Application Table
13 Fields 1 CDS Views

I_PRODUCTWD I_PRODUCTSCMWD

PROD_SCM is an SAP database table in S/4HANA. I_PRODUCTWD I_PRODUCTSCMWD. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_Productscmd view from EXTENSION Product Scm Extension

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY draftuuid /bobf/uuid Key
parentdraftuuid /bobf/uuid Key
product matnr Material
productforedit matnr Material
maturationduration cmd_prd_maturity_dur_n Maturation Time
maturationdurationcalc cmd_prd_maturity_dur Maturation Time
requiredmaxshelflife cmd_prd_shelf_life_req_max_n Req.Max.Sh.Life
requiredmaxshelflifecalc cmd_prd_shelf_life_req_max Req.Max.Sh.Life
preferredalternativeunit /scwm/de_puom Preferred UoM
totalshelflife mhdhb Tot. shelf life
authorizationgroup begru AuthorizGroup
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_PRODUCTWD I_PRODUCTSCMWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROD_SCM (
    MANDT,                     -- Client [mandt]
    DRAFTUUID,                 -- Key [/bobf/uuid]
    PARENTDRAFTUUID,           -- Key [/bobf/uuid]
    PRODUCT,                   -- Material [matnr]
    PRODUCTFOREDIT,            -- Material [matnr]
    MATURATIONDURATION,        -- Maturation Time [cmd_prd_maturity_dur_n]
    MATURATIONDURATIONCALC,    -- Maturation Time [cmd_prd_maturity_dur]
    REQUIREDMAXSHELFLIFE,      -- Req.Max.Sh.Life [cmd_prd_shelf_life_req_max_n]
    REQUIREDMAXSHELFLIFECALC,  -- Req.Max.Sh.Life [cmd_prd_shelf_life_req_max]
    PREFERREDALTERNATIVEUNIT,  -- Preferred UoM [/scwm/de_puom]
    TOTALSHELFLIFE,            -- Tot. shelf life [mhdhb]
    AUTHORIZATIONGROUP,        -- AuthorizGroup [begru]
    HASACTIVEENTITY,           -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More