Various reports for FG Material

[former_member623831]

Dear All,

I wish to know the various reports run for a FG material and it's different T codes.

My client requirement is as below

He should know which FG materials have aged above or equal to three months for which sales movement has not been possible.

For this automatic deletion flag should be set.

Please guide

[FredericGirod]

This is a technical forum, not a place to have someone doing your job.

So, please instead of a Function Specification, give your technical issue

[former_member623831]

I have tagged ABAP and MM consultants also

I written the requirement properly it's a query open to all

He wants all the FG material for which sales movement has not been possible for more than 3 months.

So which is the T code will give this report and how and where the automation can be done for this

[Lakshmipathi]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful), share screenshots of what you've seen/done, make sure you've applied the appropriate tags, and use a more descriptive subject line. The more details you provide, the more likely it is that members will be able to assist you. You should also make sure you're using all the appropriate tags, so the right experts can find your question.
Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question -- but if that happens, you can leave more details in a comment).
Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

[Sandra_Rossi]

(for people who wonder, FG = Finished Goods)

[Sandra_Rossi]

You should better use primary tag Materials Management.

[VeselinaPeykova]

It does not sound logical to set deletion flag for materials for which you have stocks, it makes sense to analyze why you produce or procure stocks that you do not need and adjust your strategy.

Or, if you have expired products - to scrap these.

Or, if some materials are not sold or used in production or maintenance - whether you can use these somehow, for example - refurbish some spare parts, or use some of the materials to produce a different product that you have a higher chance of selling, or if some products are not sold as before - to run campaigns, introduce promotional prices... The idea of making a decision without investigating the root cause and taking an informed decision seems wrong.... even if you use ML to help you.

Anyways, if you use S/4HANA - there is an app that can give overview on Slow or Non-Moving Materials, there is also an app for Dead Stock Analysis.

For ECC6 you can probably look into MC50 and and MC46, but for S/4HANA the Fiori apps seem to be more useful to inventory managers than the legacy ones, especially the predictive feature in Slow or Non-Moving Materials seems to be a nice improvement.

By the way, if you have searched in Google for sap dead stock slow moving report you would have found such kind of information easily on the first page of results.

[former_member623831]

Dear Veseline,

Very much thankful for your analysis.

In case of my client's requirement the MC50 and MC46 T-Codes seems to be useful.

Now I need to configure this that I need a report where directly I can select the sales movement not happened for last three months only for the FG material.

Can this be made by adding a field through ABAP in "Period to analyze" tab

If "YES" then how can this be done technically.(as my client seems to have ECC6)

[VeselinaPeykova]

patt2019 if the standard reports do not fulfill the needs of your customer, you can define your own info structures and use them for reporting. This topic (creating custom info structures) has been covered in blogs, you can find them if you search in Google.

If you have to analyze lots of data though, it is better to consider BW.