Equivalent Material Code

Hi All,

We have one requirement as follows.

Technically materials are same. But it has different code and descriptions. When we check the material system should show other material in stock.

Example:

We have material X, Y Z

These materials are technically same specification. But It has different material codes.

When we check Material X in system, if not in stock, immediately system should show other stock Y & Z material if stock available.

how do we do in standard configuration?

thanks

Swathi