FMAVCP SAP table for – Plan line items table

Here we would like to draw your attention to FMAVCP table in SAP. As we know it is being mainly used with the SAP PSM-FM (Funds Management in PSM) component which is coming under PSM module (Public Sector Management). FMAVCP is a SAP standard transp table used for storing Plan line items table related data in SAP. It comes under the package FMAVCA_E.

SAP FMAVCP table

Table FMAVCP technical data

TableFMAVCP
Data storingPlan line items table
ModulePSM
Sub ModulePSM-FM-BCS-AC
SAP PackageFMAVCA_E
Delivery ClassA – Application table (master and transaction data)
ComponentEA-PS
Table CategoryTRANSP

SAP FMAVCP Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FMAVCP table.

  • RCLNT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • GL_SIRID : Record number of the line item record
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • RLDNR : Ledger
    Its data type is CHAR (Character String) with field length 2
  • RRCTY : Record Type
    Its data type is CHAR (Character String) with field length 1
  • RVERS : Version
    Its data type is CHAR (Character String) with field length 3
  • RYEAR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • RTCUR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DRCRK : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • RPMAX : Period
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DOCCT : Document Type
    Its data type is CHAR (Character String) with field length 1
  • DOCNR : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • DOCLN : Six-Character Posting Item for Ledger
    Its data type is CHAR (Character String) with field length 6
  • RFIKRS : Financial Management Area
    Its data type is CHAR (Character String) with field length 4
  • RFUND : Fund
    Its data type is CHAR (Character String) with field length 10
  • RFUNDSCTR : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • RCMMTITEM : Commitment item
    Its data type is CHAR (Character String) with field length 24
  • RFUNCAREA : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • RUSERDIM : Customer Field for FM Actual and Commitment Data
    Its data type is CHAR (Character String) with field length 10
  • RGRANT_NBR : Grant
    Its data type is CHAR (Character String) with field length 20
  • RMEASURE : Funded Program
    Its data type is CHAR (Character String) with field length 24
  • RCVRGRP_9 : Cover Group
    Its data type is CHAR (Character String) with field length 16
  • CEFFYEAR_9 : Year of Cash Effectivity
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • WFSTATE_9 : Workflow Status of a Record in the AVC Totals Table
    Its data type is CHAR (Character String) with field length 1
  • ALLOCTYPE_9 : Amount Type (Availability Control)
    Its data type is CHAR (Character String) with field length 4
  • LOGSYS : Logical system
    Its data type is CHAR (Character String) with field length 10
  • TSLVT : Balance carried forward in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL01 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL02 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL03 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL04 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL05 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL06 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL07 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL08 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL09 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL10 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL11 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL12 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL13 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL14 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL15 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL16 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • HSLVT : Balance carried forward in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL01 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL02 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL03 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL04 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL05 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL06 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL07 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL08 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL09 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL10 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL11 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL12 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL13 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL14 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL15 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL16 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • KSLVT : Balance carried forward in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL01 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL02 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL03 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL04 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL05 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL06 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL07 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL08 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL09 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL10 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL11 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL12 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL13 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL14 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL15 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL16 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • DOCTY : FI-SL Document Type
    Its data type is CHAR (Character String) with field length 2
  • ACTIV : Business Transaction
    Its data type is CHAR (Character String) with field length 4
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • WSDAT : Value Date for Currency Translation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • REFDOCNR : Reference document number of an accounting document
    Its data type is CHAR (Character String) with field length 10
  • REFRYEAR : Reference fiscal year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • REFDOCLN : Six-digit number of the reference posting line
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • REFDOCCT : Reference document category
    Its data type is CHAR (Character String) with field length 1
  • REFACTIV : FI-SL Business Reference Transaction
    Its data type is CHAR (Character String) with field length 4
  • CPUDT : Accounting document entry date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CPUTM : Time of data entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • USNAM : User name
    Its data type is CHAR (Character String) with field length 12
  • AWTYP : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWORG : Reference organisational units
    Its data type is CHAR (Character String) with field length 10