STKO_DRAFT

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.

-- Draft Data for BillOfMaterial Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE STKO_DRAFT (
    MANDT,                         -- Client [mandt]
    DRAFTUUID,                     -- Draft (Technical ID) [sdraft_key]
    BILLOFMATERIALHEADERUUID,      -- Guid [cs_guidb]
    BILLOFMATERIALUUID,            -- Character Field of Length 12 [char12]
    ISACTIVEENTITY,                -- Is active [sdraft_is_active]
    HASACTIVEENTITY,               -- Has active [sdraft_has_active]
    HASDRAFTENTITY,                -- Has Draft [sdraft_has_draft]
    MATERIAL,                      -- Material [matnr]
    PLANT,                         -- Plant [werks_d]
    BILLOFMATERIALVARIANTUSAGE,    -- Usage [stlan]
    BILLOFMATERIALCATEGORY,        -- BOM category [stlty]
    BILLOFMATERIAL,                -- BOM [stnum]
    BILLOFMATERIALVARIANT,         -- Alternative [stalt]
    MATFROMLOTSIZEQUANTITY,        -- From Lot Size [losvn]
    MATTOLOTSIZEQUANTITY,          -- To Lot Size [losbs]
    ISMULTIPLEBOMALT,              -- Alt.det. MBOM [x415a]
    BOMHEADERINTERNALCHANGECOUNT,  -- Counter [cim_count]
    ISCONFIGUREDMATERIAL,          -- Configured matl [cslty]
    BOMPRIORITIZEDVERSION,         -- Selection ID [cslid]
    BOMEXPLOSIONAPPLICATION,       -- BOM Application [capid]
    BOMUSAGEPRIORITY,              -- Sel. priority [cslpr]
    BILLOFMATERIALAUTHSNGRP,       -- Auth group [stlbe]
    BOMTECHNICALTYPE,              -- Tech type [tetyp_d]
    BOMHEADERTEXT,                 -- BOM Description [cstext]
    BOMALTERNATIVETEXT,            -- Alt Text [stktx]
    BILLOFMATERIALSTATUS,          -- BOM Status [stlst]
    HEADERVALIDITYSTARTDATE,       -- Valid From [datuv]
    HEADERVALIDITYENDDATE,         -- to [datub]
    ENGINEERINGCHANGEDOCUMENT,     -- Change Number [aennr]
    CHGTOENGINEERINGCHGDOCUMENT,   -- Change No. To [aenra]
    ISMARKEDFORDELETION,           -- Deletion Ind. [lkenz]
    DOCUMENTISCREATEDBYCAD,        -- CAD Indicator [cadkz]
    LABORATORYORDESIGNOFFICE,      -- Lab/Office [labor]
    ISALE,                         -- ALE indicator [cs_alekz]
    BOMHEADERBASEUNIT,             -- Base UoM [basme]
    BOMHEADERQUANTITYINBASEUNIT,   -- Base quantity [basmn]
    RECORDCREATIONDATE,            -- Created On [andat]
    LASTCHANGEDATE,                -- Changed On [aedat]
    CREATEDBYUSER,                 -- Created by [annam]
    LASTCHANGEDBYUSER,             -- Changed By [aenam]
    BOMISTOBEDELETED,              -- Handling Del. Flag [cs_dlhnd]
    BOMGROUP,                      -- BOM group [exstl]
    BILLOFMATERIALSTATE,           -- Single-Character Flag [char1]
    ISHEADERDRAFTMODIFIED,         -- Single-Character Flag [char1]
    BILLOFMATERIALVERSION,         -- BOM Version [cs_versn]
    BOMVERSIONSTATUS,              -- BOM Version Status [cs_versnst]
    ISVERSIONBILLOFMATERIAL,       -- Versioning Relevant [cs_versnind]
    ISLATESTBOMVERSION,            -- Latest Rel Version [cs_versnlastind]
    PRIMARY KEY (MANDT, DRAFTUUID)
);