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.
|