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)
);