Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Enno86
Contributor III
Contributor III

SAP BOM STPF and Hierarchy?

Hi Qlik Community,

i found several threads on BOM (Bill of Material) but am struggling with it.

Task: I have a list of components to be shipped to customers. the component being shipped is not always the component number i am looking for. In order to find the relvant number, i thought it makes sense to link the BOM on the shipped-component number.

Reason: somewhere in the BOM, the level can be anywhere between highest to third or fourth, is a material number which is linked in SAP to a material specific classification.

SAP seems to store BOM structure in Table STPF. 

[STLTY_W_KEY.STPF] //Stücklistentyp
, [STLNR_W_KEY.STPF] //Stückliste
, [STLAL_W_KEY.STPF] //Stücklistenalternative
, [KANTE_K_KEY.STPF] //Kante im Baum der aufgelösten Stückliste
, [STLTY.STPF] //Stücklistentyp
, [STLNR.STPF] //Stückliste
, [STLAL.STPF] //Stücklistenalternative
, [STVKN.STPF] //Vererbte Knotennummer der Stücklistenposition
, [KANTE_V.STPF] //Kante im Baum der aufgelösten Stückliste

 

Does anyone have an Idea or link to share, how i can proceed?

Any advice is thanked for in advance 🙂

Labels (3)
0 Replies