SKA1 is a standard Financial Accounting Transparent Table in SAP FI application, which stores G/L Account Master (Chart of Accounts) 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 SKA1. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

SKA1 — Meta Data

Description: G/L Account Master (Chart of Accounts)
Main Category: FI
Sub Category: Financial Accounting
Table type: Transparent Table (TRANSP)

SKA1 — 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 KTOPL Chart of Accounts X CHAR 4 T004
    3 SAKNR G/L Account X CHAR 10
    4 XBILK Indicator: Account Is a Balance Sheet Account? CHAR 1
    5 SAKAN G/L account number, significant length CHAR 10
    6 .INCLUDE 0
    7 BILKT Group Account Number CHAR 10 SKA1
    8 ERDAT Created on DATS 8
    9 ERNAM Created by CHAR 12
    10 GVTYP P&L Statement Account Type CHAR 2
    11 KTOKS G/L account group CHAR 4 T077S
    12 MUSTR Number of the sample account CHAR 10 SKM1
    13 VBUND Trading Partner CHAR 6 T880
    14 XLOEV Indicator: Account marked for deletion? CHAR 1
    15 XSPEA Indicator: account is blocked for creation ? CHAR 1
    16 XSPEB Indicator: Block account for posting? CHAR 1
    17 XSPEP Indicator: account blocked for planning ? CHAR 1
    18 MCOD1 Search term for matchcode search CHAR 25
    19 FUNC_AREA Functional Area CHAR 16 TFKB
    20 GLACCOUNT_TYPE CHAR 1
    21 LAST_CHANGED_TS UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15

SAP Help, Wiki Resources, and Forum Discussions on SKA1

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
SKB1 G/L account master (company code) FI - Basic Functions
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
T001 Company Codes FI - Financial Accounting
CSKS Cost Center Master Data CO - Controlling
BSAS Accounting: Secondary Index for G/L Accounts (Cleared Items) FI - Financial Accounting

Transaction Codes for SAP Table SKA1

TCODE Description Functional Area
FS00 G/L acct master record maintenance FI - Basic Functions
CEPC Display Table CEPC EC - Profit Center Accounting
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
SLIS FI-SL Spec.Purpose Ledg. Info.System FI - Information System
SE16 Data Browser Basis - Workbench Utilities
CSKB Start order Browser LO - Bills of Material
SE38 ABAP Editor Basis - ABAP Editor
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance

FMs for SAP Table SKA1

FM Description Functional Area
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer
REUSE_ALV_FIELDCATALOG_MERGE Create field catalog from dictionary structure or internal table BC - SAP List Viewer
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer
GUI_DOWNLOAD Download an Internal Table to the PC Basis - Graphical User Interface
CONVERSION_EXIT_ALPHA_INPUT Conversion exit ALPHA, external->internal Basis - Syntax, Compiler, Runtime
F4_FILENAME F4 for filename / Filemanager support to locate file in a directory PM - Plant Maintenance

ABAP Reports for SAP Table SKA1

ABAP REPORT Description Functional Area
RFITEMGL G/L Account Line Item Display FI - Information System
RFBIBL00 Batch Input Documents FI - Financial Accounting
RFBILA00 Financial Statements FI - Financial Accounting
SAPMF02H ?... FI - Basic Functions
BDCRECX1 Include f Basis - UI Services, Screen, Batch Input
RFBISA00 Interface for General Ledger Account Master Data FI - Basic Functions
KONTO Program for Object Type BUS3014: Account FI - Financial Accounting
RECON Include RECON PP - Material Identification and Reconciliation

BW Datasources for SAP Table SKA1

BW DATASOURCE Description Functional Area
0GL_ACCOUNT_ATTR G/L Account Number FI - Financial Accounting
0GL_ACCOUNT_T011_HIER G/L account number FI - Financial Accounting
0FI_GL_4 General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting
0FI_AR_4 Customers: Line Items with Delta Extraction FI - Accounts Receivable
2LIS_03_UM Revaluations MM - Materials Management
2LIS_02_ITM Purchasing Data (Item Level) MM - Materials Management
2LIS_03_BX Stock Initialization for Inventory Management MM - Materials Management
0EC_PCA_1 Profit Center: Transaction Data on Accounts Enterprice Controlling - Profit Center Accounting

Authorization Objects for SAP Table SKA1

AUTHORIZATION OBJECT Description Functional Area
F_SKA1_BUK G/L Account: Authorization for Company Codes
F_BKPF_BES Accounting Document: Account Authorization for G/L Accounts
E_GRID Authorization Object for Grid
C_EKORG Transfer of Purchasing Organization Data
F_BKPF_KOA Accounting Document: Authorization for Account Types
F_BKPF_BUK Accounting Document: Authorization for Company Codes
P_TCODE HR: Transaction codes
F_SKA1_BES G/L Account: Account Authorization