SKA1

Transparent Table Customizing Table
22 Fields 31 CDS Views

G/L Account Master (Chart of Accounts)

SKA1 is an SAP database table in S/4HANA. G/L Account Master (Chart of Accounts). It contains 22 fields. 31 CDS views read from this table.

CDS Views using this table (31)

ViewTypeJoinVDMDescription
ESH_N_GL_ACCOUNT_CCOUNT_MASTER view from G/L Account Master
FAC_AD_CDS_GLACCOUNT view from CDS View for G/L Account(Based on SKA1)
FAC_AlternativeAccount_VH view inner Alternative Account Value Help
FAC_I_GLAcctVH_WL view inner G/L Account SHLP
fac_ppv_cds_ppv_gl_account view inner CDS View for PPV account search help
FCO_MIG_DERIV_P view left_outer CO Delta Entries (COSP+COSS) - Derivation of Dep. Fields
fgl_bcf_acc view inner Balance Carryforward: Acc. Master Data
FGL_BCF_BSACC20 view inner All Balance Sheet Accounts
FGL_BCF_PLACC view inner All P&L Accounts for Balance Carryforward
FGL_BCF_PROT view left_outer Balance Carry Forward: Protocol
FGL_BCF_PURE_PLACC view inner Pure P&L account for bcf
FGL_MIG_SK view inner Master Data for G/L Accounts
Finsv_Drf_Glaccount view inner General Ledger Account for Data Replication
Fisvd_Saknr_Vh view inner View for Company Code Dependent G/L Account Value Help
FJEP_PTE_ACC_DET_SUBACCOUNTS view_entity from Bank Subaccounts
FJEP_PTE_BANK_RECNCLN_ACCT view_entity from Bank Reconcialtion Accounts
I_BankRecnclnAccount view from BASIC Bank Reconciliation Account
I_CarryForwardBudgetAccount view inner BASIC Carry Forward Budget Accounts
I_CashOriginBudgetAccount view inner BASIC Basic View for Cash Origin Accounts in PSM
I_CostElementVH view from BASIC Cost Element Value Help
I_GLAccountInChartOfAccounts view from BASIC G/L Account In Chart Of Accounts
I_GR_GLAcctChartOfAccount view_entity from BASIC Greece G/L Account in Chart of Accounts
I_ProjStkCostElementText view_entity from COMPOSITE Cost Element - Text
P_AUDIT_AT_SKA1 view from BASIC
P_CONSACCINCOA view from BASIC
P_Consacct view from BASIC
P_FinancialStatementLeafItem view from BASIC
P_FinancialStatementLeafItem view union_all BASIC
P_FINS_GL_OPENITEM_AMOUNT view inner BASIC
P_FSLeafWithGLAcctCoA1 view inner BASIC
Skcska_V view from Mass Maintenance: Cost Elements

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ktopl KTOPL Chart of Accts
KEY saknr SAKNR G/L Account
xbilk XBILK Balance sheet acct
sakan SAKAN G/L Account
bilkt BILKT Group Account Number
erdat ERDAT_RF Created On
ernam ERNAM_RF Created by
gvtyp GVTYP P&L state. acct
ktoks KTOKS Account Group
mustr MUSTR Sample Account
vbund RASSC Trading Partner
xloev XLOEV Deletion Flag
xspea XSPEA Creation Block
xspeb XSPEB Posting Block
xspep XSPEP Planning Block
mcod1 MCODF Search Term
func_area FKBER Functional Area
glaccount_type GLACCOUNT_TYPE G/L Account Type
glaccount_subtype GLACCOUNT_SUBTYPE G/L Account Subtype
main_saknr FINS_MAIN_SAKNR Reconciliation Acct
last_changed_ts TIMESTAMP Time Stamp

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- G/L Account Master (Chart of Accounts)
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SKA1 (
    MANDT,              -- Client [MANDT]
    KTOPL,              -- Chart of Accts [KTOPL]
    SAKNR,              -- G/L Account [SAKNR]
    XBILK,              -- Balance sheet acct [XBILK]
    SAKAN,              -- G/L Account [SAKAN]
    BILKT,              -- Group Account Number [BILKT]
    ERDAT,              -- Created On [ERDAT_RF]
    ERNAM,              -- Created by [ERNAM_RF]
    GVTYP,              -- P&L state. acct [GVTYP]
    KTOKS,              -- Account Group [KTOKS]
    MUSTR,              -- Sample Account [MUSTR]
    VBUND,              -- Trading Partner [RASSC]
    XLOEV,              -- Deletion Flag [XLOEV]
    XSPEA,              -- Creation Block [XSPEA]
    XSPEB,              -- Posting Block [XSPEB]
    XSPEP,              -- Planning Block [XSPEP]
    MCOD1,              -- Search Term [MCODF]
    FUNC_AREA,          -- Functional Area [FKBER]
    GLACCOUNT_TYPE,     -- G/L Account Type [GLACCOUNT_TYPE]
    GLACCOUNT_SUBTYPE,  -- G/L Account Subtype [GLACCOUNT_SUBTYPE]
    MAIN_SAKNR,         -- Reconciliation Acct [FINS_MAIN_SAKNR]
    LAST_CHANGED_TS,    -- Time Stamp [TIMESTAMP]
    PRIMARY KEY (MANDT, KTOPL, SAKNR)
);

Learn More