STZU

Transparent Table Application Table
25 Fields 8 CDS Views

Permanent BOM data

STZU is an SAP database table in S/4HANA. Permanent BOM data. It contains 25 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_MaterialBOMHeaderCurrentDate view inner BASIC Material BOM header valid today
P_BillOfMaterialHeaderDEX view_entity inner BASIC Data extraction Header
P_Bom_Header_Determine view inner BASIC Bom header determination
P_ChangeRecordBOMHeaderSearch view inner BASIC Change Record BOM Header for search
P_MATBILLOFMATERIALHEADERDEX view_entity inner BASIC Private view for Material BOM header
P_SALESORDERBOMHEADERDEX view_entity inner BASIC Private view for Sales Order BOM header
P_WBSBillOfMaterialHeaderDEX view_entity inner BASIC Private view for WBS BOM header
RFM_PP_MBOMConstcyChkHdrPerm view from Permanent Header Info

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY stlty stlty BOM category
KEY stlnr stnum BOM
stlan stlan Usage
exstl exstl BOM group
altst altst Alternatives
varst varst Variants
kbaus kbaus ConfigurableBOM
ltxsp ltxsp_cp Long Text Lang
stlbe stlbe Auth group
ztext cstext BOM Description
wrkan wrkan Created in plt
hisdt hisdt Date hist
hissr hissr Tech st hist
histk histk History ID
stuez stuez Max counters
maxkn maxkn Max nodes
kzpln kzpln Chge frm rtg
aenrl aenrl Last change no.
clsmx cs_clsmx Max. classif.
stldt stldt Changed on
stltm cs_stltm Changed at
maxkan maxkan Maximum edge
tstmp cs_tstamp Time stamp
versnind cs_versnind Versioning Relevant

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.

-- Permanent BOM data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE STZU (
    MANDT,     -- Client [mandt]
    STLTY,     -- BOM category [stlty]
    STLNR,     -- BOM [stnum]
    STLAN,     -- Usage [stlan]
    EXSTL,     -- BOM group [exstl]
    ALTST,     -- Alternatives [altst]
    VARST,     -- Variants [varst]
    KBAUS,     -- ConfigurableBOM [kbaus]
    LTXSP,     -- Long Text Lang [ltxsp_cp]
    STLBE,     -- Auth group [stlbe]
    ZTEXT,     -- BOM Description [cstext]
    WRKAN,     -- Created in plt [wrkan]
    HISDT,     -- Date hist [hisdt]
    HISSR,     -- Tech st hist [hissr]
    HISTK,     -- History ID [histk]
    STUEZ,     -- Max counters [stuez]
    MAXKN,     -- Max nodes [maxkn]
    KZPLN,     -- Chge frm rtg [kzpln]
    AENRL,     -- Last change no. [aenrl]
    CLSMX,     -- Max. classif. [cs_clsmx]
    STLDT,     -- Changed on [stldt]
    STLTM,     -- Changed at [cs_stltm]
    MAXKAN,    -- Maximum edge [maxkan]
    TSTMP,     -- Time stamp [cs_tstamp]
    VERSNIND,  -- Versioning Relevant [cs_versnind]
    PRIMARY KEY (MANDT, STLTY, STLNR)
);

Learn More