1. Home
  2. Resources
  3. SAP Tables
  4. GLT1 - Local General Ledger Summary Table

SAP Table GLT1

Local General Ledger Summary Table

GLT1 (Local General Ledger Summary Table) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link GLT1 to other SAP tables.

Source: GLT1 (Local General Ledger Summary Table)

GLT1 table fields

Field Data element Checktable Datatype Length Decimals
RCLNT Client MANDT T000 CLNT 3 0
RLDNR Ledger RLDNR T881 CHAR 2 0
RRCTY Record Type RRCTY CHAR 1 0
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
RVERS Version RVERS T894 CHAR 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
RYEAR Fiscal Year GJAHR NUMC 4 0
RACCT Account Number RACCT CHAR 10 0
RBUSA Business Area GSBER TGSB CHAR 4 0
UMSKZ Special G/L Indicator UMSKZ CHAR 1 0
RMVCT Transaction Type RMVCT T856 CHAR 3 0
OCLNT Original client OCLNT NUMC 3 0
RASSC Company ID of trading partner RASSC T880 CHAR 6 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
RCNTR Cost Center KOSTL CHAR 10 0
RACVT Activity Type LSTAR CHAR 6 0
SBUSA Trading partner's business area PARGB TGSB CHAR 4 0
SCNTR Sender cost center SKOST CHAR 10 0
RTCUR Currency Key RTCUR TCURC CUKY 5 0
RUNIT Base Unit of Measure MEINS T006 UNIT 3 0
DRCRK Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
RPMAX Period RPMAX NUMC 3 0
TSLVT Balance carried forward in transaction currency TSLVT CURR 15 2
TSL01 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL02 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL03 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL04 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL05 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL06 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL07 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL08 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL09 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL10 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL11 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL12 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL13 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL14 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL15 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL16 Total transactions of the period in transaction currency TSLXX CURR 15 2
HSLVT Balance carried forward in local currency (currency 2) HSLVT CURR 15 2
HSL01 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL02 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL03 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL04 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL05 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL06 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL07 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL08 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL09 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL10 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL11 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL12 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL13 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL14 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL15 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL16 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
KSLVT Balance carried forward in group currency (currency 3) KSLVT CURR 15 2
KSL01 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL02 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL03 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL04 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL05 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL06 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL07 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL08 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL09 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL10 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL11 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL12 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL13 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL14 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL15 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL16 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
MSLVT Balance carried forward of quantity MSLVT QUAN 15 3
MSL01 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL02 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL03 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL04 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL05 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL06 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL07 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL08 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL09 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL10 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL11 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL12 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL13 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL14 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL15 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL16 Total of the transactions of period in units of measure MSLXX QUAN 15 3
ASLVT Balance carried forward of additional quantity ASLVT QUAN 15 3
ASL01 Total of transactions of period in additional quantities ASLXX QUAN 15 3
ASL02 Total of transactions of period in additional quantities ASLXX QUAN 15 3
ASL03 Total of transactions of period in additional quantities ASLXX QUAN 15 3
ASL04 Total of transactions of period in additional quantities ASLXX QUAN 15 3
ASL05 Total of transactions of period in additional quantities ASLXX QUAN 15 3
ASL06 Total of transactions of period in additional quantities ASLXX QUAN 15 3
ASL07 Total of transactions of period in additional quantities ASLXX QUAN 15 3
ASL08 Total of transactions of period in additional quantities ASLXX QUAN 15 3
ASL09 Total of transactions of period in additional quantities ASLXX QUAN 15 3
ASL10 Total of transactions of period in additional quantities ASLXX QUAN 15 3
ASL11 Total of transactions of period in additional quantities ASLXX QUAN 15 3
ASL12 Total of transactions of period in additional quantities ASLXX QUAN 15 3
ASL13 Total of transactions of period in additional quantities ASLXX QUAN 15 3
ASL14 Total of transactions of period in additional quantities ASLXX QUAN 15 3
ASL15 Total of transactions of period in additional quantities ASLXX QUAN 15 3
ASL16 Total of transactions of period in additional quantities ASLXX QUAN 15 3
AUNIT Additional unit of measure AUNIT T006 UNIT 3 0
CSPRED Distribution key for currency amounts CSPRED T821S CHAR 4 0
QSPRED Distribution key for quantities QSPRED T821S CHAR 4 0

GLT1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
GLT1 AUNIT GLT1 AUNIT T006 Units of Measurement MSEHI
GLT1 AUNIT GLT1 RCLNT T006 Units of Measurement MANDT
GLT1 BUKRS GLT1 BUKRS T001 Company Codes BUKRS
GLT1 BUKRS GLT1 RCLNT T001 Company Codes MANDT
GLT1 CSPRED GLT1 CSPRED T821S Distribution keys SPRED
GLT1 CSPRED GLT1 RCLNT T821S Distribution keys MANDT
GLT1 KOKRS GLT1 KOKRS TKA01 Controlling Areas KOKRS
GLT1 KOKRS GLT1 RCLNT TKA01 Controlling Areas MANDT
GLT1 QSPRED GLT1 QSPRED T821S Distribution keys SPRED
GLT1 QSPRED GLT1 RCLNT T821S Distribution keys MANDT
GLT1 RASSC GLT1 RASSC T880 Global Company Data (for KONS Ledger) RCOMP
GLT1 RASSC GLT1 RCLNT T880 Global Company Data (for KONS Ledger) MANDT
GLT1 RBUSA GLT1 RBUSA TGSB Business Areas GSBER
GLT1 RBUSA GLT1 RCLNT TGSB Business Areas MANDT
GLT1 RCLNT GLT1 RCLNT T000 Clients MANDT
GLT1 RLDNR GLT1 RLDNR T881 Ledger Master RLDNR
GLT1 RLDNR GLT1 RCLNT T881 Ledger Master MANDT
GLT1 RMVCT GLT1 RMVCT T856 Transaction Types TRTYP
GLT1 RMVCT GLT1 RCLNT T856 Transaction Types MANDT
GLT1 RTCUR GLT1 RTCUR TCURC Currency Codes WAERS
GLT1 RTCUR GLT1 RCLNT TCURC Currency Codes MANDT
GLT1 RUNIT GLT1 RCLNT T006 Units of Measurement MANDT
GLT1 RUNIT GLT1 RUNIT T006 Units of Measurement MSEHI
GLT1 RVERS GLT1 RVERS T894 FI-SL and FI-LC Versions RVERS
GLT1 RVERS GLT1 RLDNR T894 FI-SL and FI-LC Versions RLDNR
GLT1 RVERS GLT1 RCLNT T894 FI-SL and FI-LC Versions MANDT
GLT1 SBUSA GLT1 RCLNT TGSB Business Areas MANDT
GLT1 SBUSA GLT1 SBUSA TGSB Business Areas GSBER