P_TRRMONSUMPLAN

Column Name Description
ProjectInternalID FK Project (internal)
WBSElementInternalID WBS Element Internal ID no conversion
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
Column Name Description
ActlSlsDeductionAmtInCCCrcy null
RecognizableCostAmtInCCCrcy null
RecognizableRevenueAmtInCCCrcy null
RevenueAdjustmentAmtInCCCrcy null
COGSAdjustmentAmtInCCCrcy null
DeferredCOGSAmtInCCCrcy null
DeferredRevenueAmtInCCCrcy null
AccruedRevenueAmtInCCCrcy null
AccruedCOGSAmtInCCCrcy null
ImminentLossRsrvAmtInCCCrcy null
SalesDeductReserveAmtInCCCrcy null
UnrlzdCostsReserveAmtInCCCrcy null
PlannedCosAmtInCCCrcy null
PlannedRevenueAmtInCCCrcy null
RecognizedCOGSAmtInCCCrcy null
RecognizedRevnAmtInCCCrcy null
RecognizedMarginAmtInCCCrcy null
UnbilledRevnInCoCodeCrcy null
MnlContrAccrPnLItmAmtInCCCrcy null
MnlContrAccrBalShtAmtInCCCrcy null
Column Name Description
Column Name Description
PostingDate null
Column Name Description
Column Name Description Domain name
ProjectExternalID Project Number (External) Edited PS_PSPID_EDIT
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
FiscalPeriod Fiscal Period POPER
FiscalYear Fiscal Year GJAHR
ToFiscalYearPeriod null
ProjectManagerName Project Manager Name TEXT25
ProjectDescription Project Definition Name TEXT40
WBSElementDescription Billing Element Description TEXT40
PostingFiscalPeriod null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_TRRMONSUMPLAN.COMPANYCODE == T001.BUKRS
  • P_TRRMONSUMPLAN.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_TRRMONSUMPLAN.MANDT == TCURC.MANDT
  • P_TRRMONSUMPLAN.COMPANYCODECURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Project
  • Client
  • Project (internal)
  • P_TRRMONSUMPLAN.MANDT == PROJ.MANDT
  • P_TRRMONSUMPLAN.PROJECTINTERNALID == PROJ.PSPNR
Project manager personnel number
  • Client
  • Project Manager
  • P_TRRMONSUMPLAN.MANDT == TCJ04.MANDT
  • P_TRRMONSUMPLAN.PROJECTMANAGER == TCJ04.VERNR
Results analysis key
  • Client
  • Recognition Key for event-based revenue recognition
  • P_TRRMONSUMPLAN.MANDT == TKKAA.MANDT
  • P_TRRMONSUMPLAN.RESULTANALYSISINTERNALID == TKKAA.ABGSL