STKO_D

Transparent Table Application Table
71 Fields 4 CDS Views

Draft table for Bill of Material Header

STKO_D is an SAP database table in S/4HANA. Draft table for Bill of Material Header. It contains 71 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
E_BillOfMaterialDraft view_entity from EXTENSION Bill of Material header drft - Extension
R_BillOfMaterialDraft view_entity from BASIC Draft view for Bill of Material
R_MatBillOfMaterialDraft view_entity from BASIC Draft view for Bill of Material
R_WBSBillOfMaterialDraft view_entity from BASIC Draft View for WBS Bill Of Material

Fields (71)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY billofmaterial cs_stlnr BOM
KEY billofmaterialcategory stlty BOM category
KEY billofmaterialvariant stalt Alternative
KEY billofmaterialversion cs_versn BOM Version
KEY engineeringchangedocument aennr Change Number
KEY material matnr Material
KEY plant werks_d Plant
KEY draftuuid sdraft_uuid Draft Document ID
salesorder cs_vbeln Sales Order
salesorderitem cs_vbpos Item
soldtoparty kunag Sold-to Party
purchaseorderbycustomer bstkd Cust. Reference
projectelement /s4ppm/project_ele_id Proj Element ID
wbselementinternalid ps_s4_pspnr WBS Internal ID
plantname werks_name Plant Name
engineeringchangedocforedit aennr Change Number
billofmaterialvariantusage stlan Usage
billofmaterialheaderuuid cs_guidb Guid
ismultiplebomalt x415a Alt.det. MBOM
bomheaderinternalchangecount cim_count Counter
materialname maktx Description
bomprioritizedversion cslid Selection ID
defaultvalidfromdate abap.dats
bomusagepriority cslpr Sel. priority
billofmaterialauthsngrp stlbe Auth group
bomversionstatus cs_versnst BOM Version Status
materialtolotsizequantity losbs To Lot Size
matfromlotsizequantity losvn From Lot Size
isversionbillofmaterial cs_versnind Versioning Relevant
islatestbomversion cs_versnlastind Latest Rel Version
bomtechnicaltype tetyp_d Tech type
bomgroup exstl BOM group
bomheadertext cstext BOM Description
bomalternativetext stktx Alt Text
materialtype mtart Material Type
billofmaterialstatus stlst BOM Status
validityenddate datub to
validitystartdate datuv Valid From
chgtoengineeringchgdocument aenra Change No. To
ismarkedfordeletion lkenz Deletion Ind.
bomisarchivedfordeletion loknz Deletion flag
isconfiguredmaterial kbaus ConfigurableBOM
bomisconfigurable kbaus ConfigurableBOM
isale cs_alekz ALE indicator
bomheaderbaseunit basme Base UoM
bomheaderquantityinbaseunit basmn Base quantity
recordcreationdate andat Created On
lastchangedate aedat Changed On
lastchangedbyuser aenam Changed By
longtextlanguage ltxsp_cp Long Text Lang
productisconfigurable productisconfigurable Configurable
createdbyuser annam Created by
bomistobedeleted cs_dlhnd Handling Del. Flag
productdescription productdescription Description
documentiscreatedbycad cadkz CAD Indicator
laboratoryordesignoffice labor Lab/Office
lastchangedatetime timestampl Time Stamp
bomassetntwkhndovrisrelevant cs_ain_ind BOM to AIN Handover
materialbomobjectid cs_matbom_key MBOM key
bompredecessorversion cs_prev_versn Predecessor Version
indicatorisbomchangedwithhist histk History ID
indicatorisbomwithdatehistory hisdt Date hist
alternativeunit basme Base UoM
billofmaterialhdrdetailstext abap.char
isattachmentsenabled cv_orig Originals
quantityinbaseunitishidden boolean Boolean Variable (X = True, - = False, Space = Unknown)
bomselectedkeydate datuv Valid From
billofmaterialnoteidentifier abap.char
changedocumenttablekey cdtabkey Table Key
engineeringchangedocforcopy aennr Change Number

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 table for Bill of Material Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE STKO_D (
    MANDT,                          -- Client [mandt]
    BILLOFMATERIAL,                 -- BOM [cs_stlnr]
    BILLOFMATERIALCATEGORY,         -- BOM category [stlty]
    BILLOFMATERIALVARIANT,          -- Alternative [stalt]
    BILLOFMATERIALVERSION,          -- BOM Version [cs_versn]
    ENGINEERINGCHANGEDOCUMENT,      -- Change Number [aennr]
    MATERIAL,                       -- Material [matnr]
    PLANT,                          -- Plant [werks_d]
    DRAFTUUID,                      -- Draft Document ID [sdraft_uuid]
    SALESORDER,                     -- Sales Order [cs_vbeln]
    SALESORDERITEM,                 -- Item [cs_vbpos]
    SOLDTOPARTY,                    -- Sold-to Party [kunag]
    PURCHASEORDERBYCUSTOMER,        -- Cust. Reference [bstkd]
    PROJECTELEMENT,                 -- Proj Element ID [/s4ppm/project_ele_id]
    WBSELEMENTINTERNALID,           -- WBS Internal ID [ps_s4_pspnr]
    PLANTNAME,                      -- Plant Name [werks_name]
    ENGINEERINGCHANGEDOCFOREDIT,    -- Change Number [aennr]
    BILLOFMATERIALVARIANTUSAGE,     -- Usage [stlan]
    BILLOFMATERIALHEADERUUID,       -- Guid [cs_guidb]
    ISMULTIPLEBOMALT,               -- Alt.det. MBOM [x415a]
    BOMHEADERINTERNALCHANGECOUNT,   -- Counter [cim_count]
    MATERIALNAME,                   -- Description [maktx]
    BOMPRIORITIZEDVERSION,          -- Selection ID [cslid]
    DEFAULTVALIDFROMDATE,           -- abap.dats
    BOMUSAGEPRIORITY,               -- Sel. priority [cslpr]
    BILLOFMATERIALAUTHSNGRP,        -- Auth group [stlbe]
    BOMVERSIONSTATUS,               -- BOM Version Status [cs_versnst]
    MATERIALTOLOTSIZEQUANTITY,      -- To Lot Size [losbs]
    MATFROMLOTSIZEQUANTITY,         -- From Lot Size [losvn]
    ISVERSIONBILLOFMATERIAL,        -- Versioning Relevant [cs_versnind]
    ISLATESTBOMVERSION,             -- Latest Rel Version [cs_versnlastind]
    BOMTECHNICALTYPE,               -- Tech type [tetyp_d]
    BOMGROUP,                       -- BOM group [exstl]
    BOMHEADERTEXT,                  -- BOM Description [cstext]
    BOMALTERNATIVETEXT,             -- Alt Text [stktx]
    MATERIALTYPE,                   -- Material Type [mtart]
    BILLOFMATERIALSTATUS,           -- BOM Status [stlst]
    VALIDITYENDDATE,                -- to [datub]
    VALIDITYSTARTDATE,              -- Valid From [datuv]
    CHGTOENGINEERINGCHGDOCUMENT,    -- Change No. To [aenra]
    ISMARKEDFORDELETION,            -- Deletion Ind. [lkenz]
    BOMISARCHIVEDFORDELETION,       -- Deletion flag [loknz]
    ISCONFIGUREDMATERIAL,           -- ConfigurableBOM [kbaus]
    BOMISCONFIGURABLE,              -- ConfigurableBOM [kbaus]
    ISALE,                          -- ALE indicator [cs_alekz]
    BOMHEADERBASEUNIT,              -- Base UoM [basme]
    BOMHEADERQUANTITYINBASEUNIT,    -- Base quantity [basmn]
    RECORDCREATIONDATE,             -- Created On [andat]
    LASTCHANGEDATE,                 -- Changed On [aedat]
    LASTCHANGEDBYUSER,              -- Changed By [aenam]
    LONGTEXTLANGUAGE,               -- Long Text Lang [ltxsp_cp]
    PRODUCTISCONFIGURABLE,          -- Configurable [productisconfigurable]
    CREATEDBYUSER,                  -- Created by [annam]
    BOMISTOBEDELETED,               -- Handling Del. Flag [cs_dlhnd]
    PRODUCTDESCRIPTION,             -- Description [productdescription]
    DOCUMENTISCREATEDBYCAD,         -- CAD Indicator [cadkz]
    LABORATORYORDESIGNOFFICE,       -- Lab/Office [labor]
    LASTCHANGEDATETIME,             -- Time Stamp [timestampl]
    BOMASSETNTWKHNDOVRISRELEVANT,   -- BOM to AIN Handover [cs_ain_ind]
    MATERIALBOMOBJECTID,            -- MBOM key [cs_matbom_key]
    BOMPREDECESSORVERSION,          -- Predecessor Version [cs_prev_versn]
    INDICATORISBOMCHANGEDWITHHIST,  -- History ID [histk]
    INDICATORISBOMWITHDATEHISTORY,  -- Date hist [hisdt]
    ALTERNATIVEUNIT,                -- Base UoM [basme]
    BILLOFMATERIALHDRDETAILSTEXT,   -- abap.char
    ISATTACHMENTSENABLED,           -- Originals [cv_orig]
    QUANTITYINBASEUNITISHIDDEN,     -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    BOMSELECTEDKEYDATE,             -- Valid From [datuv]
    BILLOFMATERIALNOTEIDENTIFIER,   -- abap.char
    CHANGEDOCUMENTTABLEKEY,         -- Table Key [cdtabkey]
    ENGINEERINGCHANGEDOCFORCOPY,    -- Change Number [aennr]
    PRIMARY KEY (MANDT, BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALVARIANT, BILLOFMATERIALVERSION, ENGINEERINGCHANGEDOCUMENT, MATERIAL, PLANT, DRAFTUUID)
);

Learn More