Skip to Content

How to customize MB5L report for Period wise or Period wise Stock report

Feb 21 at 08:03 AM


avatar image


My Client requirement to develop new stock report same as MB5L. But the difference is report should be having period and fiscal year as input.

Mb5l report only provide data for current and previous period. My client requirement is stock report should be period wise.

Please suggest me how can i develop a customize report so that value will match with MB5L report or Customize process of MB5L report for Period inputs

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jürgen L
Feb 21 at 10:49 AM

Good luck - hope you are not a beginner with ABAP coding as the result would be a master piece.

MM stores only values for current period, previous period and previous year in its MBEW record, which means you would need to extend the logic to MBEWH records, but for this you would certainly need to understand the logic how this table is used. The same has to be done for all other stock tables which are read in the standard MB5L report. And this is just the MM side. But this report is comparing FI and MM values. So you need to understand the logic on FI site too and access the right periods there.

The easier way would probably be to look forward only, and just execute MB5L once a month and to store a copy of the result in sharepoint or even in a SAP print archive for future reference. I mean then you just have no information about the periods which are older than today. But next year same time you already find the information for 12 periods if really someone need to look into that.

The main purpose of this transaction is to identify differences between MM and FI, and such differences have to be resolved immediately before you carry them over into next periods.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hats off to the explanation...