SKAT

Transparent Table Customizing Table
8 Fields 26 CDS Views

G/L Account Master Record (Chart of Accounts: Description)

SKAT is an SAP database table in S/4HANA. G/L Account Master Record (Chart of Accounts: Description). It contains 8 fields. 26 CDS views read from this table.

CDS Views using this table (26)

ViewTypeJoinVDMDescription
CNV_2010C_GL_MAP_ORIG view left_outer GL account mapping view
fac_ppv_cds_ppv_gl_account view left_outer CDS View for PPV account search help
FGL_BCF_PROT view left_outer Balance Carry Forward: Protocol
fgl_lib_txt_skat view from FI LIB: Account texts
fiscds_glacct_01_vh view left_outer GL Account
fiscds_glacct_vh view left_outer GL Account
fiscds_gllit_04 view left_outer GL Line Item (all Ledger)
fiscds_gllit_05 view left_outer GL Line Item (all Ledger)
fisvd_glacct_all view left_outer Master Data GLAccounts
Fisvd_Saknr_Vh view left_outer View for Company Code Dependent G/L Account Value Help
I_BudgetAccountText view from BASIC Budget Account - Text
I_CostElementVH view left_outer BASIC Cost Element Value Help
I_GLAccountText view from BASIC General Ledger Account - Text
I_GLAccountTextRawData view from BASIC General Ledger Account - Text
I_GLAcctTextTP view from TRANSACTIONAL G/L Account Text (Draft 2.0)
I_PRAAccountDescription view_entity inner BASIC PRA GL Account Description
P_AUDIT_AT_SKA1 view left_outer BASIC
P_FinancialStatementLeafItemT view from BASIC
P_FinancialStatementLeafItemT view union_all BASIC
P_FINS_GL_OPENITEM_AMOUNT view inner BASIC
P_GLAcctInDefaultLanguageText view from BASIC
P_GLAcctInDefaultLanguageText view inner BASIC
P_GLAcctInDefaultLanguageText view left_outer BASIC
P_GLAcctTxtInMaintLang view from BASIC
VFCP_DDL_BS view left_outer
VFCP_DDL_FI view left_outer

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY spras SPRAS Language
KEY ktopl KTOPL Chart of Accts
KEY saknr SAKNR G/L Account
txt20 TXT20_SKAT Short Text
txt50 TXT50_SKAT Long Text
mcod1 MCDS1 Long Text
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 Record (Chart of Accounts: Description)
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SKAT (
    MANDT,            -- Client [MANDT]
    SPRAS,            -- Language [SPRAS]
    KTOPL,            -- Chart of Accts [KTOPL]
    SAKNR,            -- G/L Account [SAKNR]
    TXT20,            -- Short Text [TXT20_SKAT]
    TXT50,            -- Long Text [TXT50_SKAT]
    MCOD1,            -- Long Text [MCDS1]
    LAST_CHANGED_TS,  -- Time Stamp [TIMESTAMP]
    PRIMARY KEY (MANDT, SPRAS, KTOPL, SAKNR)
);

Learn More