I_MASTERPROJECTITEMLIST

CDS View
28 Fields 14 CDS Views

Master Project Item List

I_MASTERPROJECTITEMLIST is a CDS View in S/4HANA. Master Project Item List. It contains 28 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
I_MasterProjectSalesOrder view from COMPOSITE Get MasterProject Sales Order
I_MPNetwork view from COMPOSITE Get Master Project Network
I_MPNetworkActivity view from COMPOSITE Get Master Project Network Activity
I_MPWBSElement view from COMPOSITE Get Master Project WBS Elements
I_MstrProjMlstnDte view from COMPOSITE Get Project Next Milestone Date
I_MstrProjStrctrElmntWBC view from COMPOSITE Master Project Structure Element for WBC
I_MstrProjStrctrElmntWBC view union COMPOSITE Master Project Structure Element for WBC
I_MstrProjStructure view from COMPOSITE Master Project Structure Element
I_MstrProjStructureElement view from COMPOSITE Master Project Structure Element
I_MstrProjWBSElement view from COMPOSITE PROJECT COMPANION WBS ELEM
P_Mpnwe view from COMPOSITE
P_MPStructureElement view union COMPOSITE
P_Mpwbs view from COMPOSITE
P_MstrProjHierarchy view union COMPOSITE

Fields (28)

KeyField CDS FieldsUsed in Views
KEY MasterProject MasterProject 12
KEY MasterProjectUUID MasterProjectUUID 9
Country Country 2
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 2
Currency Currency 2
Customer Customer 2
EndDate EndDate 2
FinancialRisk FinancialRisk 2
Industry Industry 2
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 2
MasterProjectIsConfidential MasterProjectIsConfidential 11
MasterProjectItem MasterProjectItem,MstrProjAnchorObjectInternalID 6
MasterProjectItemObjectType ControllingObjectType,MasterProjectItemObjectType 5
MasterProjectItemUUID MasterProjectItemUUID 2
MasterProjectName MasterProjectName 9
MasterProjectOrganization MasterProjectOrganization 11
MasterProjectStage MasterProjectStage 3
MasterProjectType MasterProjectType 12
MstrProjCutOffDate MstrProjCutOffDate 2
OverallRisk OverallRisk 2
ProjectRisk ProjectRisk 2
Region Region 2
StartDate StartDate 2
TechnicalRisk TechnicalRisk 2
UserIsInvolved UserIsInvolved 2
WorkType WorkType 2

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 Item List
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MASTERPROJECTITEMLIST (
    MASTERPROJECT,
    MASTERPROJECTUUID,
    COUNTRY,
    CREATEDBYUSER,
    CREATIONDATETIME,
    CURRENCY,
    CUSTOMER,
    ENDDATE,
    FINANCIALRISK,
    INDUSTRY,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MASTERPROJECTISCONFIDENTIAL,
    MASTERPROJECTITEM,
    MASTERPROJECTITEMOBJECTTYPE,
    MASTERPROJECTITEMUUID,
    MASTERPROJECTNAME,
    MASTERPROJECTORGANIZATION,
    MASTERPROJECTSTAGE,
    MASTERPROJECTTYPE,
    MSTRPROJCUTOFFDATE,
    OVERALLRISK,
    PROJECTRISK,
    REGION,
    STARTDATE,
    TECHNICALRISK,
    USERISINVOLVED,
    WORKTYPE,
    PRIMARY KEY (MASTERPROJECT, MASTERPROJECTUUID)
);

Learn More