MMPROCMTPROJ_D

Transparent Table Application Table

Draft table for entity R_PROCUREMENTPROJECTTP

MMPROCMTPROJ_D is an SAP database table in S/4HANA. Draft table for entity R_PROCUREMENTPROJECTTP. It contains 17 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_ProcurementProjectDraft view_entity from EXTENSION Procurement Project - Extension
R_ProcurementProjectDraft view_entity from BASIC Procurement Project - Draft

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY procurementprojectuuid vdm_procurementprojectuuid Procurement Project UUID
procurementproject vdm_procurementproject Project
procurementprojectname vdm_procurementprojectname Name
externalprojectreference vdm_externalprojectreference External Project Reference
companycode bukrs Company Code
lastchangedbyuser vdm_lastchangedbyuserid Changed By
createdbyuser vdm_createdbyuserid Created By
lastchangedatetime vdm_lastchangedon Last Changed On
creationdatetime vdm_creationdatetime Created On
procurementprojectactvtnsts vdm_procurementprojactvtnsts Status
sourcingorigin vdm_sourcingorigin Sourcing Origin
sourcingscenario vdm_sourcingscenario Integration Scenario
procmtplanningsubprojectuuid vdm_procmtplngsubprojectuuid Procurement Planning Subproject UUID
isendofpurposeblocked eopblocked Busin. Purp. Cmpltd.
companycodeisnotauthorized vdm_companycodeisnotauthorized Company Code No Authorization indicator
companycodeforedit bukrs Company Code

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.

-- Draft table for entity R_PROCUREMENTPROJECTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPROCMTPROJ_D (
    MANDT,                         -- Client [mandt]
    PROCUREMENTPROJECTUUID,        -- Procurement Project UUID [vdm_procurementprojectuuid]
    PROCUREMENTPROJECT,            -- Project [vdm_procurementproject]
    PROCUREMENTPROJECTNAME,        -- Name [vdm_procurementprojectname]
    EXTERNALPROJECTREFERENCE,      -- External Project Reference [vdm_externalprojectreference]
    COMPANYCODE,                   -- Company Code [bukrs]
    LASTCHANGEDBYUSER,             -- Changed By [vdm_lastchangedbyuserid]
    CREATEDBYUSER,                 -- Created By [vdm_createdbyuserid]
    LASTCHANGEDATETIME,            -- Last Changed On [vdm_lastchangedon]
    CREATIONDATETIME,              -- Created On [vdm_creationdatetime]
    PROCUREMENTPROJECTACTVTNSTS,   -- Status [vdm_procurementprojactvtnsts]
    SOURCINGORIGIN,                -- Sourcing Origin [vdm_sourcingorigin]
    SOURCINGSCENARIO,              -- Integration Scenario [vdm_sourcingscenario]
    PROCMTPLANNINGSUBPROJECTUUID,  -- Procurement Planning Subproject UUID [vdm_procmtplngsubprojectuuid]
    ISENDOFPURPOSEBLOCKED,         -- Busin. Purp. Cmpltd. [eopblocked]
    COMPANYCODEISNOTAUTHORIZED,    -- Company Code No Authorization indicator [vdm_companycodeisnotauthorized]
    COMPANYCODEFOREDIT,            -- Company Code [bukrs]
    PRIMARY KEY (MANDT, PROCUREMENTPROJECTUUID)
);