I_EngmntProjSalesMarginCube

Column Name Description
EngagementProject Project
SalesOrder Sales Order
SalesOrderItem Sales Order Item
EngmtProjEmployeeIsStaffed Confirmation of staffed Employee Show values
UnitOfMeasure Unit of Measure
BaseUnit Base Unit of Measure
PersonnelNumber Personnel Number
FiscalPeriod Period
FiscalYear Fiscal Year
EngmntProjPlanLineType Line type Show values
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
📏 Base Unit of Measure (BaseUnit):
ActlEffortQty null
BilledEffort null
📏 Unit of Measure (UnitOfMeasure):
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
EngagementProjectResourceType Resource Type ID /CPD/PFP_RES_TYPE_ID
EngagementProjectServiceOrg Service Organization /CPD/PWS_WS_ORG_UNIT_ID
ProfitCenter Profit Center PRCTR
AccountingDocumentStatus null
FiscalYearPeriod Review Year Period
ProjectVisibility Confidential Indicator for Commercial Project
IsMyProject null
Master Data Relations Join Conditions
Company code
  • Client
  • Company code for the project
  • I_ENGMNTPROJSALESMARGINCUBE.MANDT == T001.MANDT
  • I_ENGMNTPROJSALESMARGINCUBE.COMPANYCODE == T001.BUKRS
Controlling area
  • Client
  • Controlling area for the project
  • I_ENGMNTPROJSALESMARGINCUBE.MANDT == TKA01.MANDT
  • I_ENGMNTPROJSALESMARGINCUBE.CONTROLLINGAREA == TKA01.KOKRS
Controlling Area Currency
  • Client
  • Controlling Area Currency
  • I_ENGMNTPROJSALESMARGINCUBE.MANDT == TCURC.MANDT
  • I_ENGMNTPROJSALESMARGINCUBE.CONTROLLINGAREACURRENCY == TCURC.WAERS
Country/Region Key
  • Country/Region Key
  • Client
  • I_ENGMNTPROJSALESMARGINCUBE.COUNTRY == T005.LAND1
  • I_ENGMNTPROJSALESMARGINCUBE.MANDT == T005.MANDT
Profile ID for project structure
  • Client
  • Project Profile
  • I_ENGMNTPROJSALESMARGINCUBE.MANDT == TCJ41.MANDT
  • I_ENGMNTPROJSALESMARGINCUBE.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
Sales document item category
  • Sales document item category
  • Client
  • I_ENGMNTPROJSALESMARGINCUBE.SALESORDERITEMCATEGORY == TVPT.PSTYV
  • I_ENGMNTPROJSALESMARGINCUBE.MANDT == TVPT.MANDT