STPO_LINKS

Transparent Table Application Table
16 Fields 3 CDS Views

EBOM MBOM links table

STPO_LINKS is an SAP database table in S/4HANA. EBOM MBOM links table. It contains 16 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BillOfMaterialItemLinks view from BASIC CDS View for STPO_LINKS table
I_BOMItemLinksWithPhantom view_entity from BASIC BOM item links with phantom node
I_ChgImpactBOMItmLinks view from BASIC Eng BOM Mfg BOM Item Links

Fields (16)

KeyField Data ElementDescription DomainTypeLength
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
node MPE_NODE_GUID Node

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]
    NODE,              -- Node [MPE_NODE_GUID]
    PRIMARY KEY (MANDT, LINK)
);

Learn More