GL account description table
Question
Where can I find the table that stores name or description of the G/L account?
Answer
Table SKAT keeps that information. It has short text and long text fields that are assigned to G/L account for particular language and chart of accounts.
Below you can find a list of fields in this table:
| Field | If key | Data element | Data type | Length | Decimal | Description |
|---|---|---|---|---|---|---|
| MANDT | X | MANDT | CLNT | 3 | 0 | Client |
| SPRAS | X | SPRAS | LANG | 1 | 0 | Language Key |
| KTOPL | X | KTOPL | CHAR | 4 | 0 | Chart of Accounts |
| SAKNR | X | SAKNR | CHAR | 10 | 0 | G/L Account Number |
| TXT20 | TXT20_SKAT | CHAR | 20 | 0 | G/L account short text | |
| TXT50 | TXT50_SKAT | CHAR | 50 | 0 | G/L Account Long Text | |
| MCOD1 | MCDS1 | CHAR | 25 | 0 | Search Term for Matchcode Search |