SAP Note

Header Data

Symptom

You want to compare the stock values in MM with stock accounts in FI. You use report RM07MBST to do this. This report has a long runtime due to large datasets in your system and terminates with too high a data volume.

Other Terms

RM07MBST, RM07MMFI, MB5L, balance comparison, TSV_TNEW_PAGE_ALLOC_FAILED, DBIF_RSQL_INVALID_RSQL.

Reason and Prerequisites

In addition to just the balance comparison, report RM07MBST can also issue the list with all materials. The system therefore reads the information for all materials. This requires a long runtime and a large memory space. If you do not need the information at material level, you can use the new report RM07MMFI. Report RM07MMFI can:

l Compare the balances between MM and FI for the current period, previous period or the previous year.

l Output the values at stock account level.

l List the values according to valuation classes by forward navigation (when you double-click an account).

l (As of the transport dated June 22, 2000) The values are listed by valuation area by forward navigation to the totals line of the company code (see Note 310314).

l You can only enter the company code as a selection parameter. A restriction to one general ledger account would not improve the runtime since the system would still carry out the comparison for all accounts.

The following differences cannot be caught due to technical reasons:

l

l The report does not block materials. Therefore, differences seem to exist if you post in the analyzed period during the runtime. It is best to start the report only if you do not post. If this is not possible, start the report several times. If the difference is constant, this is an actual difference and not a blocking problem.

l Error in previous periods according to Note 203350.

l If you use the country version of India, differences can occur since in a special development for India, the stock value is not updated in the same transaction/event in which the posting is executed in FI.

l See Note 921161. It is a follow-on note with a new version of RM07MMFI.

Solution

!!! Caution: Only download from SAPSERV if neither RM07MMFI nor RM07APP1 are active. The report is available on sapservX as a transport AL0K028563 in directory

198596 - Fast MM-FI balance comparison (replacement of RM07MBST)

Version 22 Validity: 22.07.2008 - active Language English

Released On 22.07.2008 15:47:20 Release Status Released for Customer Component MM-IM Inventory Management Priority Correction with medium priority Category Performance

general/R3server/abap/note.0198596 The transport contains reports RM07MMFI and Include RM07APP1. These reports are contained in the standard system as of Release 4.6C and will be updated by the transport. This transport contains Version 20010625 of RM07MMFI (to be checked in the report source code, constant g_rm07mmfi_version). The version is also printed on the report list in date format. Refer also to Note 13719 for information about implementing the correction in your system. The first time you execute the report, it may terminate before the selection screen is displayed. This shows that the report has adjusted itself to your release. Now, start the report again (as of Release 4.5, activate/generate it beforehand in transaction SE38). Comments about translating ABAP keywords: The preliminary transport of this report only delivers very limited language support. For technical reasons, only the German text elements are displayed. The English texts are defined in the source code. On the selection screen, only the initials are displayed. If you want to have texts here, use transaction SE38 to maintain the following selection elements under Goto -> Text elements -> Selection texts/Goto -> Translation in the language you require Name Text (German) Text (English) COMPCODE BuchungskreisCompany code CURRENTAktuelle Periode Current period PP_PERIVorvorperiodePeriod before last PP_YEARVorvorjahr Year before last PRE_PERI Vorperiode Previous period PRE_YEAR VorjahrPrevious year If you want the output in a language other than German or English, the text elements must be translated accordingly. To help, all text elements are given here in English: Symbol Text 001 Company code 002 Period 003 Currency 004 G/L acct 005 Value of materials 006 Value of G/L account 007 Variance 008 Total 100 Valuation area & does not exist 101 Company code & does not exist for valuation area & 102 Transaction BSX does not exist in chart of accounts & 103 Valuation grouping & of valuation area & deleted for chart of accounts & 104 Valuation class & in valuation area & deleted for chart of accounts & 105 Account determination not possible for chart of accounts & / valuation grpg & / valuation class & 106 Transaction BSX in chart of accounts & allows account grouping 107 Varying accounts for chart of accounts & / valuation grpg & / val. class & 108 Value & & in segment (& / &) 109 Account & in company code & cannot be read 110 Company code & does not have a material administration record 111 Error 112 Warning messages 113 Messages 114 No authorization for account & in company code & 115 Valuation area 116 Valuation class 117 Total materials 118 No company code found in selection 201 The stocks for the chosen period cannot be determined in company code & Caution: When you implement this note into your system, ensure that you implement the current version of the include RM07APP1 from Note 945346.This is only required for Release 5.00 or higher.

Validity

This document is not restricted to a software component or software component version

References

This document refers to:

SAP Notes 1390931 Steps to be followed in the case of Database Crash

994184 Schiefstandsanalyse im MM und FI nach Datenbankabsturz 921161 RM07MMFI: Improvement of runtime and function 599218 MB5B: Composite SAP Note for Release >= 4.0B 03/2004 520010 FAQ: Inconsistencies in inventory management

This document is referenced by:

SAP Notes (14)

497391 MB5L: Valuated stocks with subcontractor in OBEW 414970 xxx RM07MMFI: Functional improvements 413045 xxx RM07MMFI: Error for previous period in upgrade period 386846 xxx data selection redesign RM07MMFI 315326 xxx RM07MMFI: Incrrct values in prev. year or prd befr last 313803 xxx RM07APP1: Routine GET_RELEASE does not exist 310024 xxx RM07MMFI: RM07MMFI:Error in previous periods after upgra 215839 MB5L: Balance variance when using selections 203350 Notes on stock value/balance comparison 203338 xxx RM07MMFI: No check in current period

32236 Incorrect stock qty or stock value in material master

520010 FAQ: Inconsistencies in inventory management 599218 MB5B: Composite SAP Note for Release >= 4.0B 03/2004 921161 RM07MMFI: Improvement of runtime and function 313803 xxx RM07APP1: Routine GET_RELEASE does not exist 315326 xxx RM07MMFI: Incrrct values in prev. year or prd befr last 310024 xxx RM07MMFI: RM07MMFI:Error in previous periods after upgra 413045 xxx RM07MMFI: Error for previous period in upgrade period 414970 xxx RM07MMFI: Functional improvements 386846 xxx data selection redesign RM07MMFI 203338 xxx RM07MMFI: No check in current period 203350 Notes on stock value/balance comparison 215839 MB5L: Balance variance when using selections 32236 Incorrect stock qty or stock value in material master 497391 MB5L: Valuated stocks with subcontractor in OBEW