Material Status Obsolete with Stock

[pierre_scholl]

Hello everyone,

I am looking for a way to extract a list with materials that have the status "Obsolete" but are still in Stock.

Does anyone have a solution for this?

BR and thank you!

Pierre

[Bin_Eric_Hou · Accepted solution]

Hi Pierre,

If you only extract this data for one time, you could try to firstly download a list of all obsolete materials using APP 'Manage Product Master Data' with a fiter 'Cross-Plant Product Status' = 'Obsolete'. And then copy those material numbers as filter in APP 'Stock Multiple Materials' to get those in stock.

I think in S4HC cloud, there is no standard report to display obsolete material stock. If you want to design such report, there are two possible ways. 1.You can use extensibility for APP 'Stock Multiple Materials' by adding 'Cross-Plant Product Status' in this standard app. You can refer to this link about the extension method https://help.sap.com/viewer/32da8359c8ee4e8b8e8c5e15cacba5aa/2008.500/en-US/d451f280bc3646bb9c3cb0ac...

2.Customize a query report by combining CDS 'I_StockQuantityCurrentValue' as a primary data source to get stock and CDS 'I_Product' as associated data source to get status.

Hope it helps.

Eric

[pierre_scholl]

Hi Eric,

thank you very much for your answer. I used the extensibility for the "Stock Multiple Materials" App and it worked perfectly fine.

Thank you once again!

BR,

Pierre