|
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.sap-img.com
All the site contents are Copyright © www.sap-img.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
companies. The site www.sap-img.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.sap-img.com or the content authors.
|