SAP TABLES | Financial Accounting | General Ledger Accounting | Basic Functions(FI-GL-GL) SAP FI

SKB1 SAP G/L account master (company code) Table and data







SKB1 is a standard SAP Table which is used to store G/L account master (company code) 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 SKB1 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 or numeric)
See here for more information about this and other SAP enhancement categories

==>View Table relationships


SAP SKB1 Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
BUKRSBUKRSCHAR4 T001Company Code
SAKNRSAKNRCHAR10 SKA1G/L Account NumberALPHA
BEGRUBRGRUCHAR4
*
Authorization Group
BUSABBUSABCHAR2 T001SAccounting clerk
DATLZDATLZDATS8 Date of the last interest calculation run
ERDATERDAT_RFDATS8 Date on which the Record Was Created
ERNAMERNAM_RFCHAR12 Name of Person who Created the Object
FDGRVFDGRVCHAR10 T035Planning groupALPHA
FDLEVFDLEVCHAR2 T036Planning level
FIPLSFIPLSNUMC3 Financial Budget Item
FSTAGFSTAGCHAR4 T004FField status group
HBKIDHBKIDCHAR5 T012Short Key for a House Bank
HKTIDHKTIDCHAR5 T012KID for account details
KDFSLKDFSLCHAR4 T030SKey for Exchange Rate Differences in Foreign Currency Accts
MITKZMITKZCHAR1 Account is reconciliation account
MWSKZSMWSKCHAR2 Tax Category in Account Master Record
STEXTSTEXT_SKB1CHAR50 G/L account additional text
VZSKZVZSKZCHAR2 T056Interest calculation indicator
WAERSWAERS_SKB1CUKY5 TCURCAccount currency
WMETHWMETHCHAR2 Indicator: account managed in external system
XGKONXGKONCHAR1 Cash receipt account / cash disbursement account
XINTBXINTBCHAR1 Indicator: Is account only posted to automatically?
XKRESXKRESCHAR1 Indicator: Can Line Items Be Displayed by Account?
XLOEBXLOEVCHAR1 Indicator: Account marked for deletion?
XNKONXNKONCHAR1 Indicator: Supplement for automatic postings ?
XOPVWXOPVWCHAR1 Indicator: Open item management?
XSPEBXSPEBCHAR1 Indicator: Is Account Blocked for Posting?
ZINDTDZINDTDATS8 Key date of the last interest calculation



ZINRTDZINRTNUMC2 Interest calculation frequency in months
ZUAWADZUAWACHAR3 TZUNKey for sorting according to assignment numbers
ALTKTALTKT_SKB1CHAR10
*
Alternative account number in company codeALPHA
XMITKXMITKCHAR1 Indicator: Reconcil.acct ready for input at time of posting?
RECIDJV_RECINDCHAR2 T8JJRecovery IndicatorALPHA
FIPOSFIPOSCHAR14
*
Commitment ItemFMCIS
XMWNOXMWNOCHAR1 Indicator: Tax code is not a required field
XSALHXSALHCHAR1 Indicator: Only Manage Balances in Local Currency
BEWGPBEWGPCHAR10 Valuation Group
INFKYJ_1AIFSKSCHAR8 J_1AINFSKSInflation Key
TOGRUTOGRU_SCHAR4 T043STolerance Group for G/L Accounts
XLGCLRXLGCLRCHAR1 Clearing Specific to Ledger Groups
MCAKEYGLE_DTE_MCA_MCAKEYCHAR5 GLE_MCA_TMCAKEYMCA Key



Key field
Non-key field

SKB1 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