I_MSTRPROJHIERARCHY

CDS View
20 Fields 7 CDS Views

Master Project Hierarchy List

I_MSTRPROJHIERARCHY is a CDS View in S/4HANA. Master Project Hierarchy List. It contains 20 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_EarnedValueData view inner COMPOSITE Requirement Earned Value Calculations
P_MstrProjActualRevCost view from COMPOSITE
P_MstrProjCtrlgObjActlRevCost view from COMPOSITE
P_MstrProjPlanCost view from COMPOSITE
P_MstrProjSalesOrdActuals view from COMPOSITE
P_Plancost view inner COMPOSITE
P_PLANCOSTTILLMONTH view from COMPOSITE

Fields (20)

KeyField CDS FieldsUsed in Views
KEY MasterProject MasterProject 6
KEY MasterProjectUUID MasterProjectUUID 6
_MstrProjFinPlan _MstrProjFinPlan 1
_MstrProjPerdKPI _MstrProjPerdKPI 1
_MstrProjType _MstrProjType 1
ControllingObject AccoutAssgmntObj,ControllingObject 5
ControllingObjectExternalID ControllingObjectExternalID 3
ControllingObjectType ControllingObjectType 3
Currency Currency 3
ExternalObjectIdentifier ExternalObjectIdentifier 1
MasterProjectIsConfidential MasterProjectIsConfidential 6
MasterProjectName MasterProjectName 4
MasterProjectOrganization MasterProjectOrganization 6
MasterProjectType MasterProjectType 6
MstrProjAnchorObjectInternalID MstrProjAnchorObjectInternalID 1
MstrProjCutOffDate MstrProjCutOffDate 1
Project Project 4
ProjectDescription ProjectDescription 4
WBSElement WBSElement 1
WBSElementObject WBSElementObject 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.

-- Master Project Hierarchy List
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MSTRPROJHIERARCHY (
    MASTERPROJECT,
    MASTERPROJECTUUID,
    _MSTRPROJFINPLAN,
    _MSTRPROJPERDKPI,
    _MSTRPROJTYPE,
    CONTROLLINGOBJECT,
    CONTROLLINGOBJECTEXTERNALID,
    CONTROLLINGOBJECTTYPE,
    CURRENCY,
    EXTERNALOBJECTIDENTIFIER,
    MASTERPROJECTISCONFIDENTIAL,
    MASTERPROJECTNAME,
    MASTERPROJECTORGANIZATION,
    MASTERPROJECTTYPE,
    MSTRPROJANCHOROBJECTINTERNALID,
    MSTRPROJCUTOFFDATE,
    PROJECT,
    PROJECTDESCRIPTION,
    WBSELEMENT,
    WBSELEMENTOBJECT,
    PRIMARY KEY (MASTERPROJECT, MASTERPROJECTUUID)
);

Learn More