MC.9 Correction and Comparison With GL Accounts 

The MC.9 report is a Logistics Information Systems (LIS) report using tables S031 and S032. The tables in LIS are usually updated monthly at the end of each period.
Correction program for updating info structure S039, MC.9 report.
The program used for MC.9 is RMCB0300.
It is related to info structure S039.

Symptom
1. Information structure S039 does not contain actual data.
2. In the standard analyses of Inventory Controlling, table S039 is specified in the selection log.

Additional key words
Plant analysis, storage location analysis, material analysis, MRP controller analysis, business area analysis, material group analysis, division analysis, material type analysis, batch analysis, MCBA, MCBC, MCBE, MCBG, MCBI, MCBK, MCBM, MCBO, MCBR, RMCB0100, RMCB0200, RMCB0300, RMCB0400, RMCB0500, RMCB0600, RMCB0700, RMCB0800, RMCB0900, RMCB1000 MC.1, MC.2, MC.3, MC.4, MC.5, MC.6, MC.7, MC.8, MC.9, MC.A, MC.B, MC.C, MC.D, MC.E, MC.F, MC.G, MC.H, MC.I, MC.J, MC.K, MC.L, MC.M, MC.N, MC.O, MC.P, MC.Q, MC.R, MC.S, MC.T, MC.U, MC.V, MCBA, MCBC, missing data, S039, type 'D', info structure, blank, S031, S032, RMCBS039, data, updating.

Cause and prerequisites:
The Inventory Controlling data is kept in two information structures for technical reasons::
1. S031: Material movement data on monthly basis (weeks ... and so on)
2. S032: Current stocks and stock values

Table S039 is used as view in reporting that links tables S031 and S032 and furthermore contains all additional fields that are not stored in the database but are only calculated from other key figures at runtime.

Example: Range of coverage.

Furthermore, table S039 has the following function:

a) storing planned figures for planned/actual comparisons in the standard analysis.
b) creating a flexible analysis in Inventory Controlling. Table S039 is used as reference. Note that the actual data must be written to table S039 by report RMCBS039. 

Solution:

The behavior corresponds to the design.

There is a standard report MC.9, in which the current stocks will appear. 
 

In my company there are matching with some of the g/l accounts.  But my doubt is, mc.9 is giving current stock and value.  How can it be matched with g/l accounts as g/l accounts include the values of already happened values.

You can compare the G/L account values from MC.9 with the Balance from transaction FS10N.

I have noticed this report is correct in most of the cases.

OBY6 - for your company code check the fiscal year variant from the company code details.

OB29 - select the fiscal year variant, click on periods.

Here you can see the Month, Day , Period.

For e.g. if your fiscal year variant is V3.

Just check if the 3rd month ends on day 31st, & 4th month ends on 30th. if this setting is present then the reports should tally.

Usually these do not tally & the reports show different values.

Get help for your SAP MM problems
SAP MM Forums - Do you have a SAP MM Question?

SAP MM Books
SAP Material Management Certification, Interview and Configuration Reference Books

SAP Material Management Tips
SAP MM Configuration Tips and Materials Management Discussion Forum

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.