I_EngmntProjActlPlanCube

Column Name Description
Column Name Description
💲 Custom Project Currency (Currency):
ActlRevnInProjCrcy null
ActlCostInProjCrcy null
PlndCostAmtInProjCrcy null
BaselinePlndCostAmt null
RevenueAsSoldAmount null
ActlCostUpToInptPerdAmtInPC null
ActlCostUpToCurPerdAmtInPC null
ActlRevnUpToInptPerdAmtInPC null
ActlRevnUpToCurPerdAmtInPC null
PlnCostUpToCurPerdAmtInPC null
PlnCostUpToPrevPerdAmtInPC null
BslnCostUpToCurPerdAmtInPC null
BslnCostUpToPrevPerdAmtInPC null
Column Name Description
📏 Unit of Measure (UnitOfMeasure):
ActlEffortQty null
PlndEffortQty null
BaselinePlndEffortQty null
PlndEffortUpToCurPerd null
PlnEffortUpToPrevPerdQty null
BslnEffortUpToCurPerdQty null
BslnEffortUpToPrevPerdQty null
ActlEffortUpToInptPerdQty null
ActlEffortQtyUpToCurPerd null
ActlEffortUpToPrevPerdQty null
DiffBtwnPlnAndActlEffortQty null
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
EngagementProject Engagement Project ID /CPD/MP_ID
Ledger Ledger FINS_LEDGER
FiscalPeriod Fiscal Period
FiscalYear Fiscal Year
SalesOrder Sales Order VBELN
SalesOrderItem Sales Order Item POSNR
EngagementProjectServiceOrg Service Organization /CPD/PWS_WS_ORG_UNIT_ID
EngagementProjectResourceType Resource Type ID /CPD/PFP_RES_TYPE_ID
BillingControlCategory null
ProjectManagerName null
ProfitCenter Profit Center PRCTR
CostCenter Organization Unit Key /CPD/PWS_WS_ORG_UNIT_KEY
FiscalYearPeriod null
IsMyProject null
ProjectVisibility Confidential Indicator for Commercial Project
Master Data Relations Join Conditions
Company code
  • Client
  • Company code for the project
  • I_ENGMNTPROJACTLPLANCUBE.MANDT == T001.MANDT
  • I_ENGMNTPROJACTLPLANCUBE.COMPANYCODE == T001.BUKRS
Controlling area
  • Client
  • Controlling area for the project
  • I_ENGMNTPROJACTLPLANCUBE.MANDT == TKA01.MANDT
  • I_ENGMNTPROJACTLPLANCUBE.CONTROLLINGAREA == TKA01.KOKRS
Country/Region Key
  • Country/Region Key
  • Client
  • I_ENGMNTPROJACTLPLANCUBE.COUNTRY == T005.LAND1
  • I_ENGMNTPROJACTLPLANCUBE.MANDT == T005.MANDT
Profile ID for project structure
  • Project Profile
  • Client
  • I_ENGMNTPROJACTLPLANCUBE.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
  • I_ENGMNTPROJACTLPLANCUBE.MANDT == TCJ41.MANDT
Sales document item category
  • Sales document item category
  • Client
  • I_ENGMNTPROJACTLPLANCUBE.SALESORDERITEMCATEGORY == TVPT.PSTYV
  • I_ENGMNTPROJACTLPLANCUBE.MANDT == TVPT.MANDT