I_EngmntProjSalesPlanData

Column Name Description
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
PlndEffortQty null
📏 Base Unit of Measure (BaseUnit):
BilledEffort null
Column Name Description
ProjectStartDate Commercial Project: Start Date
ProjectEndDate Commercial Project: End Date
Column Name Description
EngagementProjectCategory Project Type Show values
EngmtProjEmployeeIsStaffed Confirmation of staffed Employee Show values
EngmntProjPlanLineType Line type Show values
Column Name Description Domain name
EngagementProject Project /CPD/MP_ID
EngagementProjectServiceOrg Service Organization /CPD/PWS_WS_ORG_UNIT_ID
SalesOrder Sales Order VBELN
SalesOrderItem Sales Order Item POSNR
ProfitCenter Profit Center PRCTR
EngmtProjFinPlanVersion Plan Version ID /CPD/PFP_VERSION_ID
AccountingDocumentStatus null
FiscalPeriod Period
FiscalYear Fiscal Year
FiscalYearPeriod Review Year Period
PersonnelNumber Personnel Number PERNR
EngagementProjectResourceType Resource Type ID /CPD/PFP_RES_TYPE_ID
IsMyProject null
Master Data Relations Join Conditions
Company code
  • Client
  • Company code for the project
  • I_ENGMNTPROJSALESPLANDATA.MANDT == T001.MANDT
  • I_ENGMNTPROJSALESPLANDATA.COMPANYCODE == T001.BUKRS
Controlling area
  • Controlling area for the project
  • Client
  • I_ENGMNTPROJSALESPLANDATA.CONTROLLINGAREA == TKA01.KOKRS
  • I_ENGMNTPROJSALESPLANDATA.MANDT == TKA01.MANDT
Controlling Area Currency
  • Controlling Area Currency
  • Client
  • I_ENGMNTPROJSALESPLANDATA.CONTROLLINGAREACURRENCY == TCURC.WAERS
  • I_ENGMNTPROJSALESPLANDATA.MANDT == TCURC.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • I_ENGMNTPROJSALESPLANDATA.COUNTRY == T005.LAND1
  • I_ENGMNTPROJSALESPLANDATA.MANDT == T005.MANDT
Plan Currency
  • Plan Currency
  • Client
  • I_ENGMNTPROJSALESPLANDATA.CURRENCY == TCURC.WAERS
  • I_ENGMNTPROJSALESPLANDATA.MANDT == TCURC.MANDT
Sales document item category
  • Sales document item category
  • Client
  • I_ENGMNTPROJSALESPLANDATA.SALESORDERITEMCATEGORY == TVPT.PSTYV
  • I_ENGMNTPROJSALESPLANDATA.MANDT == TVPT.MANDT