2019-11-07 2000331
2000331 - MB5B shows different results for the same
data
Version 13 Type SAP Knowledge Base Article
Language English Master Language English
Release Status Released to Customer Category How To
Component MM-IM-GF-REP (IM Reporting (no LIS)) Released On 30.10.2019
Please find the original document at https://launchpad.support.sap.com/#/notes/2000331
Symptom
Several runs of the report MB5B for the same selection criteria show different results, even when the report is
executed in a period which has already been closed.
Environment
• Materials Management (MM)
• SAP ERP Central Component
• SAP ERP
• SAP enhancement package for SAP ERP
• SAP enhancement package for SAP ERP, version for SAP HANA
• SAP S/4 HANA
Cause
There are postings during the runtime of the report.
The calculation in MB5B is done by reading the current stock level and the goods movements for the material
and working backwards to calculate the stock on the required date. So postings during the runtime can falsify
the results. The results of MB5B on the stock value and stock quantity of past periods can be different if there
are ongoing goods movements in the system.
The only source of information for MB5B is the current figures in the tables and the postings that have been
performed. This way, goods movements posted during the execution of the report can lead to different figures
even in closed periods.
MB5B is just a report: it does not perform any locking and it is indeed possible to post goods movements
while the report is being executed. These goods movements can be in different "status": For example, the
following scenario might happen if a goods movement is posted while MB5B is running:
1. MB5B reads the table MBEW to get the current stock and value information.
2. The current posting has not updated MBEW yet.
3. When MB5B reads MBEW the information of the current posting is not yet updated into this table.
4. However, the document was already in the table BSIM when the data in this table was being analyzed.
5. Therefore, these accounting documents would have reduced the opening and closing values for the
timeframe being analyzed.
Posting during the runtime of the report will always cause this type of problem, even in closed periods. This is
due to the fact that there is no static information about the stock or value levels in the past in the system.
© 2019 SAP SE or an SAP affiliate company. All rights reserved 1 of 2
2019-11-07 2000331
Resolution
Run transaction MB5B in a timeframe when there are no postings for the analyzed materials. Then several
consecutive runs of the report will deliver the same result.
Please refer to SAP Note 1005901 which also confirms this logic.
Keywords
ECC, Previous Period, Closing Stock, Closed Periods, MBEW, BSIM, Note 1005901, Opening Value, Closing
Value, Hierarchy, Total, MB5B, GOODS ISSUE, GOODS RECEIPT, Different Values, Different Results,
RM07MLBD, Total, Hierarchical, Non-Hierarchical
Products
SAP ERP Central Component all versions
SAP ERP all versions
SAP S/4HANA all versions
SAP enhancement package for SAP ERP all versions
SAP enhancement package for SAP ERP, version for SAP HANA all versions
Other Components
Component Description
MM-IM-GF-INC Stock Inconsistencies
This document refers to
SAP Note/KBA Title
1772782 MB5B: Detailed information about opening and closing stock
1005901 MB5B: Performance problems
© 2019 SAP SE or an SAP affiliate company. All rights reserved 2 of 2
