P_PROJECTSWITHPROJCAT6

CDS View

P_PROJECTSWITHPROJCAT6 is a CDS View in S/4HANA. It contains 15 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
P_EnterpriseProjectActCosts view inner COMPOSITE
P_EnterpriseProjectCmtmtCosts view inner COMPOSITE
P_EnterpriseProjectPlnCosts view inner COMPOSITE
P_PROJACTUALBUDGETLINEITEMS view from COMPOSITE
P_PROJACTUALBUDGETLINEITEMS view union_all COMPOSITE
P_PROJCMTMTBUDGETLINEITMS view from COMPOSITE Project Budget Commitment
P_PROJCMTMTBUDGETLINEITMS view inner COMPOSITE Project Budget Commitment
P_ProjectBudgetItems view from COMPOSITE
P_ProjPlnBudgetLineItms view from COMPOSITE
P_ProjPlnBudgetLineItms view union_all COMPOSITE

Fields (15)

KeyField CDS FieldsUsed in Views
AvailabilityControlIsActive AvailabilityControlIsActive 7
AvailabilityControlProfile AvailabilityControlProfile 7
ControllingArea ControllingArea 1
PlannedEndDate PlannedEndDate 1
PlannedStartDate PlannedStartDate 1
ProcessingStatus ProcessingStatus 3
ProjectCategory ProjectCategory 3
ProjectCurrency ControllingObjectCurrency,ProjectCurrency 4
ProjectDescription ProjectDescription 7
ProjectExternalID Project 6
ProjectInternalID ProjectInternalID 3
ProjectObject ProjectObject 7
ProjectProfileCode ProjectProfileCode 7
ProjectSummaryTaskUUID ProjectSummaryTaskUUID 3
ProjectUUID ProjectUUID 3

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PROJECTSWITHPROJCAT6 (
    AVAILABILITYCONTROLISACTIVE,
    AVAILABILITYCONTROLPROFILE,
    CONTROLLINGAREA,
    PLANNEDENDDATE,
    PLANNEDSTARTDATE,
    PROCESSINGSTATUS,
    PROJECTCATEGORY,
    PROJECTCURRENCY,
    PROJECTDESCRIPTION,
    PROJECTEXTERNALID,
    PROJECTINTERNALID,
    PROJECTOBJECT,
    PROJECTPROFILECODE,
    PROJECTSUMMARYTASKUUID,
    PROJECTUUID
);