Question Re: Restrict report MB5B on a particular Storage Location in Enterprise Resource Planning Q&A

Restrict report MB5B on a particular Storage Location

Rizwansiddiqui2 — Thu, 14 Jun 2018 11:27:50 GMT

Hello,

I have a requirement, my client want to restrict/hide a particular storage location from report MB5B. He didn't want to see the stock from this stoage location. It is possible with standard configuration ?

Regards.

Re: Restrict report MB5B on a particular Storage Location

JL23 — Thu, 14 Jun 2018 11:34:59 GMT

depends on what you would like to see finally.

If you select valuated stocks then it is not possible, since there is no valuation at storage location level, see the logic in OSS note 1771093 - MB5B - Error M7 284 Storage Location will be reset

If you only want to see storage location stock then you can enter the storage location which you do not want to see and press F2 to set the icon for unequal.

Re: Restrict report MB5B on a particular Storage Location

Rizwansiddiqui2 — Thu, 14 Jun 2018 11:47:29 GMT

Thanks for your quick response. OSS note 1771093 is already implemented.

Let me rephrase my question.

Actually, client wants to hide storage location from all the users except a group of 4 people should allow see it. He does not even want to tell the users about the changes in the storage location.

regards,

Re: Restrict report MB5B on a particular Storage Location

JL23 — Thu, 14 Jun 2018 12:14:14 GMT

How did you implement a KBA? KBAs are consulting notes, not program fixes. Can it be that you just have no access to read the note?

Storage location authorization is not checked in MB5B, and would not make sense either as MB5B would have incorrect results.

You could create a transaction variant, a transaction which is only executed with a certain variant. This variant should only allow storage location stock and not allow valuated stock. It should further exclude this particular storage location (selection fields can be made hidden to the user, so the user cannot know which location is excluded, but he also could not select a storage location on its own, which means he always can only use MB5B at plant level)

Re: Restrict report MB5B on a particular Storage Location

Rizwansiddiqui2 — Thu, 14 Jun 2018 12:25:48 GMT

Transaction variant will not solve the problem because as I said earlier "Client does not even want to tell the users about the changes in the storage location and if the user changes the variant then he will see the stock on the restrict storage location.

Can it be possible by doing some changes in the logic of program "RM07MLBD" ?

Re: Restrict report MB5B on a particular Storage Location

JL23 — Thu, 14 Jun 2018 12:37:30 GMT

nobody can hinder you to do modifications, even they just result in inconsistent values which make no sense. Side effect with a modification: modification is not covered by SAP Standard Support

Re: Restrict report MB5B on a particular Storage Location

Prasoon — Wed, 20 Jun 2018 12:36:23 GMT

Hi,

As already mentioned, you can not restict the stock of a particular storage location as the valuation can not be at storage location. So eventually, its not possible to hide the stock of a particular storage location in MB5B valuated stock option.

Moreover, MB5B is one of the most complex reports in MM and altering the standard logic may always lead to wrong information.

Instead, you may restrict the use of MB5B to few people and create a custom program with your own logic and provide to other users.

Regards,

Prasoon

Re: Restrict report MB5B on a particular Storage Location

primoz_gricar — Wed, 05 Jun 2024 14:17:08 GMT

The best solution for this dilemma I could find was a standard program: J_3RMOBVED. You can run stock list for selected date/period in the past, plant, storage location(s), .... and many other selection cirteria.

Use transaction SE38 to run the program.

Program offers a rich set of output data presented in one- or multy-line report.

Regards, Primoz