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]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,   -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    PRIMARY KEY (MANDT, DRAFTUUID)
);