SAP table FILCC (FI-LC: Transaction-related fields for table FILCT)

SAP table FILCC has 2 primary key fields being MANDT,OBJNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
OBJNR Object number for FI-SL tables CHAR 18 0 GOBJNR
RLEVL Posting level CHAR 1 0 RLEVL
1 Standardizing entries to one company
2 Eliminating entries by company pair
3 Subgroup-dependent consolidating entries (partner in subgrp)
4 Subgroup-dependent consolidating entries (ext.trdng partner)
DOCTY FI-SL Document Type CHAR 2 0 T889 DOCTY
RSUBD Subgroup CHAR 3 0 T852 RSUBD
RMVCT Transaction type CHAR 3 0 T856 RMVCT
RYACQ Year of acquisition CHAR 4 0 RYACQ
RPACQ Period of Acquisition NUMC 3 0 RPACQ
OCLNT Original client NUMC 3 0 OCLNT
ADFLD1 First additional field for user-defined account assignments CHAR 10 0 T85A ADFLD1
ADFLD2 Second additional field for user-defined account assignments CHAR 10 0 T85B ADFLD2
ADFLD3 Third additional field for user-defined account assignments CHAR 10 0 T85C ADFLD3

FILCC foreign key relationships

Table Field Check Table Check Field
0 FILCC ADFLD1 T85A First additional field MANDT
0 FILCC ADFLD1 T85A First additional field ADFLD1
1 FILCC ADFLD2 T85B Second additional field MANDT
1 FILCC ADFLD2 T85B Second additional field ADFLD2
0 FILCC ADFLD3 T85C Third additional field MANDT
0 FILCC ADFLD3 T85C Third additional field ADFLD3
1 FILCC DOCTY T889 FI-SL Document Types MANDT
1 FILCC DOCTY T889 FI-SL Document Types DOCTY
0 FILCC MANDT T000 Clients MANDT
1 FILCC RMVCT T856 Transaction Types MANDT
1 FILCC RMVCT T856 Transaction Types TRTYP
0 FILCC RSUBD T852 Subgroups MANDT