I_EngmntProjSlsPlanDataAggrgn

Engagement Project Sales and Actual Plan Data Aggregation | view: IEPRSLSPLDATAGG | TRAN | Extraction: Not supported | Component: S/4HANA Professional Services Cloud - CPM
Column Name Description
EngagementProject Project
SalesOrder Sales Order
SalesOrderItem Sales Order Item
EngmtProjEmployeeIsStaffed Confirmation of staffed Employee Show values
EngmtProjFinPlanVersion Plan Version ID
UnitOfMeasure Unit of Measure
PersonnelNumber Personnel Number
FiscalPeriod Period
FiscalYear Fiscal Year
EngmntProjPlanLineType Line type Show values
BaseUnit Base Unit of Measure
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
PlndCostInCoCodeCrcy null
PlndRevnInCoCodeCrcy null
ActlRevnInCoCodeCrcy null
ActlCostInCoCodeCrcy null
💲 Controlling Area Currency (ControllingAreaCurrency):
PlndCostAmtInCtrlgAreaCrcy null
PlndRevenueAmtInCtrlgAreaCrcy null
ActlRevenueAmtInCtrlgAreaCrcy null
Column Name Description
📏 Unit of Measure (UnitOfMeasure):
ActlEffortQty null
BilledEffort null
PlndEffortQty null
Column Name Description
ProjectStartDate Commercial Project: Start Date
ProjectEndDate Commercial Project: End Date
Column Name Description
EngmtProjEmployeeIsStaffed Confirmation of staffed Employee Show values
EngmntProjPlanLineType Line type Show values
EngagementProjectCategory Project Type Show values
Column Name Description Domain name
EngagementProjectServiceOrg Service Organization /CPD/PWS_WS_ORG_UNIT_ID
EngagementProjectResourceType Resource Type ID /CPD/PFP_RES_TYPE_ID
ProfitCenter Profit Center PRCTR
AccountingDocumentStatus null
FiscalYearPeriod Review Year Period /CPD/FISCAL_YEAR_PERIOD
IsMyProject null
Master Data Relations Join Conditions
Company code
  • Client
  • Company code for the project
  • I_ENGMNTPROJSLSPLANDATAAGGRGN.MANDT == T001.MANDT
  • I_ENGMNTPROJSLSPLANDATAAGGRGN.COMPANYCODE == T001.BUKRS
Controlling area
  • Client
  • Controlling area for the project
  • I_ENGMNTPROJSLSPLANDATAAGGRGN.MANDT == TKA01.MANDT
  • I_ENGMNTPROJSLSPLANDATAAGGRGN.CONTROLLINGAREA == TKA01.KOKRS
Controlling Area Currency
  • Client
  • Controlling Area Currency
  • I_ENGMNTPROJSLSPLANDATAAGGRGN.MANDT == TCURC.MANDT
  • I_ENGMNTPROJSLSPLANDATAAGGRGN.CONTROLLINGAREACURRENCY == TCURC.WAERS
Country/Region Key
  • Client
  • Country/Region Key
  • I_ENGMNTPROJSLSPLANDATAAGGRGN.MANDT == T005.MANDT
  • I_ENGMNTPROJSLSPLANDATAAGGRGN.COUNTRY == T005.LAND1
Sales document item category
  • Client
  • Sales document item category
  • I_ENGMNTPROJSLSPLANDATAAGGRGN.MANDT == TVPT.MANDT
  • I_ENGMNTPROJSLSPLANDATAAGGRGN.SALESORDERITEMCATEGORY == TVPT.PSTYV