I_MSTRPROJHIERLIST

CDS View
32 Fields 1 CDS Views

Master Project Hierarchy List

I_MSTRPROJHIERLIST is a CDS View in S/4HANA. Master Project Hierarchy List. It contains 32 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_MstrProjHierSales view from COMPOSITE

Fields (32)

KeyField CDS FieldsUsed in Views
KEY MasterProjectUUID MasterProjectUUID 1
BusinessArea BusinessArea 1
CompanyCode CompanyCode 1
ControllingArea ControllingArea 1
ControllingAreaCurrency ControllingAreaCurrency 1
ControllingObject ControllingObject 1
ControllingObjectInternalID ControllingObjectInternalID 1
Country Country 1
Customer Customer 1
EndDate EndDate 1
ExternalId ExternalId 1
FinancialRisk FinancialRisk 1
Industry Industry 1
MasterProject MasterProject 1
MasterProjectIsConfidential MasterProjectIsConfidential 1
MasterProjectItem MasterProjectItem 1
MasterProjectItemObjectType MasterProjectItemObjectType 1
MasterProjectItemUUID MasterProjectItemUUID 1
MasterProjectName MasterProjectName 1
MasterProjectOrganization MasterProjectOrganization 1
MasterProjectStage MasterProjectStage 1
MasterProjectType MasterProjectType 1
OverallRisk OverallRisk 1
ProjectRisk ProjectRisk 1
Region Region 1
SalesDocument SalesDocument 1
StartDate StartDate 1
TechnicalRisk TechnicalRisk 1
WBSElement WBSElement 1
WBSElementInternalID WBSElementInternalID 1
WBSElementObject WBSElementObject 1
WorkType WorkType 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_MSTRPROJHIERLIST (
    MASTERPROJECTUUID,
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    CONTROLLINGAREACURRENCY,
    CONTROLLINGOBJECT,
    CONTROLLINGOBJECTINTERNALID,
    COUNTRY,
    CUSTOMER,
    ENDDATE,
    EXTERNALID,
    FINANCIALRISK,
    INDUSTRY,
    MASTERPROJECT,
    MASTERPROJECTISCONFIDENTIAL,
    MASTERPROJECTITEM,
    MASTERPROJECTITEMOBJECTTYPE,
    MASTERPROJECTITEMUUID,
    MASTERPROJECTNAME,
    MASTERPROJECTORGANIZATION,
    MASTERPROJECTSTAGE,
    MASTERPROJECTTYPE,
    OVERALLRISK,
    PROJECTRISK,
    REGION,
    SALESDOCUMENT,
    STARTDATE,
    TECHNICALRISK,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    WBSELEMENTOBJECT,
    WORKTYPE,
    PRIMARY KEY (MASTERPROJECTUUID)
);

Learn More