I_Trrmonitor

Column Name Description
ProjectInternalID FK Project (internal)
WBSElementInternalID WBS Element Internal ID no conversion
Ledger FK Ledger in General Ledger Accounting
CompanyCode Company Code
Column Name Description
ActlSlsDeductionAmtInCCCrcy Sales deduction/Surcharge
RecognizedCOGSAmtInCCCrcy Recognized COS
RecognizedRevnAmtInCCCrcy Recognized Revenue
RecognizedMarginAmtInCCCrcy Recognized Margin
RecognizableCostAmtInCCCrcy Actual Cost
RecognizableRevenueAmtInCCCrcy Actual Revenue
RevenueAdjustmentAmtInCCCrcy Revenue Adjustment
COGSAdjustmentAmtInCCCrcy COS Adjustment
DeferredCOGSAmtInCCCrcy Deferred COS
DeferredRevenueAmtInCCCrcy Deferred Revenue
AccruedCOGSAmtInCCCrcy Accrued COS
AccruedRevenueAmtInCCCrcy Accrued Revenue
ImminentLossRsrvAmtInCCCrcy Reserves for Imminent Loss
SalesDeductReserveAmtInCCCrcy Reserves for Anticipated Sales Deductions
UnrlzdCostsReserveAmtInCCCrcy Reserves for Unrealized Costs
PlannedCosAmtInCCCrcy Planned COS
PlannedRevenueAmtInCCCrcy Planned Revenue
UnbilledRevnInCoCodeCrcy Unbilled Revenue
MnlContrAccrPnLItmAmtInCCCrcy Manual Contract Accruals Income Statement
MnlContrAccrBalShtAmtInCCCrcy Manual Contract Accruals Balance Sheet
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 Fiscal Year Period FIS_JAHRPER_CONV
CompanyCodeName Name of Company Code or Company TEXT25
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
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Project
  • Client
  • Project (internal)
  • I_TRRMONITOR.MANDT == PROJ.MANDT
  • I_TRRMONITOR.PROJECTINTERNALID == PROJ.PSPNR
Project manager personnel number
  • Client
  • Project Manager
  • I_TRRMONITOR.MANDT == TCJ04.MANDT
  • I_TRRMONITOR.PROJECTMANAGER == TCJ04.VERNR
Results analysis key
  • Recognition Key for event-based revenue recognition
  • Client
  • I_TRRMONITOR.RESULTANALYSISINTERNALID == TKKAA.ABGSL
  • I_TRRMONITOR.MANDT == TKKAA.MANDT