cancel
Showing results for 
Search instead for 
Did you mean: 

Wrong numbers in MMBE

Former Member
0 Kudos

Hi Gurus,

I have a material and when I try to check the stock for it in the MMBE, there is a problem in the calculation.

The sum of all the batches in the unrestricted stock don't match with the total unrestricted stock in the storage location. For example.

Storage location 1: 550

Batch 1: 100

Batch 2: 250

Batch 3: 125

What do you recommend me to do to balance the stock? In the previous situation I would like to get 475 instead of 550....

I don't know what happens or how to solve it...... It looks like there is a remaining stock in the storage location not linked to any batch but the system have it on consideration. The value I see in the MARD is 550...

Thank you very much for your help!

Accepted Solutions (1)

Accepted Solutions (1)

annabelle_roux
Participant
0 Kudos

Hello Abel,

Indeed it seems that you have some quantity in the storage location not associated with any batch.

Could you check where this difference comes from? For example, run MB51 and check all the goods receipts which were posted into this storage location with no batch number.

If we know where the issue comes from, then we will be able to more easily determine a solution to correct the inventory. There are different ways to adjust the stock, but the solution mostly depends on the issue.

Annabelle R.

Former Member
0 Kudos

Thanks for the answer Annabelle,

I did realize that the problem is even bigger than that.... the problem is:

Storage location 1: 550

Batch 1: 250

Batch 2: 250

Batch 3: 125

Which it means that the storage location has less stock than all its batches! I apologize for my mistake explaining that before.... How this can be possible?

I'm out of ideas...

I will appreciate any suggestion,

JL23
Active Contributor
0 Kudos

what column do you look at?

do you have the box for include special stock activated in the selection screen of MMBE?

Former Member
0 Kudos

I'm looking at "Unrestricted stock" and yes, I did activated the special stock in the selection screen.

JL23
Active Contributor
0 Kudos

are you allowing negative stocks in your system?

do you know if the batch management indicator was active from the very beginning of this material? or got activated later?

Former Member
0 Kudos

Negative values are not allowed and batch management was working since the kick off of the project... 10 years ago.

Edited by: Abel Raya on Mar 22, 2011 9:55 AM

JL23
Active Contributor
0 Kudos

I had not asked since when you are using batch management in general.

I just have seen too many cases where the batch management flag was set by direct table maintenance or by a own developed reports, because SAP is tooooo restrictive in MM02 if this was forgotten when creating the material master. And in this case people often forget that there exists already stock which does not automatically get a batch number.

However, It sounds like an inconsistency and you should contact SAP for an analysis.

Former Member
0 Kudos

Hi Jürgen,

I checked In the MM02 the log of changes and I couldn't see any one related with the batch management... Contacting SAP for inconsistency is exactly what I'm trying to avoid... If there's no other alternative I will do it, though.

Thank you again for your help

JL23
Active Contributor
0 Kudos

such changes with Z-report or direct table maintenance are certainly not reflected in the material master change logs.

I do not know of any legal way to correct an inconsistency, and to suggest other ways, the information given is too small and the root cause not yet determined.

.....and this forum is not the right place to post such suggestions then.

There are not many ways that such an inconsistency can ocur, I know just 2: SAP progams with a bug, own programs with a bug.

If it is caused by a SAP program, then SAP is only one who can correct the programs to avoid that it happens again, and they can correct the situation in your system too.

Former Member
0 Kudos

Thank you Jürgen.

By the way, do you know if it exist any program to adjust stocks for an storage location?

If it helps, in MB52, if I activate " Hierarchical Representation" for my storage location, I can find in the total the real value I would like to find in MMBE. I understand that MB52 is not taking the value fom MARD-LABST (Like MMBE seems to do), so it is calculating "online" the total value.

Edited by: Abel Raya on Mar 22, 2011 4:15 PM

JL23
Active Contributor
0 Kudos

You can adjust stock with phyiscal inventory.

however this is not possible in your case with this inconsistency. And there is no report that can fix this itself. if the root cause is known, it is relativly easy to find a solution.

Contact SAP.

JL23
Active Contributor
0 Kudos

Please read OSS Note 34440 - Procedure for correcting the material master

This gives you a indication what SAP does to correct an inconsistency

Answers (2)

Answers (2)

former_member187989
Active Contributor
0 Kudos

Refer Note 982345 - FAQ: stock overview MMBE

former_member187989
Active Contributor
0 Kudos

What is your selection in MMBE ?

Check stock exists in any other plants/storage location for same material ?

Check any value update changes history for material type in OMS2 ?

Former Member
0 Kudos

1) My selection screen in MMBE is:

- material number XXXXXXXXX

- Also select Special Stocks X

- Also select Stock Commitments X

- Display version 1

- No zero stock lines X

- COmpany code X

- Plant X

- Storage location X

- Batch X

- Special stock X

2) There's no stock for other plants. There are some stock for other storage locations, but those are correct, so the calculation of the batches sum the total of the storage location.

3) There is no changes for the material type in OMS2 and only "Quantity Updating in Material Master Record" and "Value Update in Material Master Record" are marked.

Thank you Jeyakanthan.