G/L Account Master (Company Code) — company-code-specific G/L account control data (open item mgmt, tolerance, tax, interest).
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 |
| SOC key | codex societatis | Company Code | BUKRS | CHAR 4 | T001 |
| RAT_NUM key | ratio numerus | G/L Account Number | SAKNR | CHAR 10 | SKA1 |
| CTS | coetus | Authorization Group | BRGRU | CHAR 4 | — |
| BUSAB | Accounting clerk | BUSAB | CHAR 2 | T001S | |
| DIE_ULT_USU | dies ultimus usura | Date of the last interest calculation run | DATLZ | DATS 8 | — |
| 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 | — |
| CNS_CTS | consilium coetus | Planning group | FDGRV | CHAR 10 | T035 |
| CNS_GRD | consilium gradus | Planning level | FDLEV | CHAR 2 | T036 |
| POS | positio | Financial Budget Item | FIPLS | NUMC 3 | — |
| CMP_STA_CTS | campus status coetus | Field status group | FSTAG | CHAR 4 | T004F |
| CLV_ARG | clavis argentaria | Short Key for a House Bank | HBKID | CHAR 5 | T012 |
| RAT | ratio | ID for account details | HKTID | CHAR 5 | T012K |
| CLV_RPM_MON | clavis ratio permutationis moneta | Key for Exchange Rate Differences in Foreign Currency Accts | KDFSL | CHAR 4 | T030S |
| RAT2 | ratio | Account is reconciliation account | MITKZ | CHAR 1 | — |
| TRB_CTG_RAT | tributum categoria ratio | Tax Category in Account Master Record | SMWSK | CHAR 2 | — |
| RAT_TXT | ratio textus | G/L account additional text | STEXT_SKB1 | CHAR 50 | — |
| USU_IDX | usura index | Interest calculation indicator | VZSKZ | CHAR 2 | T056 |
| RAT_MON | ratio moneta | Account currency | WAERS_SKB1 | CUKY 5 | TCURC |
| IDX_RAT | index ratio | Indicator: account managed in external system | WMETH | CHAR 2 | — |
| RAT3 | ratio | Cash receipt account / cash disbursement account | XGKON | CHAR 1 | — |
| IDX_RAT2 | index ratio | Indicator: Is account only posted to automatically? | XINTB | CHAR 1 | — |
| IDX_RAT3 | index ratio | Indicator: Can Line Items Be Displayed by Account? | XKRES | CHAR 1 | — |
| IDX_RAT4 | index ratio | Indicator: Account marked for deletion? | XLOEV | CHAR 1 | — |
| IDX | index | Indicator: Supplement for automatic postings? | XNKON | CHAR 1 | — |
| IDX_PAP | index positio aperta | Indicator: Open item management? | XOPVW | CHAR 1 | — |
| IDX_RAT_INS | index ratio inscriptio | Indicator: Is Account Blocked for Posting? | XSPEB | CHAR 1 | — |
| CLV_DIE_ULT | clavis dies ultimus | Key date of the last interest calculation | DZINDT | DATS 8 | — |
| USU | usura | Interest calculation frequency in months | DZINRT | NUMC 2 | — |
| CLV_ASG | clavis assignatio | Key for sorting according to assignment numbers | DZUAWA | CHAR 3 | TZUN |
| RAT_NUM_SOC | ratio numerus codex societatis | Alternative account number in company code | ALTKT_SKB1 | CHAR 10 | — |
| IDX_TMP_INS | index tempus inscriptio | Indicator: Reconcil.acct ready for input at time of posting? | XMITK | CHAR 1 | — |
| IDX2 | index | Recovery Indicator | JV_RECIND | CHAR 2 | T8JJ |
| POS2 | positio | Commitment Item | FIPOS | CHAR 14 | — |
| IDX_TRB_COD | index tributum codex | Indicator: Tax code is not a required field | XMWNO | CHAR 1 | — |
| IDX_MON | index moneta | Indicator: Only Manage Balances in Local Currency | XSALH | CHAR 1 | — |
| AES_CTS | aestimatio coetus | Valuation Group | BEWGP | CHAR 10 | — |
| CLV | clavis | Inflation Key | J_1AIFSKS | CHAR 8 | J_1AINFSKS |
| CTS2 | coetus | Tolerance Group for G/L Accounts | TOGRU_S | CHAR 4 | T043S |
| CPN_LBR | compensatio liber | Clearing Specific to Ledger Groups | XLGCLR | CHAR 1 | — |
| CLV2 | clavis | MCA Key | GLE_DTE_MCA_MCAKEY | CHAR 5 | GLE_MCA_TMCAKEY |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
MANDT | T000 | MANDT |
BUKRS | T001 | BUKRS |
SAKNR | SKA1 | SAKNR |
BUSAB | T001S | BUSAB |
FDGRV | T035 | GRUPP |
FDLEV | T036 | EBENE |
FSTAG | T004F | FSTAG |
HBKID | T012 | HBKID |
HKTID | T012K | HKTID |
KDFSL | T030S | KDFSL |
INFKY | J_1AINFSKS | J_1AIFSKS |
RECID | T8JJ | RECID |
TOGRU | T043S | TOGRU |
VZSKZ | T056 | VZSKZ |
WAERS | TCURC | WAERS |
ZUAWA | TZUN | ZUAWA |