I_MSTRPROJCOMMITMENT
Commercial Project Commitment
I_MSTRPROJCOMMITMENT is a CDS View in S/4HANA. Commercial Project Commitment. It contains 19 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_MstrProjAggrgdCmtmt | view | from | COMPOSITE | |
| P_MstrProjHierCommitment | view | inner | COMPOSITE |
Fields (19)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ControllingObject | ControllingObject | 1 |
| AmountInCompanyCodeCurrency | CmtmtCostInCCCrcy | 1 | |
| AmountInGlobalCurrency | CmtmtCostInGlobalCurrency | 1 | |
| AmountInObjectCurrency | CmtmtCostInObjCrcy | 1 | |
| AmountInTransactionCurrency | CmtmtCostInTransacCrcy | 1 | |
| BaseUnit | BaseUnit | 1 | |
| CompanyCode | CompanyCode | 1 | |
| ControllingArea | ControllingArea | 2 | |
| ControllingValueType | ControllingValueType | 1 | |
| CostElement | CostElement | 1 | |
| DocumentDate | DocumentDate | 1 | |
| FiscalYear | FiscalYear | 1 | |
| Material | Material | 1 | |
| MstrProjCmtmtOpnBaseQty | MstrProjCmtmtOpnBaseQty | 1 | |
| MstrProjCmtmtOpnQty | MstrProjCmtmtOpnQty | 1 | |
| RefPurDocNmbr | RefPurDocNmbr | 1 | |
| RequirementDate | RequirementDate | 1 | |
| TransactionCurrency | TransactionCurrency | 1 | |
| UnitOfMeasure | UnitOfMeasure | 1 |
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.
-- Commercial Project Commitment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MSTRPROJCOMMITMENT (
CONTROLLINGOBJECT,
AMOUNTINCOMPANYCODECURRENCY,
AMOUNTINGLOBALCURRENCY,
AMOUNTINOBJECTCURRENCY,
AMOUNTINTRANSACTIONCURRENCY,
BASEUNIT,
COMPANYCODE,
CONTROLLINGAREA,
CONTROLLINGVALUETYPE,
COSTELEMENT,
DOCUMENTDATE,
FISCALYEAR,
MATERIAL,
MSTRPROJCMTMTOPNBASEQTY,
MSTRPROJCMTMTOPNQTY,
REFPURDOCNMBR,
REQUIREMENTDATE,
TRANSACTIONCURRENCY,
UNITOFMEASURE,
PRIMARY KEY (CONTROLLINGOBJECT)
);
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