We have a requirement to control the Revision changes in Material master.
In the current process the Material Master revision level is updated when there is a change in Material master or when the BOM components are changed where this material master is used as a header.
The issue is we are having two BOM's Engineering (E)BOM and Production (P)BOM and when there is a component changes in E-BOM, the header material is revised to next level.
The changes in P-BOM is controlled with a different Change number. So my question is how to control the Revision level of header material in the P-BOM
For example :- Header Material is A and components A1 and A2. Now in the Engineeing BOM, A1 quantity has changed and the Header Material is revised to Rev.01 with Change number CH-1 on date 01-May-2011
Now I need to implement this change in Production BOM with Change number Ch-2 , the Header Material A should have Rev01 itself but with a different change number ( on a different validity date, say 01-June-2011)
How can this scenario be mapped? Any suggestions?