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?