SAP table GLT1 (Local General Ledger Summary Table)

SAP table GLT1 has 21 primary key fields being RCLNT,RLDNR,RRCTY,RVERS,BUKRS,RYEAR,RACCT,RBUSA,UMSKZ,RMVCT,OCLNT,RASSC,KOKRS,RCNTR,RACVT,SBUSA,SCNTR,RTCUR,RUNIT,DRCRK,RPMAX.

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

GLT1 foreign key relationships

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