P_PROJECTSWITHPROJCAT6

CDS View

Enterprise Proj and Project with Project Category 7

P_PROJECTSWITHPROJCAT6 is a CDS View in S/4HANA. Enterprise Proj and Project with Project Category 7. It contains 16 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
P_EnterpriseProjectActCosts view from COMPOSITE Project Cost Line Items with Actual Costs
P_EnterpriseProjectCmtmtCosts view from COMPOSITE Project Cost Line Items with Commitment Costs
P_EnterpriseProjectPlnCosts view from COMPOSITE Project Cost Line Items with Planning Category Costs
P_PROJACTUALBUDGETLINEITEMS view union COMPOSITE Project Budget Actuals
P_PROJCMTMTBUDGETLINEITMS view from COMPOSITE Project Budget Commitment
P_PROJCMTMTBUDGETLINEITMS view union_all COMPOSITE Project Budget Commitment
P_ProjectBudgetItems view from COMPOSITE Project Budget Items
P_ProjPlnBudgetLineItms view union_all COMPOSITE Project Budget Plan

Fields (16)

KeyField CDS FieldsUsed in Views
AvailabilityControlIsActive AvailabilityControlIsActive 7
AvailabilityControlProfile AvailabilityControlProfile 7
ControllingArea ControllingArea 1
PlannedEndDate PlannedEndDate 1
PlannedStartDate PlannedStartDate 1
ProcessingStatus ProcessingStatus 3
ProfitCenter ProfitCenter 3
ProjectCategory ProjectCategory 3
ProjectCurrency ControllingObjectCurrency,ProjectCurrency 4
ProjectDescription ProjectDescription 7
ProjectExternalID Project 5
ProjectInternalID ProjectInternalID 2
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.

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