FMAVCA

Actual line item table | #transactional | Component: Availability Control
Column Name Description
RCLNT FK Client
GL_SIRID Record number of the line item record
Column Name Description
💲 Currency Key (RTCUR):
TSL Value in Transaction Currency
💲 Currency key of currency 2 (T882.CURR1):
HSL Value in local currency
💲 Currency key of currency 3 (T882.CURR2):
KSL Value in group currency
Column Name Description
Column Name Description
BUDAT Posting Date in the Document
WSDAT Value Date for Currency Translation
CPUDT Day On Which Accounting Document Was Entered
CPUTM Time of Entry
Column Name Description
RRCTY Record Type Show values
DRCRK Debit/Credit Indicator Show values
DOCCT Document Category Show values
WFSTATE_9 Workflow Status of a Record in the AVC Totals Table Show values
ALLOCTYPE_9 Amount Type (Availability Control) Show values
REFDOCCT Reference Document Category Show values
Column Name Description Domain name
RYEAR Fiscal Year GJAHR
POPER Posting period POPER
DOCNR Document Number of an Accounting Document BELNR
DOCLN Six-Character Posting Item for Ledger DOCLN6
RFUND Fund BP_GEBER
RFUNDSCTR Funds Center FISTL
RCMMTITEM Commitment Item FM_FIPEX
RFUNCAREA Functional Area FKBER
RUSERDIM Customer Field for FM Actual and Commitment Data FM_USERDIM
RMEASURE Funded Program FM_MEASURE
RCVRGRP_9 Cover Group FMCE_CVRGRP
BUDGET_PD_9 Budget Period FM_BUDGET_PERIOD
CEFFYEAR_9 Year of Cash Effectivity GJAHR
LOGSYS Logical system LOGSYS
SGTXT Item Text TEXT50
ACTIV Business Transaction CHAR4
REFDOCNR Reference document number of an accounting document BELNR
REFRYEAR Reference fiscal year GJAHR
REFDOCLN Six-Digit Number of the Reference Posting Line BUZEI6
REFACTIV FI-SL Business Reference Transaction CHAR4
USNAM User Name XUBNAME
AWORG Reference Organizational Units AWORG
Master Data Relations Join Conditions
Reference procedure FMAVCA.AWTYP == TTYP.AWTYP
FI-SL Document Type
  • FMAVCA.RCLNT == T889.MANDT
  • FMAVCA.DOCTY == T889.DOCTY
Client FMAVCA.RCLNT == T000.MANDT
Financial Management Area
  • FMAVCA.RCLNT == FM01.MANDT
  • FMAVCA.RFIKRS == FM01.FIKRS
Grant
  • FMAVCA.RCLNT == GMGR.CLIENT
  • FMAVCA.RGRANT_NBR == GMGR.GRANT_NBR
Ledger
  • Ledger
  • Client
  • FMAVCA.RLDNR == T881.RLDNR
  • FMAVCA.RCLNT == T881.MANDT
Currency Key
  • FMAVCA.RCLNT == TCURC.MANDT
  • FMAVCA.RTCUR == TCURC.WAERS
Version
  • Ledger
  • Client
  • Version
  • FMAVCA.RLDNR == T894.RLDNR
  • FMAVCA.RCLNT == T894.MANDT
  • FMAVCA.RVERS == T894.RVERS