FILCA

FI-LC: Actual journal entry table with 2 object tables | #transactional | Component: Basic Functions
Column Name Description
RCLNT FK Client
GL_SIRID Record number of the line item record
Column Name Description
💲 Currency Key (RTCUR):
TSL Value in Transaction Currency
💲 Currency key of currency 2 (T882C.CURR1):
HSL Value in local currency
💲 Currency key of currency 3 (T882C.CURR2):
KSL Value in group currency
Column Name Description
📏 Base Unit of Measure (RUNIT):
MSL Quantity
📏 Additional unit of measure (AUNIT):
ASL Additional Quantity
Column Name Description
BUDAT Posting Date in the Document
WSDAT Value Date for Currency Translation
CPUDT Day On Which Accounting Document Was Entered
CPUTM Time of Entry
Column Name Description
RRCTY Record Type Show values
DRCRK Debit/Credit Indicator Show values
DOCCT Document Category Show values
RLEVL Posting level Show values
REFDOCCT Document Category Show values
Column Name Description Domain name
RYEAR Fiscal Year GJAHR
POPER Posting period POPER
DOCNR Document Number of an Accounting Document BELNR
DOCLN Document line DOCLN
RASSC Company ID of Trading Partner RCOMP
RYACQ Year of acquisition CJAHR
RPACQ Period of Acquisition NUM03
OCLNT Original client NUM3
UPDHP Highest update period POPER
SGTXT Item Text TEXT50
AUTOM Indicator: Automatic posting lines TEXT1
ACTIV Business Transaction CHAR4
BVORG Number of Cross-Company Code Posting Transaction BVORG
REFDOCNR Document Number of an Accounting Document BELNR
REFRYEAR Reference fiscal year GJAHR
REFDOCLN Number of Line Item Within Accounting Document BUZEI
REFACTIV Business Transaction CHAR4
USNAM User Name XUBNAME
RVSDOCNR Reverse Document Number BELNR
ORNDOCNR Number of Reversed Document BELNR
AWTYP Reference procedure AWTYP
AWORG Reference Organizational Units AWORG
LOGSYS Logical system LOGSYS
Master Data Relations Join Conditions
First additional field for user-defined account assignments
  • FILCA.RCLNT == T85A.MANDT
  • FILCA.ADFLD1 == T85A.ADFLD1
Second additional field for user-defined account assignments
  • FILCA.RCLNT == T85B.MANDT
  • FILCA.ADFLD2 == T85B.ADFLD2
Third additional field for user-defined account assignments
  • Third additional field for user-defined account assignments
  • Client
  • FILCA.ADFLD3 == T85C.ADFLD3
  • FILCA.RCLNT == T85C.MANDT
Additional unit of measure
  • FILCA.RCLNT == T006.MANDT
  • FILCA.AUNIT == T006.MSEHI
FI-SL Document Type
  • FILCA.RCLNT == T889.MANDT
  • FILCA.DOCTY == T889.DOCTY
Consolidation item
  • FILCA.RCLNT == T854.MANDT
  • FILCA.RACCT == T854.ITEM
Business Area
  • FILCA.RCLNT == TGSB.MANDT
  • FILCA.RBUSA == TGSB.GSBER
Client FILCA.RCLNT == T000.MANDT
Company
  • FILCA.RCLNT == T880.MANDT
  • FILCA.RCOMP == T880.RCOMP
Ledger
  • Ledger
  • Client
  • FILCA.RLDNR == T881.RLDNR
  • FILCA.RCLNT == T881.MANDT
Transaction type
  • FILCA.RCLNT == T856.MANDT
  • FILCA.RMVCT == T856.TRTYP
Original company code
  • FILCA.RCLNT == T001.MANDT
  • FILCA.ROBUKRS == T001.BUKRS
Currency Key
  • FILCA.RCLNT == TCURC.MANDT
  • FILCA.RTCUR == TCURC.WAERS
Base Unit of Measure
  • FILCA.RCLNT == T006.MANDT
  • FILCA.RUNIT == T006.MSEHI
Version
  • Ledger
  • Client
  • Version
  • FILCA.RLDNR == T894.RLDNR
  • FILCA.RCLNT == T894.MANDT
  • FILCA.RVERS == T894.RVERS
Consolidation item
  • FILCA.RCLNT == T854.MANDT
  • FILCA.SACCT == T854.ITEM
Company ID of trading partner
  • FILCA.RCLNT == T880.MANDT
  • FILCA.SASSC == T880.RCOMP
Trading partner's business area
  • FILCA.RCLNT == TGSB.MANDT
  • FILCA.SBUSA == TGSB.GSBER
Company
  • FILCA.RCLNT == T880.MANDT
  • FILCA.SCOMP == T880.RCOMP
Other Relations | to Master Data Relations ↑ Join Conditions
Subgroup
  • Subgroup
  • Client
  • FILCA.RSUBD == T852.RSUBD
  • FILCA.RCLNT == T852.MANDT