SAP table 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're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KTOPL Chart of Accounts CHAR 4 0 T004 KTOPL
SAKNR 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
C Cash Account
N Nonoperating Expense or Income
P Primary Costs or Revenue
S Secondary Costs
X Balance Sheet Account
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 key relationships

Table Field Check Table Check Field
0 SKA1 BILKT SKA1 G/L Account Master (Chart of Accounts) MANDT
0 SKA1 BILKT SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 SKA1 BILKT SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 SKA1 FUNC_AREA TFKB Functional areas FKBER
0 SKA1 GLACCOUNT_SUBTYPE FINS_GLACC_SUBTY GL Account Subtype GLACCOUNT_TYPE
0 SKA1 GLACCOUNT_SUBTYPE FINS_GLACC_SUBTY GL Account Subtype GLACCOUNT_SUBTYPE
1 SKA1 KTOKS T077S G/L account groups MANDT
1 SKA1 KTOKS T077S G/L account groups KTOPL
0 SKA1 KTOPL T004 Directory of Charts of Accounts MANDT
1 SKA1 MAIN_SAKNR SKA1 G/L Account Master (Chart of Accounts) MANDT
1 SKA1 MAIN_SAKNR SKA1 G/L Account Master (Chart of Accounts) KTOPL
1 SKA1 MAIN_SAKNR SKA1 G/L Account Master (Chart of Accounts) SAKNR
0 SKA1 MUSTR SKM1 Sample G/L accounts MANDT
0 SKA1 MUSTR SKM1 Sample G/L accounts KTOPL
0 SKA1 MUSTR SKM1 Sample G/L accounts MUSTR
1 SKA1 VBUND T880 Global Company Data (for KONS Ledger) MANDT
1 SKA1 VBUND T880 Global Company Data (for KONS Ledger) RCOMP