The FMAVCT table in SAP ERP or S/4HANA stores BCS AVC Summary Table (only conditional update!) data. There are total 77 fields in FMAVCT table. The BCS AVC Summary Table (only conditional update!) table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of FMAVCT table. It is in Active availability control: FM application part (FMAVCA_E) ABAP package and is part of the Availability Control (PSM-FM-BCS-AC) module.
SAP FMAVCT Table Fields
Following is the list of fields that are available in SAP FMAVCT table. The primary key fields of the table are RCLNT (Client), RLDNR (Ledger), RRCTY (Record Type), RVERS (Version), RYEAR (Fiscal Year), ROBJNR (Object number for objects (account assignment elements)), COBJNR (Object number for transaction attributes), SOBJNR (Object number for partner objects (accnt assignmnt elements)), RTCUR (Currency Key), DRCRK (Debit/Credit Indicator), RPMAX (Period).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| RCLNT | Client | MANDT | T000 | CLNT (3) |
| RLDNR | Ledger | RLDNR | T881 | CHAR (2) |
| RRCTY | Record Type | RRCTY | CHAR (1) | |
| RVERS | Version | RVERS | T894 | CHAR (3) |
| RYEAR | Fiscal Year | GJAHR | NUMC (4) | |
| ROBJNR | Object number for objects (account assignment elements) | GOBJNR_R | CHAR (18) | |
| COBJNR | Object number for transaction attributes | GOBJNR_C | CHAR (18) | |
| SOBJNR | Object number for partner objects (accnt assignmnt elements) | GOBJNR_S | CHAR (18) | |
| RTCUR | Currency Key | RTCUR | TCURC | CUKY (5) |
| DRCRK | Debit/Credit Indicator | SHKZG | CHAR (1) | |
| RPMAX | Period | RPMAX | NUMC (3) | |
| RFIKRS | Financial Management Area | FIKRS | FM01 | CHAR (4) |
| RFUND | Fund | BP_GEBER | CHAR (10) | |
| RFUNDSCTR | Funds Center | FISTL | CHAR (16) | |
| RCMMTITEM | Commitment item | FM_FIPEX | CHAR (24) | |
| RFUNCAREA | Functional Area | FM_FAREA | CHAR (16) | |
| RUSERDIM | Customer Field for FM Actual and Commitment Data | FM_USERDIM | CHAR (10) | |
| RGRANT_NBR | Grant | GM_GRANT_NBR | GMGR | CHAR (20) |
| RMEASURE | Funded Program | FM_MEASURE | CHAR (24) | |
| RCVRGRP_9 | Cover Group | FMCE_CVRGRP | CHAR (16) | |
| BUDGET_PD_9 | Budget Period | FM_BUDGET_PERIOD | CHAR (10) | |
| CEFFYEAR_9 | Year of Cash Effectivity | GNJHR | NUMC (4) | |
| WFSTATE_9 | Workflow Status of a Record in the AVC Totals Table | BUAVC_WFSTATE | CHAR (1) | |
| ALLOCTYPE_9 | Amount Type (Availability Control) | BUAVC_ALLOCTYPE | CHAR (4) | |
| LOGSYS | Logical system | LOGSYS | CHAR (10) | |
| TSLVT | Balance carried forward in transaction currency | TSLVT9_CS | CURR (17) | |
| TSL01 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL02 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL03 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL04 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL05 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL06 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL07 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL08 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL09 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL10 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL11 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL12 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL13 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL14 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL15 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL16 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| HSLVT | Balance carried forward in local currency | HSLVT9_CS | CURR (17) | |
| HSL01 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL02 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL03 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL04 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL05 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL06 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL07 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL08 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL09 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL10 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL11 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL12 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL13 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL14 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL15 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL16 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| KSLVT | Balance carried forward in group currency | KSLVT9_CS | CURR (17) | |
| KSL01 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL02 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL03 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL04 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL05 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL06 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL07 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL08 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL09 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL10 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL11 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL12 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL13 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL14 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL15 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL16 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| CSPRED | Distribution key for currency amounts | CSPRED | T821S | CHAR (4) |
