STPO_LINKS
EBOM MBOM links table
STPO_LINKS is an SAP database table in S/4HANA. EBOM MBOM links table. It contains 15 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BillOfMaterialItemLinks | view_entity | from | BASIC | CDS View for STPO_LINKS table |
| I_BillOfMaterialItemLinks_1 | view_entity | from | BASIC | BOM Item Links |
| I_BOMItemLinksWithPhantom | view_entity | from | BASIC | BOM item links with phantom node |
| I_ChgImpactBOMItmLinks | view | from | BASIC | Eng BOM Mfg BOM Item Links |
Fields (15)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | link | guid | GUID | |||
| ebom_stlty | stlty | BOM category | ||||
| ebom_stlnr | stnum | BOM | ||||
| ebom_stlal | stlal | AlternativeBOM | ||||
| ebom_stvkn | stvkn | Item node | ||||
| ebom_versn | cs_versn | BOM Version | ||||
| mbom_stlty | stlty | BOM category | ||||
| mbom_stlnr | stnum | BOM | ||||
| mbom_stlal | stlal | AlternativeBOM | ||||
| mbom_stvkn | stvkn | Item node | ||||
| mbom_versn | cs_versn | BOM Version | ||||
| variant_guid | pvs_pvguid | Internal Number | ||||
| eng_source | hfe_eng_source | Engineering Source | ||||
| engineering_only | hfe_eng_only | Engineering Only |
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.
-- EBOM MBOM links table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE STPO_LINKS (
MANDT, -- Client [mandt]
LINK, -- GUID [guid]
EBOM_STLTY, -- BOM category [stlty]
EBOM_STLNR, -- BOM [stnum]
EBOM_STLAL, -- AlternativeBOM [stlal]
EBOM_STVKN, -- Item node [stvkn]
EBOM_VERSN, -- BOM Version [cs_versn]
MBOM_STLTY, -- BOM category [stlty]
MBOM_STLNR, -- BOM [stnum]
MBOM_STLAL, -- AlternativeBOM [stlal]
MBOM_STVKN, -- Item node [stvkn]
MBOM_VERSN, -- BOM Version [cs_versn]
VARIANT_GUID, -- Internal Number [pvs_pvguid]
ENG_SOURCE, -- Engineering Source [hfe_eng_source]
ENGINEERING_ONLY, -- Engineering Only [hfe_eng_only]
PRIMARY KEY (MANDT, LINK)
);
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