STPU

Transparent Table Application Table
9 Fields 5 CDS Views

BOM Subitem

STPU is an SAP database table in S/4HANA. BOM Subitem. It contains 9 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_BillOfMaterialSubItemsBasic view from BASIC Bill of Material Sub items Details
P_BillOfMaterialSubItems view from BASIC Private cds view for BOM sub items
P_MaterialBOMSubitemDEX view_entity from BASIC
P_ProjectBOMSubitemDEX view_entity from BASIC
P_SALESORDERBOMSUBITEMDEX view_entity from BASIC

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY stlty STLTY BOM category
KEY stlnr STNUM BOM
KEY stlkn STLKN Item node
KEY stpoz CIM_COUNT Counter
KEY uposz UPOSZ Subitem
upmng UPMNG Sub-item qty
ebort EBORT Install. Point
uptxt UPTXT Sub-item text

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 Subitem
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE STPU (
    MANDT,  -- Client [MANDT]
    STLTY,  -- BOM category [STLTY]
    STLNR,  -- BOM [STNUM]
    STLKN,  -- Item node [STLKN]
    STPOZ,  -- Counter [CIM_COUNT]
    UPOSZ,  -- Subitem [UPOSZ]
    UPMNG,  -- Sub-item qty [UPMNG]
    EBORT,  -- Install. Point [EBORT]
    UPTXT,  -- Sub-item text [UPTXT]
    PRIMARY KEY (MANDT, STLTY, STLNR, STLKN, STPOZ, UPOSZ)
);

Learn More