GLREFA

Example for Local FI-SL Line Items (Actual) | #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 (T882.CURR1):
HSL Value in Local Currency
💲 Currency key of currency 3 (T882.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
REFDOCCT Reference 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 Six-Character Posting Item for Ledger DOCLN6
RACCT Account Number SAKNR
RCNTR Cost Center KOSTL
SACCT Partner account number SAKNR
SCNTR Partner cost center KOSTL
SGTXT Item Text TEXT50
ACTIV Business Transaction CHAR4
REFDOCNR Reference document number of an accounting document BELNR
REFRYEAR Reference fiscal year GJAHR
REFDOCLN Six-Digit Number of the Reference Posting Line BUZEI6
REFACTIV FI-SL Business Reference Transaction CHAR4
USNAM User Name XUBNAME
AWORG Reference Organizational Units AWORG
Master Data Relations Join Conditions
Additional unit of measure
  • GLREFA.RCLNT == T006.MANDT
  • GLREFA.AUNIT == T006.MSEHI
Reference procedure GLREFA.AWTYP == TTYP.AWTYP
FI-SL Document Type
  • GLREFA.RCLNT == T889.MANDT
  • GLREFA.DOCTY == T889.DOCTY
Logical system GLREFA.LOGSYS == TBDLS.LOGSYS
Company Code
  • GLREFA.RCLNT == T001.MANDT
  • GLREFA.RBUKRS == T001.BUKRS
Business Area
  • GLREFA.RCLNT == TGSB.MANDT
  • GLREFA.RBUSA == TGSB.GSBER
Client GLREFA.RCLNT == T000.MANDT
Functional Area
  • GLREFA.RCLNT == TFKB.MANDT
  • GLREFA.RFAREA == TFKB.FKBER
Ledger
  • Ledger
  • Client
  • GLREFA.RLDNR == T881.RLDNR
  • GLREFA.RCLNT == T881.MANDT
Currency Key
  • GLREFA.RCLNT == TCURC.MANDT
  • GLREFA.RTCUR == TCURC.WAERS
Base Unit of Measure
  • GLREFA.RCLNT == T006.MANDT
  • GLREFA.RUNIT == T006.MSEHI
Version
  • Ledger
  • Client
  • Version
  • GLREFA.RLDNR == T894.RLDNR
  • GLREFA.RCLNT == T894.MANDT
  • GLREFA.RVERS == T894.RVERS
Company Code of Partner
  • GLREFA.RCLNT == T001.MANDT
  • GLREFA.SBUKRS == T001.BUKRS
Trading Partner Business Area of the Business Partner
  • GLREFA.RCLNT == TGSB.MANDT
  • GLREFA.SBUSA == TGSB.GSBER
Partner Functional Area
  • GLREFA.RCLNT == TFKB.MANDT
  • GLREFA.SFAREA == TFKB.FKBER