MMPROCMTPROJ
Procurement Project
MMPROCMTPROJ is an SAP database table in S/4HANA. Procurement Project. It contains 15 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_ProcurementProject | view_entity | from | EXTENSION | Procurement Project - Extension |
| R_ProcurementProject | view | from | BASIC | Procurement Project |
Fields (15)
| 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 | ||||
| createdbyuser | vdm_createdbyuserid | Created By | ||||
| lastchangedbyuser | vdm_lastchangedbyuserid | Changed By | ||||
| creationdatetime | vdm_creationdatetime | Created On | ||||
| lastchangedatetime | vdm_lastchangedon | Last Changed On | ||||
| procurementprojectactvtnsts | vdm_procurementprojactvtnsts | Status | ||||
| procmtplanningsubprojectuuid | vdm_procmtplngsubprojectuuid | Procurement Planning Subproject UUID | ||||
| sourcingorigin | vdm_sourcingorigin | Sourcing Origin | ||||
| sourcingscenario | vdm_sourcingscenario | Integration Scenario | ||||
| iseopblocked | eopblocked | Busin. Purp. Cmpltd. |
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.
-- Procurement Project
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPROCMTPROJ (
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]
CREATEDBYUSER, -- Created By [vdm_createdbyuserid]
LASTCHANGEDBYUSER, -- Changed By [vdm_lastchangedbyuserid]
CREATIONDATETIME, -- Created On [vdm_creationdatetime]
LASTCHANGEDATETIME, -- Last Changed On [vdm_lastchangedon]
PROCUREMENTPROJECTACTVTNSTS, -- Status [vdm_procurementprojactvtnsts]
PROCMTPLANNINGSUBPROJECTUUID, -- Procurement Planning Subproject UUID [vdm_procmtplngsubprojectuuid]
SOURCINGORIGIN, -- Sourcing Origin [vdm_sourcingorigin]
SOURCINGSCENARIO, -- Integration Scenario [vdm_sourcingscenario]
ISEOPBLOCKED, -- Busin. Purp. Cmpltd. [eopblocked]
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