P_ENGMNTPROJSALESPLANDATA

Column Name Description
Column Name Description
PlndCostInCoCodeCrcy null
PlndRevnInCoCodeCrcy null
ActlRevnInCoCodeCrcy null
ActlCostInCoCodeCrcy null
PlndCostAmtInCtrlgAreaCrcy null
PlndRevenueAmtInCtrlgAreaCrcy null
ActlRevenueAmtInCtrlgAreaCrcy null
Column Name Description
ActlEffortQty null
BilledEffort null
PlndEffortQty 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 PERBL
FiscalYear Fiscal Year GJAHR
FiscalYearPeriod Review Year Period /CPD/FISCAL_YEAR_PERIOD
PersonnelNumber Personnel Number PERNR
EngagementProjectResourceType Resource Type ID /CPD/PFP_RES_TYPE_ID
IsMyProject null
Master Data Relations Join Conditions
Company code
  • Company code for the project
  • Client
  • P_ENGMNTPROJSALESPLANDATA.COMPANYCODE == T001.BUKRS
  • P_ENGMNTPROJSALESPLANDATA.MANDT == T001.MANDT
Controlling area
  • Controlling area for the project
  • Client
  • P_ENGMNTPROJSALESPLANDATA.CONTROLLINGAREA == TKA01.KOKRS
  • P_ENGMNTPROJSALESPLANDATA.MANDT == TKA01.MANDT
Controlling Area Currency
  • Client
  • Controlling Area Currency
  • P_ENGMNTPROJSALESPLANDATA.MANDT == TCURC.MANDT
  • P_ENGMNTPROJSALESPLANDATA.CONTROLLINGAREACURRENCY == TCURC.WAERS
Country/Region Key
  • Country/Region Key
  • Client
  • P_ENGMNTPROJSALESPLANDATA.COUNTRY == T005.LAND1
  • P_ENGMNTPROJSALESPLANDATA.MANDT == T005.MANDT
Plan Currency
  • Plan Currency
  • Client
  • P_ENGMNTPROJSALESPLANDATA.CURRENCY == TCURC.WAERS
  • P_ENGMNTPROJSALESPLANDATA.MANDT == TCURC.MANDT
Sales document item category
  • Sales document item category
  • Client
  • P_ENGMNTPROJSALESPLANDATA.SALESORDERITEMCATEGORY == TVPT.PSTYV
  • P_ENGMNTPROJSALESPLANDATA.MANDT == TVPT.MANDT