In the moment that you create a new material BOM using transaction CS01,
have you any chance to introduce a date in the field " Valid to" ?
Regards, Josu.