SAP Table SKA1
G/L Account Master (Chart of Accounts)
What Is the SAP SKA1 Table?
SKA1 is an SAP Financial Accounting table that stores General Ledger Accounting master data at the chart of accounts level. It contains the common information that is shared by all the company codes using same chart of accounts, such as G/L account number, account group, Balance Sheet or Profit & Loss account type, account type, group account number and blocking indicators.
In SAP, Each G/L account master record is divided into two main levels:
- Chart of accounts area level – SKA1
- Company Code level – SKB1
The language-dependent G/L account descriptions are stored in the SKAT table.
SAP FI Consultants, users and support team uses the SKA1 table to analyse the G/L Account master data, identify balance sheets and Profit & Loss accounts, troubleshoot general ledger master data configuration related issues.
Quick overview
| SAP table | SKA1 |
|---|---|
| Short description | G/L Account Master (Chart of Accounts) |
| Table type | Transparent table |
| Primary key | MANDT (Client), KTOPL (Chart of Accounts), SAKNR (G/L Account Number) |
| Client-dependent | Yes |
| Commonly used fields | KTOPL (Chart of Accounts), SAKNR (G/L Account Number), XBILK (Indicator: Account is a balance sheet account?), KTOKS (G/L Account Group), GVTYP (P&L statement account type) |
Important fields explained
| Field | SAP field description | What this field means |
|---|---|---|
KTOPL |
Chart of Accounts | Chart of accounts to which the G/L account belongs. |
SAKNR |
G/L Account Number | G/L account number in the chart of accounts. |
XBILK |
Indicator: Account is a balance sheet account? | Indicates whether the G/L account is a balance sheet account. |
BILKT |
Group Account Number | Group account number used when a group chart of accounts is assigned to the operating chart of accounts. |
GVTYP |
P&L statement account type | Specifies the P&L statement account type used to determine the retained earnings account during balance carryforward. |
KTOKS |
G/L Account Group | Account group to which the G/L account belongs. |
GLACCOUNT_TYPE |
Type of a General Ledger Account | Classifies the G/L account by account type. |
At a glance
- Module
- Financial Accounting FI
Technical details
- Delivery class
- C (Customizing, maintenance only by customer, no SAP imports)
- Data class
- APPL0 (Master Data, Transparent Tables)
- Package
- Payments: General Services (FBASCORE)
Primary key fields
| Field | Description | Data element | Type | Length |
|---|---|---|---|---|
MANDT
|
Client | MANDT | CLNT | 3 |
KTOPL
|
Chart of Accounts | KTOPL | CHAR | 4 |
SAKNR
|
G/L Account Number | SAKNR | CHAR | 10 |
Table fields
22 fields
22 fields
| Field | Description | Data element | Domain | Type | Length | Decimals | Check table |
|---|---|---|---|---|---|---|---|
MANDT
Key
|
Client | MANDT | MANDT | CLNT | 3 | — | T000 |
KTOPL
Key
|
Chart of Accounts | KTOPL | KTOPL | CHAR | 4 | — | T004 |
SAKNR
Key
|
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 | CHAR | 10 | — | SKA1 |
ERDAT
|
Record Created On | 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 | CHAR | 4 | — | T077S |
MUSTR
|
Number of the Sample Account | MUSTR | MUSTR | CHAR | 10 | — | SKM1 |
VBUND
|
Company ID of Trading Partner | RASSC | RCOMP | CHAR | 6 | — | T880 |
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 | CHAR | 16 | — | TFKB |
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 | CHAR | 1 | — | FINS_GLACC_SUBTY |
MAIN_SAKNR
|
Bank Reconciliation Account | FINS_MAIN_SAKNR | SAKNR | CHAR | 10 | — | SKA1 |
LAST_CHANGED_TS
|
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 |
No fields match the selected filters.
SAP SKA1 Table Availability
| SAP product | Verified release/system | Table availability | Verified on |
|---|---|---|---|
| SAP S/4HANA | 2023 - On-Premise - Initial Shipment Stack | Available |
Related SAP Tables
| Table | Description | Common Key Fields with SKA1 |
|---|---|---|
| SKAS | G/L account master (chart of accounts: key word list) | MANDT, KTOPL, SAKNR |
| SKB1 | G/L account master (company code) | MANDT, SAKNR |
| SKAT | G/L Account Master Record (Chart of Accounts: Description) | MANDT, KTOPL, SAKNR |
| T004 | Directory of Charts of Accounts | MANDT, KTOPL |
Fields marked as primary keys in both tables. Additional fields or filters may be needed when joining records.
Editorial and verification
- Content editor
- ERPSAP Content Team
- Technical reviewer
- ERPSAP Technical Review Team
- Verified against
- SAP S/4HANA 2023 On-Premise system
- Last updated
- October 6, 2026
The information on this SAP SKA1 table page is based on the verified SAP S/4HANA 2023 on-premise system identified above. Table definitions, fields, and availability may differ across SAP releases and customer-specific systems.