STKO_DRAFT_V2

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_BILLOFMATERIALTP I_BILLOFMATERIALTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE STKO_DRAFT_V2 (
    MANDT,                          -- Client [MANDT]
    DRAFTUUID,                      -- Key [/BOBF/UUID]
    BILLOFMATERIAL,                 -- BOM [STNUM]
    BILLOFMATERIALCATEGORY,         -- BOM category [STLTY]
    BILLOFMATERIALVARIANT,          -- Alternative [STALT]
    BILLOFMATERIALVERSION,          -- BOM Version [CS_VERSN]
    ENGINEERINGCHANGEDOCUMENT,      -- Change Number [AENNR]
    MATERIAL,                       -- Material [MATNR]
    PLANT,                          -- Plant [WERKS_D]
    SALESORDER,                     -- Sales Order [CS_VBELN]
    SALESORDERITEM,                 -- Item [CS_VBPOS]
    SOLDTOPARTY,                    -- Sold-to Party [KUNAG]
    PURCHASEORDERBYCUSTOMER,        -- Cust. Reference [BSTKD]
    BILLOFMATERIALVARIANTUSAGE,     -- Usage [STLAN]
    BILLOFMATERIALHEADERUUID,       -- Guid [CS_GUIDB]
    CHANGERECORD,                   -- Char20 [CHAR20]
    BOMHEADERINTERNALCHANGECOUNT,   -- Counter [CIM_COUNT]
    ASSETINTELNETWORKTRACKINGMODE,  -- Char255 [CHAR255]
    ASSETINTELNETWORKMANUFACTURER,  -- Char [CHAR40]
    ASSETINTELNETWORKTEMPLATE,      -- Char [CHAR40]
    BILLOFMATERIALVARIANTFOREDIT,   -- Alternative [STALT]
    BILLOFMATERIALVERSIONFOREDIT,   -- BOM Version [CS_VERSN]
    ENGINEERINGCHANGEDOCFOREDIT,    -- Change Number [AENNR]
    PLANTFOREDIT,                   -- Plant [WERKS_D]
    MATERIALFOREDIT,                -- Material [MATNR]
    BILLOFMATERIALUUID,             -- abap.char
    ISMULTIPLEBOMALT,               -- Alt.det. MBOM [X415A]
    BOMPRIORITIZEDVERSION,          -- Selection ID [CSLID]
    BOMEXPLOSIONAPPLICATION,        -- BOM Application [CAPID]
    BOMUSAGEPRIORITY,               -- Sel. priority [CSLPR]
    BILLOFMATERIALAUTHSNGRP,        -- Auth group [STLBE]
    BOMVERSIONSTATUS,               -- BOM Version Status [CS_VERSNST]
    BOMVERSIONSTATUSDESCRIPTION,    -- Short Description [VAL_TEXT]
    MATFROMLOTSIZEQUANTITY,         -- From Lot Size [LOSVN]
    MATERIALTOLOTSIZEQUANTITY,      -- To Lot Size [LOSBS]
    ISVERSIONBILLOFMATERIAL,        -- Versioning Relevant [CS_VERSNIND]
    ISLATESTBOMVERSION,             -- Latest Rel Version [CS_VERSNLASTIND]
    ISCONFIGUREDMATERIAL,           -- Configurable [PRODUCTISCONFIGURABLE]
    BOMISCONFIGURABLE,              -- ConfigurableBOM [KBAUS]
    BOMTECHNICALTYPE,               -- Tech type [TETYP_D]
    BOMGROUP,                       -- BOM group [EXSTL]
    INDICATORISBOMWITHDATEHISTORY,  -- Date hist [HISDT]
    INDICATORISBOMCHANGEDWITHHIST,  -- History ID [HISTK]
    BOMHEADERTEXT,                  -- BOM Description [CSTEXT]
    BOMALTERNATIVETEXT,             -- Alt Text [STKTX]
    LONGTEXTLANGUAGE,               -- Long Text Lang [LTXSP_CP]
    LONGTEXTEXISTS,                 -- BOM long text [LTXZU]
    BILLOFMATERIALSTATUS,           -- BOM Status [STLST]
    HEADERVALIDITYSTARTDATE,        -- Valid From [DATUV]
    HEADERVALIDITYENDDATE,          -- to [DATUB]
    CHGTOENGINEERINGCHGDOCUMENT,    -- Change No. To [AENRA]
    ISMARKEDFORDELETION,            -- Deletion Ind. [LKENZ]
    BOMISARCHIVEDFORDELETION,       -- Deletion flag [LOKNZ]
    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]
    DOCUMENTISCREATEDBYCAD,         -- CAD Indicator [CADKZ]
    LABORATORYORDESIGNOFFICE,       -- Lab/Office [LABOR]
    HEADERATTACHMENTKEY,            -- Object Key [OBJKY]
    ISHEADERDRAFTMODIFIED,          -- Single-Character Flag [CHAR1]
    LASTCHANGEDATETIME,             -- Time Stamp [TIMESTAMPL]
    BOMASSETNTWKHNDOVRISRELEVANT,   -- BOM to AIN Handover [CS_AIN_IND]
    MATERIALBOMOBJECTID,            -- MBOM key [CS_MATBOM_KEY]
    BOMPREDECESSORVERSION,          -- Predecessor Version [CS_PREV_VERSN]
    BOMPREDECESSORVARIANT,          -- Alternative [STALT]
    ALTERNATIVEUNIT,                -- Base UoM [BASME]
    MATERIALTYPE,                   -- Material Type [MTART]
    BOMISPARAMEFFECTIVITYRELEVANT,  -- Assign.eff.vals [CC_MTEFF]
    PRODUCTISCONFIGURABLE,          -- Configurable [PRODUCTISCONFIGURABLE]
    SELECTEDVARIANT,                -- Alternative [STALT]
    SELECTEDVERSION,                -- BOM Version [CS_VERSN]
    BOMHASDRAFTENTITY,              -- Has Draft [SDRAFT_HAS_DRAFT]
    HASACTIVEENTITY,                -- Has active [SDRAFT_HAS_ACTIVE]
    PRODUCTDRAFTUUID,               -- Key [/BOBF/UUID]
    PRODUCTISDRAFTENTITY,           -- Is draft [SDRAFT_IS_DRAFT]
    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]
    DUMMY_STKO_INCL_EEW_PS,         -- Ext. Include [STKO_INCL_EEW]
    PRIMARY KEY (MANDT, DRAFTUUID)
);