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 |
Possible values
|
||||||
| 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 |
Possible values
|
||||||
| XSPEA | Indicator: account is blocked for creation ? | XSPEA | CHAR | 1 | 0 |
Possible values
|
||||||
| XSPEB | Indicator: Is Account Blocked for Posting? | XSPEB | CHAR | 1 | 0 |
Possible values
|
||||||
| XSPEP | Indicator: account blocked for planning ? | XSPEP | CHAR | 1 | 0 |
Possible values
|
||||||
| 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 | MANDT | T077S | G/L account groups | MANDT |
| SKA1 | KTOKS | SKA1 | KTOPL | T077S | G/L account groups | KTOPL |
| SKA1 | KTOKS | SKA1 | KTOKS | T077S | G/L account groups | KTOKS |
| SKA1 | KTOPL | SKA1 | KTOPL | T004 | Directory of Charts of Accounts | KTOPL |
| SKA1 | KTOPL | SKA1 | MANDT | T004 | Directory of Charts of Accounts | MANDT |
| 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 |
