GLPO3

Plan Line Items for Object Table | #other | Component: Basic Functions
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
RPMAX Period
DOCCT Document Category Show values
DOCNR Document Number of an Accounting Document
DOCLN Document line
Column Name Description
💲 Currency Key (RTCUR):
TSLVT Balance carried forward in transaction currency
TSL01 Total of transactions of the period in transaction currency
TSL02 Total of transactions of the period in transaction currency
TSL03 Total of transactions of the period in transaction currency
TSL04 Total of transactions of the period in transaction currency
TSL05 Total of transactions of the period in transaction currency
TSL06 Total of transactions of the period in transaction currency
TSL07 Total of transactions of the period in transaction currency
TSL08 Total of transactions of the period in transaction currency
TSL09 Total of transactions of the period in transaction currency
TSL10 Total of transactions of the period in transaction currency
TSL11 Total of transactions of the period in transaction currency
TSL12 Total of transactions of the period in transaction currency
TSL13 Total of transactions of the period in transaction currency
TSL14 Total of transactions of the period in transaction currency
TSL15 Total of transactions of the period in transaction currency
TSL16 Total of transactions of the period in transaction currency
💲 Currency Key (T001.WAERS):
HSLVT Balance carried forward in local currency
HSL01 Total of transactions of the period in local currency
HSL02 Total of transactions of the period in local currency
HSL03 Total of transactions of the period in local currency
HSL04 Total of transactions of the period in local currency
HSL05 Total of transactions of the period in local currency
HSL06 Total of transactions of the period in local currency
HSL07 Total of transactions of the period in local currency
HSL08 Total of transactions of the period in local currency
HSL09 Total of transactions of the period in local currency
HSL10 Total of transactions of the period in local currency
HSL11 Total of transactions of the period in local currency
HSL12 Total of transactions of the period in local currency
HSL13 Total of transactions of the period in local currency
HSL14 Total of transactions of the period in local currency
HSL15 Total of transactions of the period in local currency
HSL16 Total of transactions of the period in local currency
💲 Currency key of the ledger currency (T881.GCURR):
KSLVT Balance carried forward in group currency
KSL01 Total of transactions of the period in group currency
KSL02 Total of transactions of the period in group currency
KSL03 Total of transactions of the period in group currency
KSL04 Total of transactions of the period in group currency
KSL05 Total of transactions of the period in group currency
KSL06 Total of transactions of the period in group currency
KSL07 Total of transactions of the period in group currency
KSL08 Total of transactions of the period in group currency
KSL09 Total of transactions of the period in group currency
KSL10 Total of transactions of the period in group currency
KSL11 Total of transactions of the period in group currency
KSL12 Total of transactions of the period in group currency
KSL13 Total of transactions of the period in group currency
KSL14 Total of transactions of the period in group currency
KSL15 Total of transactions of the period in group currency
KSL16 Total of transactions of the period in group currency
Column Name Description
📏 Base Unit of Measure (RUNIT):
MSLVT Balance carried forward of quantity
MSL01 Total of the transactions of period in units of measure
MSL02 Total of the transactions of period in units of measure
MSL03 Total of the transactions of period in units of measure
MSL04 Total of the transactions of period in units of measure
MSL05 Total of the transactions of period in units of measure
MSL06 Total of the transactions of period in units of measure
MSL07 Total of the transactions of period in units of measure
MSL08 Total of the transactions of period in units of measure
MSL09 Total of the transactions of period in units of measure
MSL10 Total of the transactions of period in units of measure
MSL11 Total of the transactions of period in units of measure
MSL12 Total of the transactions of period in units of measure
MSL13 Total of the transactions of period in units of measure
MSL14 Total of the transactions of period in units of measure
MSL15 Total of the transactions of period in units of measure
MSL16 Total of the transactions of period in units of measure
📏 Additional unit of measure (AUNIT):
ASLVT Balance carried forward of additional quantity
ASL01 Total of transactions of period in additional quantities
ASL02 Total of transactions of period in additional quantities
ASL03 Total of transactions of period in additional quantities
ASL04 Total of transactions of period in additional quantities
ASL05 Total of transactions of period in additional quantities
ASL06 Total of transactions of period in additional quantities
ASL07 Total of transactions of period in additional quantities
ASL08 Total of transactions of period in additional quantities
ASL09 Total of transactions of period in additional quantities
ASL10 Total of transactions of period in additional quantities
ASL11 Total of transactions of period in additional quantities
ASL12 Total of transactions of period in additional quantities
ASL13 Total of transactions of period in additional quantities
ASL14 Total of transactions of period in additional quantities
ASL15 Total of transactions of period in additional quantities
ASL16 Total of transactions of period in additional quantities
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
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
  • GLPO3.RCLNT == T006.MANDT
  • GLPO3.AUNIT == T006.MSEHI
FI-SL Document Type
  • GLPO3.RCLNT == T889.MANDT
  • GLPO3.DOCTY == T889.DOCTY
Activity Type
  • Controlling Area
  • Activity Type
  • Posting Date in the Document
  • GLPO3.RCLNT == CSLA.MANDT
  • GLPO3.RKOKRS == CSLA.KOKRS
  • GLPO3.RACVT == CSLA.LSTAR
  • GLPO3.BUDAT == CSLA.DATBI
Company ID of Trading Partner
  • GLPO3.RCLNT == T880.MANDT
  • GLPO3.RASSC == T880.RCOMP
Company Code
  • GLPO3.RCLNT == T001.MANDT
  • GLPO3.RBUKRS == T001.BUKRS
Business Area
  • GLPO3.RCLNT == TGSB.MANDT
  • GLPO3.RBUSA == TGSB.GSBER
Client GLPO3.RCLNT == T000.MANDT
Cost Center
  • Posting Date in the Document
  • Cost Center
  • Controlling Area
  • GLPO3.RCLNT == CSKS.MANDT
  • GLPO3.BUDAT == CSKS.DATBI
  • GLPO3.RCNTR == CSKS.KOSTL
  • GLPO3.RKOKRS == CSKS.KOKRS
Controlling Area
  • GLPO3.RCLNT == TKA01.MANDT
  • GLPO3.RKOKRS == TKA01.KOKRS
Ledger
  • Ledger
  • Client
  • GLPO3.RLDNR == T881.RLDNR
  • GLPO3.RCLNT == T881.MANDT
Transaction type
  • GLPO3.RCLNT == T856.MANDT
  • GLPO3.RMVCT == T856.TRTYP
Currency Key
  • GLPO3.RCLNT == TCURC.MANDT
  • GLPO3.RTCUR == TCURC.WAERS
Base Unit of Measure
  • GLPO3.RCLNT == T006.MANDT
  • GLPO3.RUNIT == T006.MSEHI
Version
  • Ledger
  • Client
  • Version
  • GLPO3.RLDNR == T894.RLDNR
  • GLPO3.RCLNT == T894.MANDT
  • GLPO3.RVERS == T894.RVERS
Activity Type
  • Controlling Area
  • Activity Type
  • Posting Date in the Document
  • GLPO3.RCLNT == CSLA.MANDT
  • GLPO3.SKOKRS == CSLA.KOKRS
  • GLPO3.SACVT == CSLA.LSTAR
  • GLPO3.BUDAT == CSLA.DATBI
Company ID of Trading Partner
  • GLPO3.RCLNT == T880.MANDT
  • GLPO3.SASSC == T880.RCOMP
Company Code
  • GLPO3.RCLNT == T001.MANDT
  • GLPO3.SBUKRS == T001.BUKRS
Trading partner's business area
  • GLPO3.RCLNT == TGSB.MANDT
  • GLPO3.SBUSA == TGSB.GSBER
Cost Center
  • Posting Date in the Document
  • Cost Center
  • Controlling Area
  • GLPO3.RCLNT == CSKS.MANDT
  • GLPO3.BUDAT == CSKS.DATBI
  • GLPO3.SCNTR == CSKS.KOSTL
  • GLPO3.SKOKRS == CSKS.KOKRS
Controlling Area
  • GLPO3.RCLNT == TKA01.MANDT
  • GLPO3.SKOKRS == TKA01.KOKRS
Transaction type
  • GLPO3.RCLNT == T856.MANDT
  • GLPO3.SMVCT == T856.TRTYP