Equivalent Material Code

[Former Member]

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

[Former Member]

Hi Swathi,

The standard Stock reports MMBE and MB52 are straight forward. You get stock for what you provide in selection screen.

From your comments it appears that the materials in question are alternate materials in BOM and if that is the case it is a valid scenario. Reason can be many like price, quality and availability from vendor.

However, your exact requirement cannot be met via standard reports. Best Standard Option would be to use MB52 report and filter it by using Material Type and Material Group in the scope of list and select No zero Stock Lines. Something like this.

Regards,

Niranjan