MMPROCMTPROJ_D
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_ProcurementProjectDraft | view_entity | from | EXTENSION | Procurement Project - Extension |
| R_ProcurementProjectDraft | view_entity | from | BASIC | Procurement Project - Draft |
Fields (17)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 | vdm_companycodeforedit | 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 [vdm_companycodeforedit]
PRIMARY KEY (MANDT, PROCUREMENTPROJECTUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA