I_EngmntProjSlsPlanDataAggrgn

DDL: I_ENGMNTPROJSLSPLANDATAAGGRGN SQL: IEPRSLSPLDATAGG Type: view COMPOSITE
54 Fields 1 Data Sources

Engagement Project Sales and Actual Plan Data Aggregation

I_EngmntProjSlsPlanDataAggrgn is a Composite CDS View (Fact) that provides data about "Engagement Project Sales and Actual Plan Data Aggregation" in SAP S/4HANA. It reads from 1 data source (I_EngmntProjSalesPlanData) and exposes 54 fields with key fields EngagementProject, SalesOrder, SalesOrderItem, EngmtProjEmployeeIsStaffed, EngmtProjFinPlanVersion.

Data Sources (1)

SourceAliasJoin Type
I_EngmntProjSalesPlanData I_EngmntProjSalesPlanData from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IEPRSLSPLDATAGG view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
Analytics.dataCategory #FACT view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Engagement Project Sales and Actual Plan Data Aggregation view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY EngagementProject EngagementProject Engmnt Project ID
KEY SalesOrder SalesOrder SD Document
KEY SalesOrderItem SalesOrderItem Sales Order Item
KEY EngmtProjEmployeeIsStaffed EngmtProjEmployeeIsStaffed Confirmation of staffed Employee
KEY EngmtProjFinPlanVersion EngmtProjFinPlanVersion Plan Version ID
KEY UnitOfMeasure UnitOfMeasure Unit Protected Qty
KEY PersonnelNumber PersonnelNumber Personnel No.
KEY FiscalPeriod FiscalPeriod Tax period
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY EngmntProjPlanLineType EngmntProjPlanLineType Line type
KEY BaseUnit BaseUnit Unit of Measure
ProjectStartDate ProjectStartDate Latest Planned Start
ProjectEndDate ProjectEndDate Ltst Planned Finish
Customer Customer Sold-to Party
EngagementProjectType EngagementProjectType
EngagementProjectStage EngagementProjectStage
EngagementProjectServiceOrg EngagementProjectServiceOrg Service Org.
EngagementProjectCategory EngagementProjectCategory
CompanyCode CompanyCode Receiver Company Code
Country Country Venue: Ctry/Reg
SalesOrderItemCategory SalesOrderItemCategory Item Category
ControllingArea ControllingArea Controlling Area
EngagementProjectResourceType EngagementProjectResourceType ResourceTypeID
ControllingAreaCurrency ControllingAreaCurrency
ProfitCenter ProfitCenter Profit Center
AccountingDocumentStatus AccountingDocumentStatus
FiscalYearPeriod FiscalYearPeriod Period/Year
Currency Currency Valuation Crcy
CompanyCodeCurrency CompanyCodeCurrency Local Currency
ActlEffortQty
BilledEffort
PlndEffortQty
PlndCostInCoCodeCrcy
PlndRevnInCoCodeCrcy
ActlRevnInCoCodeCrcy
ActlCostInCoCodeCrcy
PlndCostAmtInCtrlgAreaCrcy
PlndRevenueAmtInCtrlgAreaCrcy
ActlRevenueAmtInCtrlgAreaCrcy
IsMyProject IsMyProject
_BaseUnit _BaseUnit
_CompanyCode _CompanyCode
_CompanyCodeCurrency _CompanyCodeCurrency
_ControllingArea _ControllingArea
_Country _Country
_Customer _Customer
_EngagementProject _EngagementProject
_EngagementProjectSrvcOrg _EngagementProjectSrvcOrg
_EngagementProjectStage _EngagementProjectStage
_ItemCategory _ItemCategory
_ProfitCenter _ProfitCenter
_SalesOrder _SalesOrder
_SalesOrderItem _SalesOrderItem
_UnitOfMeasure _UnitOfMeasure

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_EngmntProjSlsPlanDataAggrgn.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IEPRSLSPLDATAGG

CREATE VIEW I_EngmntProjSlsPlanDataAggrgn AS
SELECT
  EngagementProject,
  SalesOrder,
  SalesOrderItem,
  EngmtProjEmployeeIsStaffed,
  EngmtProjFinPlanVersion,
  UnitOfMeasure,
  PersonnelNumber,
  FiscalPeriod,
  FiscalYear,
  EngmntProjPlanLineType,
  BaseUnit,
  ProjectStartDate,
  ProjectEndDate,
  Customer,
  EngagementProjectType,
  EngagementProjectStage,
  EngagementProjectServiceOrg,
  EngagementProjectCategory,
  CompanyCode,
  Country,
  SalesOrderItemCategory,
  ControllingArea,
  EngagementProjectResourceType,
  ControllingAreaCurrency,
  ProfitCenter,
  AccountingDocumentStatus,
  FiscalYearPeriod,
  Currency,
  CompanyCodeCurrency,
  sum( ActlEffortQty ) AS ActlEffortQty,
  sum( BilledEffort ) AS BilledEffort,
  sum( PlndEffortQty ) AS PlndEffortQty,
  sum( PlndCostInCoCodeCrcy ) AS PlndCostInCoCodeCrcy,
  sum( PlndRevnInCoCodeCrcy ) AS PlndRevnInCoCodeCrcy,
  sum( ActlRevnInCoCodeCrcy ) AS ActlRevnInCoCodeCrcy,
  sum( ActlCostInCoCodeCrcy ) AS ActlCostInCoCodeCrcy,
  sum( PlndCostAmtInCtrlgAreaCrcy ) AS PlndCostAmtInCtrlgAreaCrcy,
  sum( PlndRevenueAmtInCtrlgAreaCrcy ) AS PlndRevenueAmtInCtrlgAreaCrcy,
  sum( ActlRevenueAmtInCtrlgAreaCrcy ) AS ActlRevenueAmtInCtrlgAreaCrcy,
  IsMyProject
FROM I_EngmntProjSalesPlanData
;

Learn More