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 | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||
|
||||||||||||
|
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 | ||||||||
|
||||||||||||
|
XSPEA
Indicator: account is blocked for creation ?
|
XSPEA |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
XSPEB
Indicator: Is Account Blocked for Posting?
|
XSPEB |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
XSPEP
Indicator: account blocked for planning ?
|
XSPEP |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
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 |