SKA1 G/L Account Master (Chart of Accounts)
SAP table SKA1 (G/L Account Master (Chart of Accounts)) contains the general ledger account master data at the chart of accounts level. It stores key information about G/L accounts, such as the account number, account type, description, group account assignments, and other chart-level attributes. This table is primarily used to define the structure and attributes of G/L accounts that can then be linked to company-specific settings in related tables like SKB1 (Company Code Data for G/L Accounts).
SAP table SKA1 has 3 primary key fields being MANDT,KTOPL,SAKNR.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
SKA1 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||
| KeyKTOPL | Chart of Accounts | CHAR | 4 | 0 | T004 | KTOPL | |||||||||||
| KeySAKNR | G/L Account Number | CHAR | 10 | 0 | SAKNR | ||||||||||||
| XBILK | Indicator: Account is a balance sheet account? | CHAR | 1 | 0 | XBILK | ||||||||||||
| SAKAN | G/L Account Number, Significant Length | CHAR | 10 | 0 | SAKAN | ||||||||||||
| BILKT | Group Account Number | CHAR | 10 | 0 | SKA1 | BILKT | |||||||||||
| ERDAT | Date on which the Record Was Created | DATS | 8 | 0 | ERDAT_RF | ||||||||||||
| ERNAM | Name of Person who Created the Object | CHAR | 12 | 0 | ERNAM_RF | ||||||||||||
| GVTYP | P&L statement account type | CHAR | 2 | 0 | GVTYP | ||||||||||||
| KTOKS | G/L Account Group | CHAR | 4 | 0 | T077S | KTOKS | |||||||||||
| MUSTR | Number of the Sample Account | CHAR | 10 | 0 | SKM1 | MUSTR | |||||||||||
| VBUND | Company ID of Trading Partner | CHAR | 6 | 0 | T880 | RASSC | |||||||||||
| XLOEV | Indicator: Account Marked for Deletion? | CHAR | 1 | 0 | XLOEV | ||||||||||||
| XSPEA | Indicator: Account Is Blocked for Creation ? | CHAR | 1 | 0 | XSPEA | ||||||||||||
| XSPEB | Indicator: Is Account Blocked for Posting? | CHAR | 1 | 0 | XSPEB | ||||||||||||
| XSPEP | Indicator: Account Blocked for Planning ? | CHAR | 1 | 0 | XSPEP | ||||||||||||
| MCOD1 | Search Term for Using Matchcode | CHAR | 25 | 0 | MCODF | ||||||||||||
| FUNC_AREA | Functional Area | CHAR | 16 | 0 | TFKB | FKBER | |||||||||||
| GLACCOUNT_TYPE | Type of a General Ledger Account | CHAR | 1 | 0 | GLACCOUNT_TYPE | ||||||||||||
|
|||||||||||||||||
| GLACCOUNT_SUBTYPE | Subtype of a GL Account | CHAR | 1 | 0 | FINS_GLACC_SUBTY | GLACCOUNT_SUBTYPE | |||||||||||
| MAIN_SAKNR | Bank Reconciliation Account | CHAR | 10 | 0 | SKA1 | FINS_MAIN_SAKNR | |||||||||||
| LAST_CHANGED_TS | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TIMESTAMP | ||||||||||||
SKA1 foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| SKA1 | BILKT | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| SKA1 | BILKT | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| SKA1 | BILKT | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| SKA1 | FUNC_AREA | TFKB | Functional areas | FKBER |
| SKA1 | GLACCOUNT_SUBTYPE | FINS_GLACC_SUBTY | GL Account Subtype | GLACCOUNT_TYPE |
| SKA1 | GLACCOUNT_SUBTYPE | FINS_GLACC_SUBTY | GL Account Subtype | GLACCOUNT_SUBTYPE |
| SKA1 | KTOKS | T077S | G/L account groups | MANDT |
| SKA1 | KTOKS | T077S | G/L account groups | KTOPL |
| SKA1 | KTOPL | T004 | Directory of Charts of Accounts | MANDT |
| SKA1 | MAIN_SAKNR | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| SKA1 | MAIN_SAKNR | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| SKA1 | MAIN_SAKNR | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| SKA1 | MUSTR | SKM1 | Sample G/L accounts | MANDT |
| SKA1 | MUSTR | SKM1 | Sample G/L accounts | KTOPL |
| SKA1 | MUSTR | SKM1 | Sample G/L accounts | MUSTR |
| SKA1 | VBUND | T880 | Global Company Data (for KONS Ledger) | MANDT |
| SKA1 | VBUND | T880 | Global Company Data (for KONS Ledger) | RCOMP |