SAP table STPF (Structure tree of the exploded BOM)

SAP table STPF has 5 primary key fields being MANDT,STLTY_W,STLNR_W,STLAL_W,KANTE_K.

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 * MANDT
STLTY_W BOM category CHAR 1 0 STLTY
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
P Work Breakdown Structure BOM
S Standard BOM
T Functional Location BOM
STLNR_W Bill of Material CHAR 8 0 STNUM
STLAL_W Alternative BOM CHAR 2 0 STALT
KANTE_K Edge in the exploded BOM tree NUMC 6 0 STKAN
STLTY BOM category CHAR 1 0 STLTY
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
P Work Breakdown Structure BOM
S Standard BOM
T Functional Location BOM
STLNR Bill of Material CHAR 8 0 STNUM
STLAL Alternative BOM CHAR 2 0 STALT
STVKN Inherited node number of BOM item NUMC 8 0 STVKN
KANTE_V Edge in the exploded BOM tree NUMC 6 0 STKAN