SKA1 table in SAP ERP or S/4HANA stores G/L Account Master (Chart of Accounts) data. There are total 22 fields in SKA1 table. The G/L Account Master (Chart of Accounts) table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of SKA1 table. It is in Financial Accounting General Services ‘Basis’ (FBASCORE) ABAP package and is part of the Financial Accounting (FI) module.
SAP SKA1 Table Fields
Following is the list of fields that are available in SAP SKA1 table. The primary key fields of G/L Account Master (Chart of Accounts) table in SAP are MANDT (Client), KTOPL (Chart of Accounts), SAKNR (G/L Account Number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT(3) |
| KTOPL | Chart of Accounts | KTOPL | T004 | CHAR(4) |
| SAKNR | G/L Account Number | SAKNR | CHAR(10) | |
| XBILK | Indicator: Account is a balance sheet account? | XBILK | CHAR(1) | |
| SAKAN | G/L Account Number, Significant Length | SAKAN | CHAR(10) | |
| BILKT | Group Account Number | BILKT | SKA1 | CHAR(10) |
| ERDAT | Date on which the Record Was Created | ERDAT_RF | DATS(8) | |
| ERNAM | Name of Person who Created the Object | ERNAM_RF | CHAR(12) | |
| GVTYP | P&L statement account type | GVTYP | CHAR(2) | |
| KTOKS | G/L Account Group | KTOKS | T077S | CHAR(4) |
| MUSTR | Number of the Sample Account | MUSTR | SKM1 | CHAR(10) |
| VBUND | Company ID of Trading Partner | RASSC | T880 | CHAR(6) |
| XLOEV | Indicator: Account Marked for Deletion? | XLOEV | CHAR(1) | |
| XSPEA | Indicator: Account Is Blocked for Creation ? | XSPEA | CHAR(1) | |
| XSPEB | Indicator: Is Account Blocked for Posting? | XSPEB | CHAR(1) | |
| XSPEP | Indicator: Account Blocked for Planning ? | XSPEP | CHAR(1) | |
| MCOD1 | Search Term for Using Matchcode | MCODF | CHAR(25) | |
| FUNC_AREA | Functional Area | FKBER | TFKB | CHAR(16) |
| GLACCOUNT_TYPE | Type of a General Ledger Account | GLACCOUNT_TYPE | CHAR(1) | |
| GLACCOUNT_SUBTYPE | Subtype of a GL Account | GLACCOUNT_SUBTYPE | FINS_GLACC_SUBTY | CHAR(1) |
| MAIN_SAKNR | Bank Reconciliation Account | FINS_MAIN_SAKNR | SKA1 | CHAR(10) |
| LAST_CHANGED_TS | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC(15) |
