SAP TABLES | Financial Accounting(FI) SAP FI

SKA1 SAP G/L Account Master (Chart of Accounts) Table and data







SKA1 is a standard SAP Table which is used to store G/L Account Master (Chart of Accounts) data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP SKA1 Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: C - Customizing table, Maintenance only by customer and not updated by SAP import

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type)
See here for more information about this and other SAP enhancement categories

Text table = SKAT

==>View Table relationships


SAP SKA1 Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
KTOPLKTOPLCHAR4 T004Chart of Accounts
SAKNRSAKNRCHAR10 G/L Account NumberALPHA
XBILKXBILKCHAR1 Indicator: Account is a balance sheet account?
SAKANSAKANCHAR10 G/L account number, significant length
.INCLUDESI_SKA1 G/L Account Master Record (Chart of Accounts)
BILKTBILKTCHAR10 SKA1Group Account NumberALPHA
ERDATERDAT_RFDATS8 Date on which the Record Was Created
ERNAMERNAM_RFCHAR12 Name of Person who Created the Object
GVTYPGVTYPCHAR2 P&L statement account type
KTOKSKTOKSCHAR4 T077SG/L Account Group
MUSTRMUSTRCHAR10 SKM1Number of the sample accountALPHA
VBUNDRASSCCHAR6 T880Company ID of trading partnerALPHA
XLOEVXLOEVCHAR1 Indicator: Account marked for deletion?
XSPEAXSPEACHAR1 Indicator: account is blocked for creation ?
XSPEBXSPEBCHAR1 Indicator: Is Account Blocked for Posting?
XSPEPXSPEPCHAR1 Indicator: account blocked for planning ?
MCOD1MCODFCHAR25 Search Term for Using Matchcode
FUNC_AREAFKBERCHAR16 TFKBFunctional Area



Key field
Non-key field

SKA1 relationships with other tables


BOSG-Uppermost Hierarchy Segment for BRF
     BKPF-Accounting Document Header
          BSEG-Accounting Document Segment
          BSET-Tax Data Document Segment
          FAGLFREESEL-General Ledger: Custom Selections (Enhanced)
     KNA1-General Data in Customer Master
          KNBK-Customer Master (Bank Details)
          KNB1-Customer Master (Company Code)
               KNB4-Customer Payment History
               KNB5-Customer Master (Dunning Data)
               KNKK-Credit Management Cust. Mstr: Control Area Data
               KNC1-Customer Master (Transaction Figures)
               KNC3-Customer Master (Special G/L Transaction Figures)
     LFA1-Vendor Master (General Section)
          LFBK-Vendor Master (Bank Details)
          LFB1-Vendor Master (Company Code)
               LFB5-Vendor Master (Dunning Data)
               LFC1-Vendor Master (Transaction Figures)
               LFC3-Vendor Master (Transaction Figures) Special Ledger
     SKA1-G/L Account Master Record (Chart of Accounts)
          SKB1-G/L Account Master Record (Company Code)
               SKC1A-G/L Sales Segment Derived from GLDB - Internal
               SKC1C-G/L Account C-Segment from GLT0 -Currency Amounts-


SKA1-G/L Account Master Record (Chart of Accounts)
     SKB1-G/L Account Master Record (Company Code)
          GLU3-FI-SL Drilldown: Structure with All Field Used


SKA1-G/L Account Master Record (Chart of Accounts)
     SKB1-G/L Account Master Record (Company Code)
          SKC1A-G/L Sales Segment Derived from GLDB - Internal
          SKC1C-G/L Account C-Segment from GLT0 -Currency Amounts-
          FAGLFREESEL-General Ledger: Custom Selections (Enhanced)
          BSIS-Accounting: Secondary Index for G/L Accounts
               ADMI_FILES-Archive Files
               BSISEXT-Secondary Index & Additions Section (BSEGA)
               BKPF-Accounting Document Header
                    BSEG-Accounting Document Segment
                         GSEG-Offsetting Items for B-Segment in Reporting