STKO

Transparent Table Application Table

BOM Header

STKO is an SAP database table in S/4HANA. BOM Header. It contains 36 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
D_BOMMATERIALVERSN view_entity from Result set of the BOM release version
E_BillOfMaterialTP view from EXTENSION Extended View For Bill Of Material HDR
I_BOOPlngBOMAssignment view inner BASIC PBOM assigned to Planning Routing
I_ChgRecdWithMatl view left_outer BASIC Open Change Record Details with Material
I_MaterialBOMHeaderCurrentDate view from BASIC Material BOM header valid today
I_MaterialBOMLinkDEX view_entity inner BASIC Data Extraction MAST
P_BillOfMaterialHeaderDEX view_entity from BASIC Data extraction Header
P_Bom_Header_Determine view from BASIC Bom header determination
P_BOMHeaderValidity view left_outer BASIC View to calculate the validity for BOM header
P_BOMHeaderValidity view from BASIC View to calculate the validity for BOM header
P_ChangeRecordBOMHeaderSearch view from BASIC Change Record BOM Header for search
P_MATBILLOFMATERIALHEADERDEX view_entity from BASIC Private view for Material BOM header
P_ProjectBOMHeaderChanges view_entity from BASIC Project BOM Header Changes
P_SALESORDERBOMHEADERDEX view_entity from BASIC Private view for Sales Order BOM header
P_WBSBillOfMaterialHeaderDEX view_entity from BASIC Private view for WBS BOM header
RFM_PP_MBOMConstcyChkHdrBsc view from BOM Header Details
SHSM_STKO view from CDS view for H_STLNR

Fields (36)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY stlty stlty BOM category
KEY stlnr stnum BOM
KEY stlal stalt Alternative
KEY stkoz cim_count Counter
datuv datuv Valid From
techv techv Tech st from
aennr aennr Change Number
lkenz lkenz Deletion Ind.
loekz loknz Deletion flag
vgkzl vgkzl Prev hdr countr
andat andat Created On
annam annam Created by
aedat aedat Changed On
aenam aenam Changed By
bmein basme Base UoM
bmeng basmn Base quantity
cadkz cadkz CAD Indicator
labor labor Lab/Office
ltxsp ltxsp_cp Long Text Lang
stktx stktx Alt Text
stlst stlst BOM Status
wrkan wrkan Created in plt
dvdat dvdat Scheduled on
dvnam dvnam Date shifted by
aehlp cc_aehlp Helper Field
alekz cs_alekz ALE indicator
guidx cs_guidb Guid
valid_to datub to
ecn_to aenra Change No. To
bom_versn cs_versn BOM Version
versnst cs_versnst BOM Version Status
versnlastind cs_versnlastind Latest Rel Version
lastchangedatetime timestampl Time Stamp
bom_ain_ind cs_ain_ind BOM to AIN Handover
bom_prev_versn cs_prev_versn Predecessor Version

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.

-- BOM Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE STKO (
    MANDT,               -- Client [mandt]
    STLTY,               -- BOM category [stlty]
    STLNR,               -- BOM [stnum]
    STLAL,               -- Alternative [stalt]
    STKOZ,               -- Counter [cim_count]
    DATUV,               -- Valid From [datuv]
    TECHV,               -- Tech st from [techv]
    AENNR,               -- Change Number [aennr]
    LKENZ,               -- Deletion Ind. [lkenz]
    LOEKZ,               -- Deletion flag [loknz]
    VGKZL,               -- Prev hdr countr [vgkzl]
    ANDAT,               -- Created On [andat]
    ANNAM,               -- Created by [annam]
    AEDAT,               -- Changed On [aedat]
    AENAM,               -- Changed By [aenam]
    BMEIN,               -- Base UoM [basme]
    BMENG,               -- Base quantity [basmn]
    CADKZ,               -- CAD Indicator [cadkz]
    LABOR,               -- Lab/Office [labor]
    LTXSP,               -- Long Text Lang [ltxsp_cp]
    STKTX,               -- Alt Text [stktx]
    STLST,               -- BOM Status [stlst]
    WRKAN,               -- Created in plt [wrkan]
    DVDAT,               -- Scheduled on [dvdat]
    DVNAM,               -- Date shifted by [dvnam]
    AEHLP,               -- Helper Field [cc_aehlp]
    ALEKZ,               -- ALE indicator [cs_alekz]
    GUIDX,               -- Guid [cs_guidb]
    VALID_TO,            -- to [datub]
    ECN_TO,              -- Change No. To [aenra]
    BOM_VERSN,           -- BOM Version [cs_versn]
    VERSNST,             -- BOM Version Status [cs_versnst]
    VERSNLASTIND,        -- Latest Rel Version [cs_versnlastind]
    LASTCHANGEDATETIME,  -- Time Stamp [timestampl]
    BOM_AIN_IND,         -- BOM to AIN Handover [cs_ain_ind]
    BOM_PREV_VERSN,      -- Predecessor Version [cs_prev_versn]
    PRIMARY KEY (MANDT, STLTY, STLNR, STLAL, STKOZ)
);