FILC SAP (FI-LC: Database Structure for Reporting) Structure details

Dictionary Type: Structure
Description: FI-LC: Database Structure for Reporting




ABAP Code to SELECT data from FILC
Related tables to FILC
Access table FILC




Structure field list including key, data, relationships and ABAP select examples

FILC is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "FI-LC: Database Structure for Reporting" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FILC TYPE FILC.

The FILC table consists of various fields, each holding specific information or linking keys about FI-LC: Database Structure for Reporting data available in SAP. These include RLDNR (Ledger), RVERS (Consolidation version), RYEAR (Fiscal Year), RTCUR (Currency Key).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP FILC structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
RCLNTClient MANDTCLNT3T000MANDT
RLDNRLedger RLDNRCHAR2T881ALPHARLDNRGLNH_T881
RVERSConsolidation version RVERS_GCCHAR3T858ALPHARVERS_GCGVS
RYEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
RTCURCurrency Key RTCURCUKY5TCURCWAERSFWS
RUNITBase Unit of Measure MEINSUNIT3T006CUNITMEINS
RPMAXPeriod RPMAXNUMC3RPMAX
RCOMPCompany RCOMP_DCHAR6T880ALPHARCOMPGCC
RACCTConsolidation item RITEMCHAR10T854ALPHARITEMH_T854
RASSCCompany ID of trading partner RASSCCHAR6T880ALPHARCOMPPGS
RLEVLPosting level RLEVLCHAR1RLEVL
DOCTYDocument type DOCTY_GCCHAR2T876BALPHADOCTY_GCBAR
RSUBDSubgroup RSUBDCHAR3T852RSUBDGSG
RMVCTTransaction Type RMVCTCHAR3T856RMVCT
RYACQYear of acquisition RYACQCHAR4GJAHRCJAHR
RPACQPeriod of Acquisition RPACQNUMC3NUM03
AACCTAlternative consolidation item for reporting AACCTCHAR10T854ALPHARITEM
AMVCTAlternative transaction type for reporting AMVCTCHAR3T856RMVCT
ADFLD1First additional field for user-defined account assignments ADFLD1CHAR10T85AADFLD1FK_ADFLD1
ADFLD2Second additional field for user-defined account assignments ADFLD2CHAR10T85BADFLD2FK_ADFLD2
ADFLD3Third additional field for user-defined account assignments ADFLD3CHAR10T85CADFLD3FK_ADFLD3
SG_RVERSVersion for subgroup structure SG_RVERSCHAR3T858ALPHARVERS_GCGVS
SG_RYEARFiscal year for subgroup structure SG_RYEARNUMC4GJAHRGJAHRGJR
ROBUKRSOriginal company code OBUKRCHAR4T001BUKRS
TSLVTBalance carried forward in transaction currency TSLVT9CURR17(2) WERTV9
TSL01Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL02Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL03Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL04Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL05Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL06Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL07Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL08Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL09Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL10Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL11Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL12Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL13Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL14Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL15Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL16Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
HSLVTBalance carried forward in local currency HSLVT9CURR17(2) WERTV9
HSL01Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL02Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL03Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL04Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL05Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL06Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL07Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL08Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL09Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL10Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL11Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL12Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL13Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL14Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL15Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL16Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
KSLVTBalance carried forward in group currency KSLVT9CURR17(2) WERTV9
KSL01Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL02Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL03Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL04Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL05Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL06Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL07Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL08Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL09Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL10Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL11Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL12Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL13Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL14Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL15Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL16Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
MSLVTBalance carried forward of quantity MSLVTQUAN15(3) MENGV8
MSL01Total of the transactions of period in units of measure MSLXXQUAN15(3) MENGV8
MSL02Total of the transactions of period in units of measure MSLXXQUAN15(3) MENGV8
MSL03Total of the transactions of period in units of measure MSLXXQUAN15(3) MENGV8
MSL04Total of the transactions of period in units of measure MSLXXQUAN15(3) MENGV8
MSL05Total of the transactions of period in units of measure MSLXXQUAN15(3) MENGV8
MSL06Total of the transactions of period in units of measure MSLXXQUAN15(3) MENGV8
MSL07Total of the transactions of period in units of measure MSLXXQUAN15(3) MENGV8
MSL08Total of the transactions of period in units of measure MSLXXQUAN15(3) MENGV8
MSL09Total of the transactions of period in units of measure MSLXXQUAN15(3) MENGV8
MSL10Total of the transactions of period in units of measure MSLXXQUAN15(3) MENGV8
MSL11Total of the transactions of period in units of measure MSLXXQUAN15(3) MENGV8
MSL12Total of the transactions of period in units of measure MSLXXQUAN15(3) MENGV8
MSL13Total of the transactions of period in units of measure MSLXXQUAN15(3) MENGV8
MSL14Total of the transactions of period in units of measure MSLXXQUAN15(3) MENGV8
MSL15Total of the transactions of period in units of measure MSLXXQUAN15(3) MENGV8
MSL16Total of the transactions of period in units of measure MSLXXQUAN15(3) MENGV8
ASLVTBalance carried forward of additional quantity ASLVTQUAN15(3) MENGV8
ASL01Total of transactions of period in additional quantities ASLXXQUAN15(3) MENGV8
ASL02Total of transactions of period in additional quantities ASLXXQUAN15(3) MENGV8
ASL03Total of transactions of period in additional quantities ASLXXQUAN15(3) MENGV8
ASL04Total of transactions of period in additional quantities ASLXXQUAN15(3) MENGV8
ASL05Total of transactions of period in additional quantities ASLXXQUAN15(3) MENGV8
ASL06Total of transactions of period in additional quantities ASLXXQUAN15(3) MENGV8
ASL07Total of transactions of period in additional quantities ASLXXQUAN15(3) MENGV8
ASL08Total of transactions of period in additional quantities ASLXXQUAN15(3) MENGV8
ASL09Total of transactions of period in additional quantities ASLXXQUAN15(3) MENGV8
ASL10Total of transactions of period in additional quantities ASLXXQUAN15(3) MENGV8
ASL11Total of transactions of period in additional quantities ASLXXQUAN15(3) MENGV8
ASL12Total of transactions of period in additional quantities ASLXXQUAN15(3) MENGV8
ASL13Total of transactions of period in additional quantities ASLXXQUAN15(3) MENGV8
ASL14Total of transactions of period in additional quantities ASLXXQUAN15(3) MENGV8
ASL15Total of transactions of period in additional quantities ASLXXQUAN15(3) MENGV8
ASL16Total of transactions of period in additional quantities ASLXXQUAN15(3) MENGV8
AUNITAdditional unit of measure AUNITUNIT3Assigned to domainCUNITMEINS

Key field Non-key field



How do I retrieve data from SAP structure FILC using ABAP code?

As FILC is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FILC as there is no data to select.

How to access SAP table FILC

Within an ECC or HANA version of SAP you can also view further information about FILC and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!