SKA1 is a standard SAP HANA table in SAP ERP (or) S/4HANA system which stores G/L Account Master (Chart of Accounts) data. There are total 22 fields in the table. The SKA1 table can be found in the Financial Accounting General Services ‘Basis’ (FBASCORE) package and is part of the Financial Accounting (FI) module.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering switched on |
| Buffering Type | Single entries of table were buffered |
SKA1 Table Fields
The following is the list of fields that are available in SAP SKA1 table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type | Length |
|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT | 3 |
| KTOPL | Chart of Accounts | KTOPL | KTOPL | T004 | CHAR | 4 |
| SAKNR | G/L Account Number | SAKNR | SAKNR | CHAR | 10 | |
| XBILK | Indicator: Account is a balance sheet account? | XBILK | XFELD | CHAR | 1 | |
| SAKAN | G/L Account Number, Significant Length | SAKAN | CHAR10 | CHAR | 10 | |
| BILKT | Group Account Number | BILKT | SAKNR | SKA1 | CHAR | 10 |
| ERDAT | Date on which the Record Was Created | ERDAT_RF | DATUM | DATS | 8 | |
| ERNAM | Name of Person who Created the Object | ERNAM_RF | USNAM | CHAR | 12 | |
| GVTYP | P&L statement account type | GVTYP | CHAR2 | CHAR | 2 | |
| KTOKS | G/L Account Group | KTOKS | KTOKS | T077S | CHAR | 4 |
| MUSTR | Number of the Sample Account | MUSTR | MUSTR | SKM1 | CHAR | 10 |
| VBUND | Company ID of Trading Partner | RASSC | RCOMP | T880 | CHAR | 6 |
| XLOEV | Indicator: Account Marked for Deletion? | XLOEV | XFELD | CHAR | 1 | |
| XSPEA | Indicator: Account Is Blocked for Creation ? | XSPEA | XFELD | CHAR | 1 | |
| XSPEB | Indicator: Is Account Blocked for Posting? | XSPEB | XFELD | CHAR | 1 | |
| XSPEP | Indicator: Account Blocked for Planning ? | XSPEP | XFELD | CHAR | 1 | |
| MCOD1 | Search Term for Using Matchcode | MCODF | CHAR25 | CHAR | 25 | |
| FUNC_AREA | Functional Area | FKBER | FKBER | TFKB | CHAR | 16 |
| GLACCOUNT_TYPE | Type of a General Ledger Account | GLACCOUNT_TYPE | GLACCOUNT_TYPE | CHAR | 1 | |
| GLACCOUNT_SUBTYPE | Subtype of a GL Account | GLACCOUNT_SUBTYPE | GLACCOUNT_SUBTYPE | FINS_GLACC_SUBTY | CHAR | 1 |
| MAIN_SAKNR | Bank Reconciliation Account | FINS_MAIN_SAKNR | SAKNR | SKA1 | CHAR | 10 |
| LAST_CHANGED_TS | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | TZNTSTMPS | DEC | 15 |
Availability
The SAP HANA table SKA1 is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Released |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for SKA1 table
We’re updating the content all the time, so check back regularly.