SKAD

Transparent Table Customizing Table

Sachkontenstamm (Kontenplan)

SKAD is an SAP database table in S/4HANA. Sachkontenstamm (Kontenplan). It contains 4 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FAC_CDS_UH_GLACCOUNT view left_outer GLAccount Master Data
I_GLAcctInChartOfAcctsProdn view from BASIC GL Account not needed in production

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY ktopl ktopl Chart of Accts
KEY saknr saknr G/L Account
not_needed fins_glacct_not_needed G/L Account Not Used

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.

-- Sachkontenstamm (Kontenplan)
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SKAD (
    MANDT,       -- Client [mandt]
    KTOPL,       -- Chart of Accts [ktopl]
    SAKNR,       -- G/L Account [saknr]
    NOT_NEEDED,  -- G/L Account Not Used [fins_glacct_not_needed]
    PRIMARY KEY (MANDT, KTOPL, SAKNR)
);