SKA1_DRAFT_20

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.

-- I_GLACCTINCHTACCTSTP I_GLACCTINCHTACCTSTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SKA1_DRAFT_20 (
    MANDT,                          -- Client [mandt]
    DRAFTUUID,                      -- Key [/bobf/uuid]
    CHARTOFACCOUNTS,                -- Chart of Accts [ktopl]
    GLACCOUNT,                      -- G/L Account [saknr]
    CHARTOFACCOUNTSFOREDIT,         -- Chart of Accts [ktopl]
    GLACCOUNTFOREDIT,               -- G/L Account [saknr]
    ISBALANCESHEETACCOUNT,          -- Balance sheet acct [xbilk]
    GLACCOUNTGROUP,                 -- Account Group [ktoks]
    CORPORATEGROUPACCOUNT,          -- Group Account Number [bilkt]
    PROFITLOSSACCOUNTTYPE,          -- P&L state. acct [gvtyp]
    SAMPLEGLACCOUNT,                -- Sample Account [mustr]
    ACCOUNTISMARKEDFORDELETION,     -- Deletion Flag [xloev]
    ACCOUNTISBLOCKEDFORCREATION,    -- Creation Block [xspea]
    ACCOUNTISBLOCKEDFORPOSTING,     -- Posting Block [xspeb]
    ACCOUNTISBLOCKEDFORPLANNING,    -- Planning Block [xspep]
    PARTNERCOMPANY,                 -- Trading Partner [rassc]
    FUNCTIONALAREA,                 -- Functional Area [fkber]
    CREATIONDATE,                   -- Created On [erdat_rf]
    CREATEDBYUSER,                  -- Created by [ernam_rf]
    GLACCOUNTTYPE,                  -- G/L Account Type [glaccount_type]
    GLACCOUNTSUBTYPE,               -- G/L Account Subtype [glaccount_subtype]
    BANKRECONCILIATIONACCOUNT,      -- Reconciliation Acct [fins_main_saknr]
    GLACCOUNTEXTERNAL,              -- G/L Acct External ID [fac_sakan]
    GLACCOUNTISNOTPRODNRELEVANT,    -- G/L Account Not Used [fins_glacct_not_needed]
    GLACCTCOAIMPLEMENTSTATUS,       -- Implement. Status [glaccount_imst]
    GLACCOUNTCOAISDELIVEREDBYSAP,   -- Source is Ref. Cont. [glaccount_srcisrefcnt]
    MAINTENANCELANGUAGE,            -- Maint. Language [spras_004]
    DRAFTREFERENCECHARTOFACCOUNTS,  -- Chart of Accts [ktopl]
    DRAFTREFERENCEGLACCOUNT,        -- G/L Account [saknr]
    GLACCOUNTNAME,                  -- Short Text [txt20_skat]
    GLACCOUNTLONGNAME,              -- Long Text [txt50_skat]
    CORPORATEGROUPCHARTOFACCOUNTS,  -- Group ChtAccts [kktpl]
    CORPORATEGROUPACCOUNTEXTERNAL,  -- G/L Account [sakan]
    HASACTIVEENTITY,                -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);