GLT3

Summary Data Preparations for Consolidation | #transactional | Component: Basic Functions
Column Name Description
RCLNT FK Client
RLDNR FK Ledger
RRCTY Record Type Show values
RVERS FK Version
BUKRS FK Company Code
RYEAR Fiscal Year
RACCT Account Number
RBUSA FK Business Area
RMVCT FK Transaction type
RASSC FK Company ID of Trading Partner
SBUSA FK Trading partner's business area
RYACQ Year of acquisition
RPACQ Period of Acquisition
RTCUR FK Currency Key
DRCRK Debit/Credit Indicator Show values
RPMAX Period
Column Name Description
💲 Currency Key (RTCUR):
TSLVT Balance carried forward in transaction currency
TSL01 Total transactions of the period in transaction currency
TSL02 Total transactions of the period in transaction currency
TSL03 Total transactions of the period in transaction currency
TSL04 Total transactions of the period in transaction currency
TSL05 Total transactions of the period in transaction currency
TSL06 Total transactions of the period in transaction currency
TSL07 Total transactions of the period in transaction currency
TSL08 Total transactions of the period in transaction currency
TSL09 Total transactions of the period in transaction currency
TSL10 Total transactions of the period in transaction currency
TSL11 Total transactions of the period in transaction currency
TSL12 Total transactions of the period in transaction currency
TSL13 Total transactions of the period in transaction currency
TSL14 Total transactions of the period in transaction currency
TSL15 Total transactions of the period in transaction currency
TSL16 Total transactions of the period in transaction currency
💲 Currency Key (T001.WAERS):
HSLVT Balance carried forward in local currency (currency 2)
HSL01 Total transactions in the period in local currency (curr 2)
HSL02 Total transactions in the period in local currency (curr 2)
HSL03 Total transactions in the period in local currency (curr 2)
HSL04 Total transactions in the period in local currency (curr 2)
HSL05 Total transactions in the period in local currency (curr 2)
HSL06 Total transactions in the period in local currency (curr 2)
HSL07 Total transactions in the period in local currency (curr 2)
HSL08 Total transactions in the period in local currency (curr 2)
HSL09 Total transactions in the period in local currency (curr 2)
HSL10 Total transactions in the period in local currency (curr 2)
HSL11 Total transactions in the period in local currency (curr 2)
HSL12 Total transactions in the period in local currency (curr 2)
HSL13 Total transactions in the period in local currency (curr 2)
HSL14 Total transactions in the period in local currency (curr 2)
HSL15 Total transactions in the period in local currency (curr 2)
HSL16 Total transactions in the period in local currency (curr 2)
💲 Currency key of the ledger currency (T881.GCURR):
KSLVT Balance carried forward in group currency (currency 3)
KSL01 Total transactions in the period in group currency (curr 3)
KSL02 Total transactions in the period in group currency (curr 3)
KSL03 Total transactions in the period in group currency (curr 3)
KSL04 Total transactions in the period in group currency (curr 3)
KSL05 Total transactions in the period in group currency (curr 3)
KSL06 Total transactions in the period in group currency (curr 3)
KSL07 Total transactions in the period in group currency (curr 3)
KSL08 Total transactions in the period in group currency (curr 3)
KSL09 Total transactions in the period in group currency (curr 3)
KSL10 Total transactions in the period in group currency (curr 3)
KSL11 Total transactions in the period in group currency (curr 3)
KSL12 Total transactions in the period in group currency (curr 3)
KSL13 Total transactions in the period in group currency (curr 3)
KSL14 Total transactions in the period in group currency (curr 3)
KSL15 Total transactions in the period in group currency (curr 3)
KSL16 Total transactions in the period in group currency (curr 3)
Column Name Description
Column Name Description
Column Name Description
RRCTY Record Type Show values
DRCRK Debit/Credit Indicator Show values
Column Name Description Domain name
CSPRED Distribution key for currency amounts SPRED
Master Data Relations Join Conditions
Company Code
  • GLT3.RCLNT == T001.MANDT
  • GLT3.BUKRS == T001.BUKRS
Company ID of Trading Partner
  • GLT3.RCLNT == T880.MANDT
  • GLT3.RASSC == T880.RCOMP
Business Area
  • GLT3.RCLNT == TGSB.MANDT
  • GLT3.RBUSA == TGSB.GSBER
Client GLT3.RCLNT == T000.MANDT
Ledger
  • Ledger
  • Client
  • GLT3.RLDNR == T881.RLDNR
  • GLT3.RCLNT == T881.MANDT
Transaction type
  • GLT3.RCLNT == T856.MANDT
  • GLT3.RMVCT == T856.TRTYP
Currency Key
  • GLT3.RCLNT == TCURC.MANDT
  • GLT3.RTCUR == TCURC.WAERS
Version
  • Ledger
  • Client
  • Version
  • GLT3.RLDNR == T894.RLDNR
  • GLT3.RCLNT == T894.MANDT
  • GLT3.RVERS == T894.RVERS
Trading partner's business area
  • GLT3.RCLNT == TGSB.MANDT
  • GLT3.SBUSA == TGSB.GSBER