SAP table SNUM (BOM explosion number)

SAP table SNUM has 2 primary key fields being MANDT,SERNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
SERNR BOM explosion number CHAR 8 0 SERNR
BRUTR Fixed Key Date DATS 8 0 BRUTR
TECHS Parameter Variant/Standard Variant CHAR 12 0 TECHS
SONDB Special stock allowed for the serial number CHAR 1 0 SONDB
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
SNTXT Short description of BOM explosion number CHAR 40 0 SNTXT
SNSTA BOM explosion number status CHAR 1 0 SNSTA
Active
0 Inactive
XLOEK Item is deleted CHAR 1 0 XLOEK

SNUM foreign key relationships

Table Field Check Table Check Field
0 SNUM MATNR MARA General Material Data MANDT
0 SNUM MATNR MARA General Material Data MATNR
1 SNUM WERKS T001W Plants/Branches WERKS