I am trying to create a Demand & Supply chain table (in terms of SO/PO). A is my top level demand (final product) and requires various other supplies to manufacture this, I am wanting to see all the supplies (multi level) that goes into that demand. Example below, A requires, B,C,D but B/C/D requires other supplies to have them manufacture, think of main assembly (A) and sub-assemblies (B,C,D) until it reaches to RAW MATERIAL level.
Does any thing such already exists in IFS Cloud if not, any ideas how can I tie it together through data base?
| Demand Order | Supply Order |
| A | B |
| A | C |
| A | D |
| B | E, F |
| C | G |
| D | H |
| E | RAW MATERIAL |
| F | RAW MATERIAL |
| G | RAW MATERIAL |
| H | RAW MATERIAL |