MMPUR_MPS_HDR_D

Transparent Table Application Table
20 Fields 2 CDS Views

Model Product Specification Header - Draft

MMPUR_MPS_HDR_D is an SAP database table in S/4HANA. Model Product Specification Header - Draft. It contains 20 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_ModelProductSpecificationD view_entity from EXTENSION Model Product Specification - Extension
R_ModProdSpecDraft view_entity from BASIC Model Product Specification - Draft

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY modelproductspecificationuuid MMPUR_MPS_UUID UUID
modelproductspecification MMPUR_MPS_ID ID
modelproductspecificationname MMPUR_MPS_NAME Name
modprodspecgroupingcode MMPUR_MPS_GROUPING_CODE Grouping Code
modprodspecsearchtermtext MMPUR_MPS_SEARCH_TERM Search Term
modprodspecactvtnstatuscode MMPUR_MPS_ACTIVATION_STATUS Activation Status
language DDLANGUAGE Lang.
isdeleted MMPUR_MPS_IS_DELETED Deleted
creationdatetime MMPUR_MPS_CREATION_DATE_TIME Created On
createdbyuser MMPUR_MPS_CREATED_BY_USER Created By
lastchangedatetime MMPUR_MPS_LAST_CHG_DATE_TIME Changed On
lastchangedbyuser MMPUR_MPS_LAST_CHANGED_BY_USER Changed By
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes
dummy_mmpur_mps_incl_eew_ps MMPUR_MPS_HEADER_INCL_EEW Ext. Include

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.

-- Model Product Specification Header - Draft
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_MPS_HDR_D (
    MANDT,                          -- Client [MANDT]
    MODELPRODUCTSPECIFICATIONUUID,  -- UUID [MMPUR_MPS_UUID]
    MODELPRODUCTSPECIFICATION,      -- ID [MMPUR_MPS_ID]
    MODELPRODUCTSPECIFICATIONNAME,  -- Name [MMPUR_MPS_NAME]
    MODPRODSPECGROUPINGCODE,        -- Grouping Code [MMPUR_MPS_GROUPING_CODE]
    MODPRODSPECSEARCHTERMTEXT,      -- Search Term [MMPUR_MPS_SEARCH_TERM]
    MODPRODSPECACTVTNSTATUSCODE,    -- Activation Status [MMPUR_MPS_ACTIVATION_STATUS]
    LANGUAGE,                       -- Lang. [DDLANGUAGE]
    ISDELETED,                      -- Deleted [MMPUR_MPS_IS_DELETED]
    CREATIONDATETIME,               -- Created On [MMPUR_MPS_CREATION_DATE_TIME]
    CREATEDBYUSER,                  -- Created By [MMPUR_MPS_CREATED_BY_USER]
    LASTCHANGEDATETIME,             -- Changed On [MMPUR_MPS_LAST_CHG_DATE_TIME]
    LASTCHANGEDBYUSER,              -- Changed By [MMPUR_MPS_LAST_CHANGED_BY_USER]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_MMPUR_MPS_INCL_EEW_PS,    -- Ext. Include [MMPUR_MPS_HEADER_INCL_EEW]
    PRIMARY KEY (MANDT, MODELPRODUCTSPECIFICATIONUUID)
);

Learn More