SAP Table GLT0
G/L account master record transaction figures
GLT0 (G/L account master record transaction figures) 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 GLT0 to other SAP tables.
To know if clasical general ledger accounting is active in the SAP system check table FAGL_ACTIVEC
GLT0 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
RCLNT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||
|
RLDNR
Ledger
|
RLDNR | T881 |
CHAR
|
2 | 0 | |||||||||||
|
RRCTY
Record Type
|
RRCTY |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | |||||||||||
|
RTCUR
Currency Key
|
RTCUR | TCURC |
CUKY
|
5 | 0 | |||||||||||
|
DRCRK
Debit/Credit Indicator
|
SHKZG |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
CSPRED
Distribution key for currency amounts
|
CSPRED | T821S |
CHAR
|
4 | 0 | |||||||||||
|
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 | ||||||||||||
GLT0 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| GLT0 | BUKRS | GLT0 | RCLNT |
T001
Company Codes
|
MANDT |
| GLT0 | BUKRS | GLT0 | BUKRS |
T001
Company Codes
|
BUKRS |
| GLT0 | CSPRED | GLT0 | RCLNT |
T821S
Distribution keys
|
MANDT |
| GLT0 | CSPRED | GLT0 | CSPRED |
T821S
Distribution keys
|
SPRED |
| GLT0 | RBUSA | GLT0 | RCLNT |
TGSB
Business Areas
|
MANDT |
| GLT0 | RBUSA | GLT0 | RBUSA |
TGSB
Business Areas
|
GSBER |
| GLT0 | RCLNT | GLT0 | RCLNT |
T000
Clients
|
MANDT |
| GLT0 | RLDNR | GLT0 | RLDNR |
T881
Ledger Master
|
RLDNR |
| GLT0 | RLDNR | GLT0 | RCLNT |
T881
Ledger Master
|
MANDT |
| GLT0 | RTCUR | GLT0 | RTCUR |
TCURC
Currency Codes
|
WAERS |
| GLT0 | RTCUR | GLT0 | RCLNT |
TCURC
Currency Codes
|
MANDT |
| GLT0 | RVERS | GLT0 | RCLNT |
T894
FI-SL and FI-LC Versions
|
MANDT |
| GLT0 | RVERS | GLT0 | RLDNR |
T894
FI-SL and FI-LC Versions
|
RLDNR |
| GLT0 | RVERS | GLT0 | RVERS |
T894
FI-SL and FI-LC Versions
|
RVERS |