P_ENGMNTPROJACTCOSTANDREVN

CDS View
21 Fields 3 CDS Views

Engagement Project Actual Cost Revenue

P_ENGMNTPROJACTCOSTANDREVN is a CDS View in S/4HANA. Engagement Project Actual Cost Revenue. It contains 21 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_EngagementProjPlanActualCost view inner COMPOSITE Engagement Project Plan and Actual Cost
P_EngmntProjWrkPckgActl view from COMPOSITE Engagement Project Work Package Actual
P_EngmtProjSalesActualByPerd view from COMPOSITE Engagement Project Actual Sales By Period

Fields (21)

KeyField CDS FieldsUsed in Views
AccountingDocumentStatus AccountingDocumentStatus 1
ActlCostAmtInPlanCrcy ActlCostAmt 1
ActlEffortQty ActlEffortQty 1
CompanyCodeCurrency CompanyCodeCurrency 1
Confirmed Confirmed 1
Currency Currency 1
EngagementProject EngagementProject 1
EngagementProjectCategory EngagementProjectCategory 1
EngagementProjectResource EngagementProjectResource 1
EngagementProjectResourceType EngagementProjectResourceType 2
EngagementProjFinPlanUUID EngagementProjFinPlanUUID 1
FiscalPeriod FiscalPeriod 2
FiscalYear FiscalYear 2
IsMyProject IsMyProject 1
PersonnelNumber PersonnelNumber 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
TotalQuantity ActlEffortQty 1
Unit BaseUnit,UnitOfMeasure 2
WorkItem WorkItem 2
WorkPackage WorkPackage 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.

-- Engagement Project Actual Cost Revenue
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_ENGMNTPROJACTCOSTANDREVN (
    ACCOUNTINGDOCUMENTSTATUS,
    ACTLCOSTAMTINPLANCRCY,
    ACTLEFFORTQTY,
    COMPANYCODECURRENCY,
    CONFIRMED,
    CURRENCY,
    ENGAGEMENTPROJECT,
    ENGAGEMENTPROJECTCATEGORY,
    ENGAGEMENTPROJECTRESOURCE,
    ENGAGEMENTPROJECTRESOURCETYPE,
    ENGAGEMENTPROJFINPLANUUID,
    FISCALPERIOD,
    FISCALYEAR,
    ISMYPROJECT,
    PERSONNELNUMBER,
    SALESORDER,
    SALESORDERITEM,
    TOTALQUANTITY,
    UNIT,
    WORKITEM,
    WORKPACKAGE
);

Learn More