P_Trrmoncalc

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 Sales deduction/Surcharge
RecognizableCostAmtInCCCrcy Actual Cost
RecognizableRevenueAmtInCCCrcy Actual Revenue
RevenueAdjustmentAmtInCCCrcy Revenue Adjustment
COGSAdjustmentAmtInCCCrcy COS Adjustment
DeferredCOGSAmtInCCCrcy Deferred COS
DeferredRevenueAmtInCCCrcy Deferred Revenue
AccruedCOGSAmtInCCCrcy Accrued COS
AccruedRevenueAmtInCCCrcy Accrued Revenue
RecognizedCOGSAmtInCCCrcy Recognized COS
RecognizedRevnAmtInCCCrcy Recognized Revenue
RecognizedMarginAmtInCCCrcy Recognized Margin
ImminentLossRsrvAmtInCCCrcy Reserves for Imminent Loss
SalesDeductReserveAmtInCCCrcy Reserves for Anticipated Sales Deductions
UnrlzdCostsReserveAmtInCCCrcy Reserves for Unrealized Costs
MnlContrAccrBalShtAmtInCCCrcy Manual Contract Accruals Balance Sheet
UnbilledRevnInCoCodeCrcy Unbilled Revenue
MnlContrAccrPnLItmAmtInCCCrcy Manual Contract Accruals Income Statement
PlannedCosAmtInCCCrcy Planned COS
PlannedRevenueAmtInCCCrcy Planned Revenue
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
FiscalYear Fiscal Year GJAHR
FiscalPeriod Fiscal Period POPER
ToFiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
ProjectDescription Project Definition Name TEXT40
WBSElementDescription Billing Element Description TEXT40
ProjectManagerName Project Manager Name TEXT25
PostingFiscalPeriod null
CompletionRateInPercent Percentage of Completion FLTP
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_TRRMONCALC.COMPANYCODE == T001.BUKRS
  • P_TRRMONCALC.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_TRRMONCALC.MANDT == TCURC.MANDT
  • P_TRRMONCALC.COMPANYCODECURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Project
  • Project (internal)
  • Client
  • P_TRRMONCALC.PROJECTINTERNALID == PROJ.PSPNR
  • P_TRRMONCALC.MANDT == PROJ.MANDT
Project manager personnel number
  • Client
  • Project Manager
  • P_TRRMONCALC.MANDT == TCJ04.MANDT
  • P_TRRMONCALC.PROJECTMANAGER == TCJ04.VERNR
Results analysis key
  • Client
  • Recognition Key for event-based revenue recognition
  • P_TRRMONCALC.MANDT == TKKAA.MANDT
  • P_TRRMONCALC.RESULTANALYSISINTERNALID == TKKAA.ABGSL