SNUM

Transparent Table Application Table
10 Fields 3 CDS Views

BOM Explosion Number

SNUM is an SAP database table in S/4HANA. BOM Explosion Number. It contains 10 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BOMExplosionDate view from BASIC BOM Explosion Date
PPH_E_RESB_AGG view left_outer
PPH_E_RESB_FLEX view left_outer

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sernr SERNR BOM expl.number
brutr BRUTR Fixed Key Date
techs TECHS StandardVariant
sondb SONDB Spec.stck allwd
matnr MATNR Material
werks WERKS_D Plant
sntxt SNTXT Ex. Number
snsta SNSTA Status
xloek XLOEK Deleted

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 Explosion Number
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNUM (
    MANDT,  -- Client [MANDT]
    SERNR,  -- BOM expl.number [SERNR]
    BRUTR,  -- Fixed Key Date [BRUTR]
    TECHS,  -- StandardVariant [TECHS]
    SONDB,  -- Spec.stck allwd [SONDB]
    MATNR,  -- Material [MATNR]
    WERKS,  -- Plant [WERKS_D]
    SNTXT,  -- Ex. Number [SNTXT]
    SNSTA,  -- Status [SNSTA]
    XLOEK,  -- Deleted [XLOEK]
    PRIMARY KEY (MANDT, SERNR)
);

Learn More