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 |