G/L Account Master (Chart of Accounts) — chart-of-accounts-level G/L account attributes shared across all company codes.
Hover a canonical name to see the legacy SAP field name
| Canonical name | Concept | Description | Data element | Type | Check table |
|---|---|---|---|---|---|
| CLI key | cliens | Client | MANDT | CLNT 3 | T000 |
| TBR key | tabula rationum | Chart of Accounts | KTOPL | CHAR 4 | T004 |
| RAT_NUM key | ratio numerus | G/L Account Number | SAKNR | CHAR 10 | — |
| IDX_RAT_AEQ | index ratio aequilibrium | Indicator: Account is a balance sheet account? | XBILK | CHAR 1 | — |
| RAT_NUM2 | ratio numerus | G/L account number, significant length | SAKAN | CHAR 10 | — |
| CTS_RAT_NUM | coetus ratio numerus | Group Account Number | BILKT | CHAR 10 | SKA1 |
| DIE_TBL_CRE | dies tabula creatus | Date on which the Record Was Created | ERDAT_RF | DATS 8 | — |
| NOM_PSN_CRE | nomen persona creatus | Name of Person who Created the Object | ERNAM_RF | CHAR 12 | — |
| RAT_GEN | ratio genus | P&L statement account type | GVTYP | CHAR 2 | — |
| RAT_CTS | ratio coetus | G/L Account Group | KTOKS | CHAR 4 | T077S |
| NUM_EXM_RAT | numerus exemplum ratio | Number of the sample account | MUSTR | CHAR 10 | SKM1 |
| SOC_SNG | societas socius negotiationis | Company ID of trading partner | RASSC | CHAR 6 | T880 |
| IDX_RAT | index ratio | Indicator: Account marked for deletion? | XLOEV | CHAR 1 | — |
| IDX_RAT2 | index ratio | Indicator: account is blocked for creation? | XSPEA | CHAR 1 | — |
| IDX_RAT_INS | index ratio inscriptio | Indicator: Is Account Blocked for Posting? | XSPEB | CHAR 1 | — |
| IDX_RAT_CNS | index ratio consilium | Indicator: account blocked for planning? | XSPEP | CHAR 1 | — |
| MCOD1 | Search Term for Using Matchcode | MCODF | CHAR 25 | — | |
| AFN | area functionis | Functional Area | FKBER | CHAR 16 | TFKB |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
MANDT | T000 | MANDT |
KTOPL | T004 | KTOPL |
BILKT | SKA1 | BILKT |
KTOKS | T077S | KTOKS |
MUSTR | SKM1 | MUSTR |
VBUND | T880 | VBUND |
FUNC_AREA | TFKB | FKBER |