The FILCA table in SAP ERP or S/4HANA stores FI-LC: Actual journal entry table with 2 object tables data. There are total 58 fields in FILCA table. The FI-LC: Actual journal entry table with 2 object tables 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 FILCA table. It is in FI-LC Consolidation: Unicode-Capable Objects (FKUC) ABAP package and is part of the Basic Functions (FI-LC-LC) module.
SAP FILCA Table Fields
Following is the list of fields that are available in SAP FILCA table. The primary key fields of the table are RCLNT (Client), GL_SIRID (Record number of the line item record).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| RCLNT | Client | MANDT | T000 | CLNT (3) |
| GL_SIRID | Record number of the line item record | GU_RECID | CHAR (18) | |
| RLDNR | Ledger | RLDNR | T881 | CHAR (2) |
| RRCTY | Record Type | RRCTY | CHAR (1) | |
| RVERS | Version | RVERS | T894 | CHAR (3) |
| RYEAR | Fiscal Year | GJAHR | NUMC (4) | |
| RTCUR | Currency Key | RTCUR | TCURC | CUKY (5) |
| RUNIT | Base Unit of Measure | MEINS | T006 | UNIT (3) |
| DRCRK | Debit/Credit Indicator | SHKZG | CHAR (1) | |
| POPER | Posting period | POPER | NUMC (3) | |
| DOCCT | Document Category | DOCCT | CHAR (1) | |
| DOCNR | Accounting Document Number | BELNR_D | CHAR (10) | |
| DOCLN | Document line | DOCLN | CHAR (3) | |
| RCOMP | Company | RCOMP_D | T880 | CHAR (6) |
| RACCT | Consolidation item | RITEM | T854 | CHAR (10) |
| RBUSA | Business Area | GSBER | TGSB | CHAR (4) |
| RASSC | Company ID of Trading Partner | RASSC | CHAR (6) | |
| ROBUKRS | Original company code | OBUKR | T001 | CHAR (4) |
| RLEVL | Posting level | RLEVL | CHAR (1) | |
| DOCTY | FI-SL Document Type | DOCTY | T889 | CHAR (2) |
| RSUBD | Subgroup | RSUBD | T852 | CHAR (3) |
| RMVCT | Transaction type | RMVCT | T856 | CHAR (3) |
| RYACQ | Year of acquisition | RYACQ | CHAR (4) | |
| RPACQ | Period of Acquisition | RPACQ | NUMC (3) | |
| OCLNT | Original client | OCLNT | NUMC (3) | |
| ADFLD1 | First additional field for user-defined account assignments | ADFLD1 | T85A | CHAR (10) |
| ADFLD2 | Second additional field for user-defined account assignments | ADFLD2 | T85B | CHAR (10) |
| ADFLD3 | Third additional field for user-defined account assignments | ADFLD3 | T85C | CHAR (10) |
| SCOMP | Company | SCOMP_D | T880 | CHAR (6) |
| SACCT | Consolidation item | S_ITEM | T854 | CHAR (10) |
| SBUSA | Trading partner’s business area | PARGB | TGSB | CHAR (4) |
| SASSC | Company ID of trading partner | SASSC | T880 | CHAR (6) |
| UPDHP | Highest update period | UPDHP | NUMC (3) | |
| TSL | Value in Transaction Currency | VTCUR9_CS | CURR (17) | |
| HSL | Value in local currency | VLCUR9_CS | CURR (17) | |
| KSL | Value in group currency | VGCUR9_CS | CURR (17) | |
| MSL | Quantity | QUAN1 | QUAN (15) | |
| ASL | Additional Quantity | QUAN2 | QUAN (15) | |
| AUNIT | Additional unit of measure | AUNIT | T006 | UNIT (3) |
| SGTXT | Item Text | SGTXT | CHAR (50) | |
| AUTOM | Indicator: Automatic posting lines | AUTOM | CHAR (1) | |
| ACTIV | Business Transaction | GLVOR | CHAR (4) | |
| BVORG | Number of Cross-Company Code Posting Transaction | BVORG | CHAR (16) | |
| BUDAT | Posting Date in the Document | BUDAT | DATS (8) | |
| WSDAT | Value Date for Currency Translation | WSDAT | DATS (8) | |
| REFDOCNR | Accounting Document Number | BELNR_D | CHAR (10) | |
| REFRYEAR | Reference fiscal year | REFGJAHR | NUMC (4) | |
| REFDOCLN | Number of Line Item Within Accounting Document | BUZEI | NUMC (3) | |
| REFDOCCT | Document Category | DOCCT | CHAR (1) | |
| REFACTIV | Business Transaction | GLVOR | CHAR (4) | |
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS (8) | |
| CPUTM | Time of Entry | CPUTM | TIMS (6) | |
| USNAM | User Name | USNAM | CHAR (12) | |
| RVSDOCNR | Reverse Document Number | STBLG | CHAR (10) | |
| ORNDOCNR | Number of Reversed Document | STBLN | CHAR (10) | |
| AWTYP | Reference procedure | AWTYP | CHAR (5) | |
| AWORG | Reference Organizational Units | AWORG | CHAR (10) | |
| LOGSYS | Logical system | LOGSYS | CHAR (10) |
