P_FmavcAcoData

Annual AVC data | view: PFMAVCACODATA | TRAN | Extraction: Not supported | Component: Availability Control
Tables used: FMAVCPFMAVCTFMAVCT_RECON_YR
Column Name Description
rfikrs FK Financial Management Area
rrcty Record Type Show values
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
alloctype_9 Amount Type (Availability Control) Show values
rtcur FK Currency Key
Column Name Description
Amount1 null
Amount0 null
Column Name Description
Column Name Description
Column Name Description
rrcty Record Type Show values
alloctype_9 Amount Type (Availability Control) Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Financial Management Area
  • Client
  • Financial Management Area
  • P_FMAVCACODATA.MANDT == FM01.MANDT
  • P_FMAVCACODATA.RFIKRS == FM01.FIKRS
Grant
  • Client
  • Grant
  • P_FMAVCACODATA.MANDT == GMGR.CLIENT
  • P_FMAVCACODATA.RGRANT_NBR == GMGR.GRANT_NBR
Ledger
  • Client
  • Ledger
  • P_FMAVCACODATA.MANDT == T881.MANDT
  • P_FMAVCACODATA.RLDNR == T881.RLDNR
Currency Key
  • Client
  • Currency Key
  • P_FMAVCACODATA.MANDT == TCURC.MANDT
  • P_FMAVCACODATA.RTCUR == TCURC.WAERS