Tree structure of material to production orders

[Minick]

Hello everyone,

We would like to create a tree structure between materials and production orders using SAP data

Our aim is to create the following structure:

DispoLevel	Material Start	Material Header	Material Component	ProductionOrder Start	ProductionOrder Header	ProductionOrder Component
3	M0	M2	M3	P0	P2	P3
2	M0	M1	M2	P0	P1	P2
1	M0	M0	M1	P0	P0	P1
3	M0	…	…	P0a	…	…

The first part with the materials can also be created using the BOM resolution. The problem we have is the right part, because a material can have many different production orders and here we also try to create this tree structure, which material should be assigned exactly to which order and, above all, how the individual production orders are linked to each other.

The question is: Can this structure be created and if so, how with which tables/data from SAP?

Thanks in advance for the help 🙂