I_EngmntProjCommlAnlysCube

Column Name Description
EngagementProject Project
SalesOrder Sales Order
SalesOrderItem Sales Order Item
FiscalPeriod Period
FiscalYear Fiscal Year
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
PlndRevnInCoCodeCrcy null
ActlRevnInCoCodeCrcy null
UnbilledRevnInCoCodeCrcy null
DebtInCoCodeCrcy null
Column Name Description
Column Name Description
ProjectStartDate Commercial Project: Start Date
ProjectEndDate Commercial Project: End Date
Column Name Description
EngagementProjectCategory Project Type Show values
Column Name Description Domain name
EngagementProjectServiceOrg Service Organization /CPD/PWS_WS_ORG_UNIT_ID
ProfitCenter Profit Center PRCTR
FiscalYearPeriod Review Year Period /CPD/FISCAL_YEAR_PERIOD
Master Data Relations Join Conditions
Company code
  • Client
  • Company code for the project
  • I_ENGMNTPROJCOMMLANLYSCUBE.MANDT == T001.MANDT
  • I_ENGMNTPROJCOMMLANLYSCUBE.COMPANYCODE == T001.BUKRS
Controlling area
  • Client
  • Controlling area for the project
  • I_ENGMNTPROJCOMMLANLYSCUBE.MANDT == TKA01.MANDT
  • I_ENGMNTPROJCOMMLANLYSCUBE.CONTROLLINGAREA == TKA01.KOKRS
Country/Region Key
  • Country/Region Key
  • Client
  • I_ENGMNTPROJCOMMLANLYSCUBE.COUNTRY == T005.LAND1
  • I_ENGMNTPROJCOMMLANLYSCUBE.MANDT == T005.MANDT