P_EngmntProjActlByPeriod

Engagement Project Actuals aggregated by Fiscal Year Period | view: PEPACTLBYPERIOD | Extraction: Not supported | Component: S/4HANA Professional Services Cloud - CPM
Column Name Description
Column Name Description
ActlCostAmtInCoCodeCrcy null
ActlCostAmt null
AmountInObjectCurrency null
AmountInGlobalCurrency null
AmountInTransactionCurrency null
AmountInCompanyCodeCurrency null
Column Name Description
ActlEffortQty null
Column Name Description
Column Name Description
EngagementProjectCategory Project Type Show values
ControllingObjectDebitType Controlling Object Debit Type Show values
ProjectVisibility Confidential Indicator for Commercial Project Show values
Column Name Description Domain name
EngagementProject Engagement Project ID /CPD/MP_ID
EngagementProjectServiceOrg Service Organization /CPD/PWS_WS_ORG_UNIT_ID
Customer Customer Number KUNNR
EngagementProjectType Engagement Project Type /CPD/PWS_WS_MP_TYPE
EngmntProjReviewYearPeriod Review Year Period /CPD/FISCAL_YEAR_PERIOD
EngagementProjectReviewStatus Forecast Status ID /CPD/PFP_FORECAST_ST_ID
EngagementProjectStage Commercial Project: Stage /CPD/PWS_WS_MP_STG
CurrentYearPeriod Current Year Period /CPD/SS_CURRENT_YEAR_PERIOD
EngagementProjFinPlanUUID Financial Plan UUID /BOBF/CONF_KEY
PlanVersion Plan Version ID /CPD/PFP_VERSION_ID
FiscalYear Fiscal Year GJAHR
FiscalPeriod Period PERBL
FiscalYearPeriod Review Year Period /CPD/FISCAL_YEAR_PERIOD
WorkPackage Plan Item /CPD/PLAN_ITEM_ID
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
WBSElement WBS Element FIS_WBS_NO_CONV
SalesOrderItem Sales Order Item POSNR
CompanyCode Partner Company Code BUKRS
CostCenter Partner Cost Center KOSTL
PartnerCostCtrActivityType Product Number MATNR
IsMyProject null
ProjectManagerExternalID null
ProjectAccountantExternalID null
ProjectControllerExternalID null
ProjectPartnerExternalID null
ProjectManager null
ProjectAccountant null
ProjectController null
Projectpartner null
ProjectManagerName null
ProjectAccountantName null
ProjectControllerName null
ProjectPartnerName null
ProjectProfileCode Project Profile PROFIDPROJ
EngmntProjectHeaderCompanyCode Company code for the project BUKRS
EngagementProjectCostCenter Organization Unit Key /CPD/PWS_WS_ORG_UNIT_KEY
ProfitCenter Profit Center PRCTR
Master Data Relations Join Conditions
Business Transaction Type
  • Business Transaction Type
  • Client
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_ENGMNTPROJACTLBYPERIOD.CHARTOFACCOUNTS == T004.KTOPL
  • P_ENGMNTPROJACTLBYPERIOD.MANDT == T004.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • P_ENGMNTPROJACTLBYPERIOD.COMPANYCODECURRENCY == TCURC.WAERS
  • P_ENGMNTPROJACTLBYPERIOD.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_ENGMNTPROJACTLBYPERIOD.CONTROLLINGAREA == TKA01.KOKRS
  • P_ENGMNTPROJACTLBYPERIOD.MANDT == TKA01.MANDT
CO Object Currency
  • Client
  • CO Object Currency
  • P_ENGMNTPROJACTLBYPERIOD.MANDT == TCURC.MANDT
  • P_ENGMNTPROJACTLBYPERIOD.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
Plan Currency
  • Client
  • Plan Currency
  • P_ENGMNTPROJACTLBYPERIOD.MANDT == TCURC.MANDT
  • P_ENGMNTPROJACTLBYPERIOD.CURRENCY == TCURC.WAERS
G/L Account
  • G/L Account
  • ?
  • Client
  • P_ENGMNTPROJACTLBYPERIOD.GLACCOUNT == SKB1.SAKNR
  • P_ENGMNTPROJACTLBYPERIOD.[column in domain "BUKRS"] == SKB1.BUKRS
  • P_ENGMNTPROJACTLBYPERIOD.MANDT == SKB1.MANDT
Global Currency
  • Client
  • Global Currency
  • P_ENGMNTPROJACTLBYPERIOD.MANDT == TCURC.MANDT
  • P_ENGMNTPROJACTLBYPERIOD.GLOBALCURRENCY == TCURC.WAERS
Ledger
  • Client
  • Ledger
Product Number
  • Product Number
  • Client
  • P_ENGMNTPROJACTLBYPERIOD.MATERIAL == MARA.MATNR
  • P_ENGMNTPROJACTLBYPERIOD.MANDT == MARA.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • P_ENGMNTPROJACTLBYPERIOD.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_ENGMNTPROJACTLBYPERIOD.MANDT == TCURC.MANDT