PROD_SCM

Transparent Table Application Table
19 Fields 1 CDS Views

I_PRODUCTWD I_PRODUCTSCMWD

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_Productscmd view from EXTENSION Product Scm Extension

Fields (19)

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
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_prd_incl_eew_ps PRD_INCL_EEW Dummy Field

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]
    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_PRD_INCL_EEW_PS,          -- Dummy Field [PRD_INCL_EEW]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More