SAP Table SKA1

G/L Account Master (Chart of Accounts)

SKA1 (G/L Account Master (Chart of Accounts)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link SKA1 to other SAP tables.

SKA1 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KTOPL Chart of Accounts KTOPL T004 CHAR 4 0
SAKNR G/L Account Number SAKNR CHAR 10 0
XBILK Indicator: Account is a balance sheet account? XBILK CHAR 1 0
X Yes
NULL No
SAKAN G/L account number, significant length SAKAN CHAR 10 0
BILKT Group Account Number BILKT SKA1 CHAR 10 0
ERDAT Date on which the Record Was Created ERDAT_RF DATS 8 0
ERNAM Name of Person who Created the Object ERNAM_RF CHAR 12 0
GVTYP P&L statement account type GVTYP CHAR 2 0
KTOKS G/L Account Group KTOKS T077S CHAR 4 0
MUSTR Number of the sample account MUSTR SKM1 CHAR 10 0
VBUND Company ID of trading partner RASSC T880 CHAR 6 0
XLOEV Indicator: Account marked for deletion? XLOEV CHAR 1 0
X Yes
NULL No
XSPEA Indicator: account is blocked for creation ? XSPEA CHAR 1 0
X Yes
NULL No
XSPEB Indicator: Is Account Blocked for Posting? XSPEB CHAR 1 0
X Yes
NULL No
XSPEP Indicator: account blocked for planning ? XSPEP CHAR 1 0
X Yes
NULL No
MCOD1 Search Term for Using Matchcode MCODF CHAR 25 0
FUNC_AREA Functional Area FKBER TFKB CHAR 16 0

SKA1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SKA1 BILKT SKA1 MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
SKA1 BILKT T004 KKTPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
SKA1 BILKT SKA1 BILKT SKA1 G/L Account Master (Chart of Accounts) SAKNR
SKA1 FUNC_AREA SKA1 MANDT TFKB Functional areas MANDT
SKA1 FUNC_AREA SKA1 FUNC_AREA TFKB Functional areas FKBER
SKA1 KTOKS SKA1 KTOKS T077S G/L account groups KTOKS
SKA1 KTOKS SKA1 MANDT T077S G/L account groups MANDT
SKA1 KTOKS SKA1 KTOPL T077S G/L account groups KTOPL
SKA1 KTOPL SKA1 MANDT T004 Directory of Charts of Accounts MANDT
SKA1 KTOPL SKA1 KTOPL T004 Directory of Charts of Accounts KTOPL
SKA1 MANDT SKA1 MANDT T000 Clients MANDT
SKA1 MUSTR SKA1 MANDT SKM1 Sample G/L accounts MANDT
SKA1 MUSTR SKA1 KTOPL SKM1 Sample G/L accounts KTOPL
SKA1 MUSTR SKA1 MUSTR SKM1 Sample G/L accounts MUSTR
SKA1 VBUND SKA1 MANDT T880 Global Company Data (for KONS Ledger) MANDT
SKA1 VBUND SKA1 VBUND T880 Global Company Data (for KONS Ledger) RCOMP