P_FmavcAcoDataAgg

Annual AVC data, aggregated | view: PFMAVCACODATAAGG | TRAN | Extraction: Not supported | Component: Availability Control
Tables used: FMAVCPFMAVCTFMAVCT_RECON_YR
Column Name Description
rfikrs FK Financial Management Area
rldnr FK Ledger
ryear Fiscal Year
ceffyear_9 Year of Cash Effectivity
rcvrgrp_9 Cover Group
rgrant_nbr FK Grant
rfund Fund
budget_pd_9 Budget Period
rfundsctr Funds Center
rcmmtitem Commitment Item
rfuncarea Functional Area
rmeasure Funded Program
ruserdim Customer Field for FM Actual and Commitment Data
rtcur FK Currency Key
Column Name Description
ConsumableAmount null
ConsumedAmount null
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
Financial Management Area
  • Financial Management Area
  • Client
  • P_FMAVCACODATAAGG.RFIKRS == FM01.FIKRS
  • P_FMAVCACODATAAGG.MANDT == FM01.MANDT
Grant
  • Grant
  • Client
  • P_FMAVCACODATAAGG.RGRANT_NBR == GMGR.GRANT_NBR
  • P_FMAVCACODATAAGG.MANDT == GMGR.CLIENT
Ledger
  • Client
  • Ledger
  • P_FMAVCACODATAAGG.MANDT == T881.MANDT
  • P_FMAVCACODATAAGG.RLDNR == T881.RLDNR
Currency Key
  • Client
  • Currency Key
  • P_FMAVCACODATAAGG.MANDT == TCURC.MANDT
  • P_FMAVCACODATAAGG.RTCUR == TCURC.WAERS