STKO
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA