SKB1 is a standard Basic Functions Transparent Table in SAP FI application, which stores G/L account master (company code) data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for SKB1. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

SKB1 — Meta Data

Description: G/L account master (company code)
Main Category: FI
Sub Category: Basic Functions
Table type: Transparent Table (TRANSP)

SKB1 — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3 T000
    2 BUKRS Company Code X CHAR 4 T001
    3 SAKNR G/L Account X CHAR 10 SKA1
    4 BEGRU Authorization Group CHAR 4
    5 BUSAB Accounting clerk CHAR 2 T001S
    6 DATLZ Date of the last interest calculation run DATS 8
    7 ERDAT Created on DATS 8
    8 ERNAM Created by CHAR 12
    9 FDGRV Planning group CHAR 10 T035
    10 FDLEV Planning Level CHAR 2 T036
    11 FIPLS Financial budget item NUMC 3
    12 FSTAG Field status group CHAR 4 T004F
    13 HBKID Short key for a house bank CHAR 5 T012
    14 HKTID ID for Account Details CHAR 5 T012K
    15 KDFSL Key for exchange rate differences in foreign currency accts CHAR 4 T030S
    16 MITKZ Account is reconciliation account CHAR 1
    17 MWSKZ Tax code CHAR 2
    18 STEXT Organizational Unit Name CHAR 50
    19 VZSKZ Interest Calculation Indicator CHAR 2 T056
    20 WAERS Currency CUKY 5 TCURC
    21 WMETH Indicator: account managed in external system CHAR 2
    22 XGKON Cash receipt account / cash disbursement account CHAR 1
    23 XINTB Indicator: Is account only posted to automatically? CHAR 1
    24 XKRES Indicator: Can Line Items Be Displayed by Account? CHAR 1
    25 XLOEB Character field of length 1 CHAR 1
    26 XNKON Indicator: Supplement for automatic postings ? CHAR 1
    27 XOPVW OI management CHAR 1
    28 XSPEB Indicator: Block account for posting? CHAR 1
    29 ZINDT Key Date of Last Interest Calculation DATS 8
    30 ZINRT Version Number Component NUMC 2
    31 ZUAWA Key for sorting according to assignment numbers CHAR 3 TZUN
    32 ALTKT Group Account Number CHAR 10
    33 XMITK Indicator: Reconcil.acct ready for input at time of posting? CHAR 1
    34 RECID Recovery Indicator CHAR 2 T8JJ
    35 FIPOS Commitment Item CHAR 14
    36 XMWNO Indicator: Tax code is not a required field CHAR 1
    37 XSALH Indicator: Only manage balances in local currency CHAR 1
    38 BEWGP Evaluation group CHAR 10
    39 INFKY Inflation key - G/L account CHAR 8 J_1AINFSKS
    40 TOGRU Tolerance Group for G/L Accounts CHAR 4 T043S
    41 XLGCLR LdgrGrp-SpecClearing CHAR 1
    42 MCAKEY MCA Key CHAR 5 GLE_MCA_TMCAKEY
    43 COCHANGED CHAR 1
    44 LAST_CHANGED_TS UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15

SAP Help, Wiki Resources, and Forum Discussions on SKB1

Click the above link for the full list of resources and help pages, only the first few are posted below


Related Tables

TABLE Description Functional Area
SKA1 G/L Account Master (Chart of Accounts) FI - Financial Accounting
BSEG Accounting Document Segment FI - Financial Accounting
BSIS Accounting: Secondary Index for G/L Accounts FI - Financial Accounting
SKAT G/L Account Master Record (Chart of Accounts: Description) FI - Financial Accounting
BSAS Accounting: Secondary Index for G/L Accounts (Cleared Items) FI - Financial Accounting
BSID Accounting: Secondary Index for Customers FI - Financial Accounting
BSIK Accounting: Secondary Index for Vendors FI - Financial Accounting

Transaction Codes for SAP Table SKB1

TCODE Description Functional Area
FS00 G/L acct master record maintenance FI - Basic Functions
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
CEPC Display Table CEPC EC - Profit Center Accounting
SE16 Data Browser Basis - Workbench Utilities
FBL3N G/L Account Line Items FI - Information System
CSKB Start order Browser LO - Bills of Material
FB01 Post Document FI - Financial Accounting
MIRO Enter Incoming Invoice MM - Invoice Verification

FMs for SAP Table SKB1

FM Description Functional Area
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
CONVERSION_EXIT_ALPHA_INPUT Conversion exit ALPHA, external->internal Basis - Syntax, Compiler, Runtime
SAPGUI_PROGRESS_INDICATOR Display progress indicator in current window C - Graphical User Interface
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer
READ_TEXT SAPscript: Read text BC - SAPscript
BAPI_ACC_DOCUMENT_POST Accounting: Posting Accounting - Accounting Interface

ABAP Reports for SAP Table SKB1

ABAP REPORT Description Functional Area
RECON Include RECON PP - Material Identification and Reconciliation
RFBIBL00 Batch Input Documents FI - Financial Accounting
RFITEMGL G/L Account Line Item Display FI - Information System
RFSEPA01 Switch On Line Item Display by Changing Master Record FI - Financial Accounting
RFBILA00 Financial Statements FI - Financial Accounting
RFSEPA02 Switch On Open Item Management by Changing Master Record FI - Financial Accounting
RFBISA00 Interface for General Ledger Account Master Data FI - Basic Functions
SAPF100 Foreign Currency Valuation FI - Financial Accounting

BW Datasources for SAP Table SKB1

BW DATASOURCE Description Functional Area
0GL_ACCOUNT_ATTR G/L Account Number FI - Financial Accounting
0FI_AR_4 Customers: Line Items with Delta Extraction FI - Accounts Receivable
0FI_GL_4 General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting
2LIS_02_ITM Purchasing Data (Item Level) MM - Materials Management
0FI_AP_4 Vendors: Line Items with Delta Extrcation FI - Accounts Payable
0GL_ACCOUNT_COCD_ATTR G/L Account: Company Code-Dependent Attributes FI - Financial Accounting
0CO_OM_NWA_1 Network Activity: Costs CO - Overhead Projects
0EC_PCA_1 Profit Center: Transaction Data on Accounts Enterprice Controlling - Profit Center Accounting

Authorization Objects for SAP Table SKB1

AUTHORIZATION OBJECT Description Functional Area
I_TCODE PM: Transaction Code
F_BKPF_BES Accounting Document: Account Authorization for G/L Accounts
F_BKPF_KOA Accounting Document: Authorization for Account Types
J_1IEWTCER Authorization check for Certificate Printing- EWT
M_MATE_STA Material Master: Maintenance Statuses
F_BKPF_BEK Accounting Document: Account Authorization for Vendors
K_PCA EC-PCA: Responsibility Area, Profit Center
F_SKA1_BUK G/L Account: Authorization for Company Codes