cancel
Showing results for 
Search instead for 
Did you mean: 

mard and mbew(mbewh) Incorrect stock qty or stock value in material master

new163wang
Explorer
0 Kudos

What should be done if the total inventory of materials in the SAP accounting view does not match the inventory of MB52

1. Inventory is 0 (marked LABST=0);

2. Accounting view of material master data (report mc.9, quantity is 0, inventory price is negative, total inventory quantity in mm03 accounting view is -3, price is negative);

3. Material Master Data Accounting View Table (mbew LBKUM is negative, inventory price is negative);

4. The total quantity result (quantity balance) of this material is 0 (the combination of mb5b is 0);

Sap tcode MM03:Qty=-3

Sap tcode mmbe,mb52:Qty = 0

Sap tcode mc.9:

Sap table: mard,mbew,mbewh

Accepted Solutions (0)

Answers (3)

Answers (3)

new163wang
Explorer
0 Kudos

Thank you all, the problem has been resolved. Let me share with you the basic ideas:

(No need to install the inspection report mentioned in the note 32236)
1、MB51 identifies the material voucher data that occurred and identifies the data with a price of 0;
2、Adjust data in conjunction with backend configuration quantity and value updates;

By selecting or canceling “Value Update” and Collaborate with inventory or material documents (for example:migo,mb11,mi10..), renew MM43/MM03,Table MBEW,MBEWH data.

raymond_giuseppi
Active Contributor
0 Kudos

Read first KBA 1618888 - How to deal with stock inconsistency? (before trying to install check reports...)

new163wang
Explorer
0 Kudos

Referenced solution: note 32236