1. SAP Tutorial
  2. FI Module

FILCP SAP table for – FI-LC: Plan line items for object table

Here we would like to draw your attention to FILCP table in SAP. As we know it is being mainly used with the SAP FI-LC (Consolidation in FI) component which is coming under FI module (Financial Accounting). FILCP is a SAP standard transp table used for storing FI-LC: Plan line items for object table related data in SAP. It comes under the package FKUC.

SAP FILCP table

Table FILCP technical data

TableFILCP
Data storingFI-LC: Plan line items for object table
ModuleFI
Sub ModuleFI-LC-LC
SAP PackageFKUC
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP FILCP 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 FILCP 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
  • RUNIT : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • 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 : Document line
    Its data type is CHAR (Character String) with field length 3
  • RCOMP : Company
    Its data type is CHAR (Character String) with field length 6
  • RACCT : Consolidation item
    Its data type is CHAR (Character String) with field length 10
  • RBUSA : Business Area
    Its data type is CHAR (Character String) with field length 4
  • RASSC : Company ID of trading partner
    Its data type is CHAR (Character String) with field length 6
  • ROBUKRS : Original company code
    Its data type is CHAR (Character String) with field length 4
  • RLEVL : Posting level
    Its data type is CHAR (Character String) with field length 1
  • DOCTY : FI-SL Document Type
    Its data type is CHAR (Character String) with field length 2
  • RSUBD : Subgroup
    Its data type is CHAR (Character String) with field length 3
  • RMVCT : Transaction type
    Its data type is CHAR (Character String) with field length 3
  • RYACQ : Year of acquisition
    Its data type is CHAR (Character String) with field length 4
  • RPACQ : Period of Acquisition
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • OCLNT : Original client
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • ADFLD1 : First additional field for user-defined account assignments
    Its data type is CHAR (Character String) with field length 10
  • ADFLD2 : Second additional field for user-defined account assignments
    Its data type is CHAR (Character String) with field length 10
  • ADFLD3 : Third additional field for user-defined account assignments
    Its data type is CHAR (Character String) with field length 10
  • SCOMP : Company
    Its data type is CHAR (Character String) with field length 6
  • SACCT : Consolidation item
    Its data type is CHAR (Character String) with field length 10
  • SBUSA : Trading partner’s business area
    Its data type is CHAR (Character String) with field length 4
  • SASSC : Company ID of trading partner
    Its data type is CHAR (Character String) with field length 6
  • 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
  • MSLVT : Balance carried forward of quantity
    Its data type is QUAN (Quantity field) with field length 15
  • MSL01 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL02 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL03 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL04 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL05 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL06 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL07 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL08 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL09 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL10 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL11 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL12 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL13 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL14 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL15 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL16 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • ASLVT : Balance carried forward of additional quantity
    Its data type is QUAN (Quantity field) with field length 15
  • ASL01 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL02 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL03 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL04 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL05 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL06 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL07 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL08 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL09 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL10 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL11 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL12 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL13 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL14 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL15 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL16 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • AUNIT : Additional unit of measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • AUTOM : Indicator: Automatic posting lines
    Its data type is CHAR (Character String) with field length 1
  • 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 : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • REFRYEAR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • REFDOCLN : Number of Line Item Within Accounting Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • REFDOCCT : Document Type
    Its data type is CHAR (Character String) with field length 1
  • REFACTIV : Business 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
  • LOGSYS : Logical system
    Its data type is CHAR (Character String) with field length 10

    • FILCP related tables

    • T876V : Validation of Consolidation document
    • T880G : Consolidation companies
    • T884S : Sets used in currency translation
    • T869 : Consolidation methods
    • T855 : Reasons for inclusion in consolidation
    • GSBLCA : Business area consolidation: deviating records
    • T870 : Consolidation method assignment
    • T85CT : Third additional field: Texts
    • T85AT : First additional field: Texts
    • T872I : Periodic entry for affiliated companies
    • T852O : Consolidation frequencies: Texts
    • T868 : Elimination of IC profit and loss
    • T862R : Standard reports: Column layout texts
    • T857N : Validation groups
    • T854S : Selected FS items
    • T859 : Data entry forms
    • T857T : Column layout for data entry form: Text
    • T856T : Transaction type texts
    • T850G : Upload Methods: Texts
    • EWULC01 : FI-LC: LC ledger

    Related References

    Related Tutorials

    PCRRETAILP SAP table for – Plan line items table

    PCRRETAILP table in SAP FI (Retail Ledger in FI) module. This table is used for storing data of Plan line...

    FAGLFLEXP SAP table for – General Ledger: Plan Line Items

    FAGLFLEXP table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of General...

    /CCIS/PROFTAXP SAP table for – Plan Line Items Table for General Ledger

    /CCIS/PROFTAXP table in SAP FI (Special Purpose Ledger in FI) module. This table is used for storing data of Plan...

    GLFLEXP SAP table for – Flexible G/L: Plan line items

    GLFLEXP table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Flexible...

    /CCIS/PBU18P SAP table for – PBU18: Plan line item table

    /CCIS/PBU18P table in SAP FI (Special Purpose Ledger in FI) module. This table is used for storing data of PBU18:...

    FILCT SAP table for – FI-LC: Global totals table with 2 object tables

    FILCT table in SAP FI (Consolidation in FI) module. This table is used for storing data of FI-LC: Global totals...

    FMIP SAP table for – Plan Line Items Table for Funds Management

    FMIP table in SAP FI (Funds Management in FI) module. This table is used for storing data of Plan Line...

    «
    »