I_EngmntProjStaffingAnlysCube

Staffing Info for Engmnt Project - Cube | view: IEPSTAFANLYSCUBE | TRAN | Extraction: Not supported | Component: S/4HANA Professional Services Cloud - CPM
Column Name Description
Column Name Description
Column Name Description
📏 Unit of Measure (UnitOfMeasure):
PlndEffortQty Total Quantity
PlndEffortUpToCurPerd Total Quantity
EngmntProjStaffedEffort Total Quantity
StaffedEffortUpToCurPerdQty Total Quantity
ActlEffortQty null
TotalRecordedHours null
TotalApprovedHours null
TotRecHrsSentForApproval null
Column Name Description
ProjectStartDate Commercial Project: Start Date
ProjectEndDate Commercial Project: End Date
Column Name Description
EngagementProjectCategory Project Type Show values
ProjectVisibility Confidential Indicator for Commercial Project Show values
Column Name Description Domain name
EngagementProject Engagement Project ID
FiscalYearPeriod null
EngagementProjectResource Resource ID
BillingControlCategory null
FiscalPeriod Period PERBL
FiscalYear Fiscal Year GJAHR
EngagementProjectServiceOrg Service Organization /CPD/PWS_WS_ORG_UNIT_ID
ProfitCenter Profit Center PRCTR
CostCenter Organization Unit Key
ProjectManager null
ProjectManagerExternalID null
ProjectManagerName null
EngagementProjectResourceType Resource Type ID
BillingControlCategoryText Short Text for Fixed Values
IsMyProject null
Master Data Relations Join Conditions
Company code
  • Client
  • Company code for the project
  • I_ENGMNTPROJSTAFFINGANLYSCUBE.MANDT == T001.MANDT
  • I_ENGMNTPROJSTAFFINGANLYSCUBE.COMPANYCODE == T001.BUKRS
Controlling area
  • Client
  • Controlling area for the project
  • I_ENGMNTPROJSTAFFINGANLYSCUBE.MANDT == TKA01.MANDT
  • I_ENGMNTPROJSTAFFINGANLYSCUBE.CONTROLLINGAREA == TKA01.KOKRS
Profile ID for project structure
  • Client
  • Project Profile
  • I_ENGMNTPROJSTAFFINGANLYSCUBE.MANDT == TCJ41.MANDT
  • I_ENGMNTPROJSTAFFINGANLYSCUBE.PROJECTPROFILECODE == TCJ41.PROFIDPROJ