I_MSTRPROJCOMMITMENT

CDS View

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)

ViewTypeJoinVDMDescription
P_MstrProjAggrgdCmtmt view from COMPOSITE
P_MstrProjHierCommitment view inner COMPOSITE

Fields (19)

KeyField CDS FieldsUsed 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)
);