Skip to main content

Hello everyone,

 

we currently want to display the Bill of Materials Hierarchy in Celonis.

The issue with that is, that the hierarchy is not present in any SAP-Table. But instead in the related tables MAST and STPO.

I have the MAST which has BOM and Material (component) relationship which needs to be traversed to STPO with the BOM-Nr. to identify the compenents and each component may be split into sub materials and new BOMs which needs to be looked up in the MAST for its BOM again and it goes on and on. Up to 4 levels deep.

So the 4th level has no relationship to the first level.

 

This recursive issue with inputing the results from MAST into STPO into MAST into STPO… is not possible in the FrontEnd (I assume).

I am going crazy with knowledge models and action flows, the documentation is absolutely horrible. So it probably needs to be done in the data model itself.

 

Additionally we want to add the Vendor from open orders from the EKPO. So we can filter for a material and for a vendor to so the impacted components on all levels.

 

Anyways, does anyone have any experience with that? 

 

Hi ​@milan.eric,

Did you checked the Network Explorer https://docs.celonis.com/en/using-network-explorer.html ? 

This View Component should exactly doing this job you described, going iteratively over rows and place them in a tree based on a parent-child relation. 

I hope this helps!

Best regards,

Jan-peter


Hey ​@janpeter.van.d 

 

thanks for your response and I looked into it. Sadly this does not quite meet the need. Since its a recursive parent-child relation for the same field and table. We also need it with some extra rules and factors. It is a bit hard to explain through text.

 

But we simply decided to scrape the frontend solution and go with a backend solution. 

Recursive SQL seems to be the standard for BOM explosions according to my online research.

 

We already have some good first round results!

 

Thanks and best regards

Milan


Reply