GLSO1

FI-SL Line Item Table with Objects for GLTO1 | #other | Component: Basic Functions

🔑 Keys (15)
💰 Amounts (3)
∑ Quantities (2)
📅 Dates (4)
☰ Categorical (4)
Other (13)
🔗 Relations (21)

Column Name	Description
RCLNT FK	Client
RLDNR FK	Ledger
RRCTY	Record Type	Show values
RVERS FK	Version
RYEAR	Fiscal Year
ROBJNR	Object number for FI-SL tables
SOBJNR	Object number for FI-SL tables
OCLNT	Original client
RTCUR FK	Currency Key
RUNIT FK	Base Unit of Measure
DRCRK	Debit/Credit Indicator	Show values
POPER	Posting period
DOCCT	Document Category	Show values
DOCNR	Document Number of an Accounting Document
DOCLN	Document line

Column Name	Description
💲 Currency Key (RTCUR):
TSL	Value in Transaction Currency
💲 Currency Key (T001.WAERS):
HSL	Value in Local Currency
💲 Currency key of the ledger currency (T881.GCURR):
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	Document Category	Show values

Column Name	Description	Domain name
RACCT	Account Number	SAKNR
RUMSKZ	Special G/L Indicator	UMSKZ
SACCT	Account Number	SAKNR
SUMSKZ	Special G/L Indicator	UMSKZ
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	Fiscal Year	GJAHR
REFDOCLN	Number of Line Item Within Accounting Document	BUZEI
REFACTIV	Business Transaction	CHAR4
USNAM	User Name	XUBNAME

Master Data Relations	Join Conditions
Additional unit of measure	`GLSO1.RCLNT == T006.MANDT` `GLSO1.AUNIT == T006.MSEHI`
FI-SL Document Type	`GLSO1.RCLNT == T889.MANDT` `GLSO1.DOCTY == T889.DOCTY`
Activity Type Controlling Area Activity Type Day On Which Accounting Document Was Entered	`GLSO1.RCLNT == CSLA.MANDT` `GLSO1.RKOKRS == CSLA.KOKRS` `GLSO1.RACVT == CSLA.LSTAR` `GLSO1.CPUDT == CSLA.DATBI`
Company ID of Trading Partner	`GLSO1.RCLNT == T880.MANDT` `GLSO1.RASSC == T880.RCOMP`
Company Code	`GLSO1.RCLNT == T001.MANDT` `GLSO1.RBUKRS == T001.BUKRS`
Business Area	`GLSO1.RCLNT == TGSB.MANDT` `GLSO1.RBUSA == TGSB.GSBER`
Client	`GLSO1.RCLNT == T000.MANDT`
Cost Center Day On Which Accounting Document Was Entered Cost Center Controlling Area	`GLSO1.RCLNT == CSKS.MANDT` `GLSO1.CPUDT == CSKS.DATBI` `GLSO1.RCNTR == CSKS.KOSTL` `GLSO1.RKOKRS == CSKS.KOKRS`
Controlling Area	`GLSO1.RCLNT == TKA01.MANDT` `GLSO1.RKOKRS == TKA01.KOKRS`
Ledger Ledger Client	`GLSO1.RLDNR == T881.RLDNR` `GLSO1.RCLNT == T881.MANDT`
Transaction type	`GLSO1.RCLNT == T856.MANDT` `GLSO1.RMVCT == T856.TRTYP`
Currency Key	`GLSO1.RCLNT == TCURC.MANDT` `GLSO1.RTCUR == TCURC.WAERS`
Base Unit of Measure	`GLSO1.RCLNT == T006.MANDT` `GLSO1.RUNIT == T006.MSEHI`
Version Ledger Client Version	`GLSO1.RLDNR == T894.RLDNR` `GLSO1.RCLNT == T894.MANDT` `GLSO1.RVERS == T894.RVERS`
Activity Type Controlling Area Activity Type Day On Which Accounting Document Was Entered	`GLSO1.RCLNT == CSLA.MANDT` `GLSO1.SKOKRS == CSLA.KOKRS` `GLSO1.SACVT == CSLA.LSTAR` `GLSO1.CPUDT == CSLA.DATBI`
Company ID of Trading Partner	`GLSO1.RCLNT == T880.MANDT` `GLSO1.SASSC == T880.RCOMP`
Company Code	`GLSO1.RCLNT == T001.MANDT` `GLSO1.SBUKRS == T001.BUKRS`
Trading partner's business area	`GLSO1.RCLNT == TGSB.MANDT` `GLSO1.SBUSA == TGSB.GSBER`
Cost Center Day On Which Accounting Document Was Entered Cost Center Controlling Area	`GLSO1.RCLNT == CSKS.MANDT` `GLSO1.CPUDT == CSKS.DATBI` `GLSO1.SCNTR == CSKS.KOSTL` `GLSO1.SKOKRS == CSKS.KOKRS`
Controlling Area	`GLSO1.RCLNT == TKA01.MANDT` `GLSO1.SKOKRS == TKA01.KOKRS`
Transaction type	`GLSO1.RCLNT == T856.MANDT` `GLSO1.SMVCT == T856.TRTYP`