Mismatch in Qty between MB51 and MCE3 / MCE7 / Table S012

Advertisement

Hi Experts,
At my client place i am running MB51 report for a material / vendor / particular period / plant / goods receipt movement type 101,102,105,106,122 so that i can get the total receipt quantity in that given period.
After getting the total qty of receipt from MB51, i am runnung 2 LIS reports -- MCE3(vendor analysis Purchase) and MCE7(material analysis Purchase).While comparing the GR qty from MB51 and LIs, getting some huge differences.The LIs report qty is mathcing with table S012.
What could be the issue for differences in qty between MB51 and MCE3 / MCE7.How to analyse the issue and how to go about to overcome the differences.
Thanks.

Advertisement

Hi,
did you see any update problem in your system or any unexpected system restart ? If you say yes, your LIS tables could give different results when we compare with the MB51.
The solution,
Before you get there, first thing to do you need to find which plant, which materials, when and what time it happened. If you could find those information it would help you to fix the problem easly.
For example between 01.01.2009-31.01.2009 and in the plant ZZZ there is a difference amount of quantity in mb51 and MCE3.
And than, using OLIF transaction you need to create a snapshot in a "&(1" version (this is a temporary data), for ZZZ plant between 01.01.2009-31.01.2009. It could take time to create dont worry when you run the program.
When you create the data from OLIF, now using mce3 or mce7 or both you could compare those reports with mb51. But one thing that you need to be careful about that is while using mce3 or 7 you need to choose version "&(1" which we created from OLIF.
If It's OK,
it's time to go to LIS copy management.( using spro -> Logistics - general -> LIS ->Logistics data warehouse -> Data basis -> Tools -> Copy management or transaction MCSZ)
Be careful about before copy process you need to delete 000 version(production version) for specific date time and plant !!! And now you could copy.
PS: Both delete and copy operations could be done by MCSZ.
If It's NOT OK,
you need to check your parameters while using OLIF. And last thing, Each time before you using OLIF you should delete that temporary version from MCSZ.
Best regards
Çağatay ÖZAK

November 30, -0001

Mismatch in Qty between MB51 and MCE3 / MCE7 / Table S012

Hi Experts, At my client place i am running MB51 report for a material / vendor / particular period / plant / goods receipt movement type 101,102,105,106,122 so that i can get the total receipt quantity in that given period. After getting the total q

Diff in result in txn MB51 and MCP9

Dear Friends We find their is a difference between MB51 and MCP9 for mvt type 131 and 132. *(i.e. total of 131,132 in MB51 not maching with MCP9) Thanks Regards NJ Singh 9815300975Dear Mr. Padmasri Garapati Thanks for your valuable reply. In our case

Is it a Bug? Integration between Dreamweaver and Fireworks is broken in somewhere?

I can not upload images related my topic here but you can see it in the same topic at http://www.fireworksguruforum.com/index.php?showtopic=14282 I use CS3 Suite. It is a big trouble for me in working on real pages. Integration is broken in somewhere

Relation between psa and data source

Hi everyone, What is the relation between DataSource and PSA.PSA tables get created when u activate datasource in BW...replication is just required for purpose of Meta data loading for that data source....PSA will store data temporarily when u will l

How to align OS between disks and flash on WAVE-574 without use Rescue CD

The version OS installed on flash of WAVE-574 (4.4.5c.b4) mismatch. I don't know Why and How the version on disk is it different, is it possible after one disk replacement? Is it possible to align OS on WAVE-574 between flash and disks without using

Link between KONA and VBRK/VBRP and KONP and VBRK/VBRP

Hi please suggest me the link between KONA and VBRK/VBRP and KONP and VBRK/VBRP I want to give link of rebate agreement and invoice no/Inv Qty My requirement is I want a report where i can see Under one Rebate agreement ,how many Commercial Invoice u

The problem about Secure Reliable Messaging between WCF and Weblogic

I'm doing a project for testing the interoperability between WCF and Weblogic with secure reliable messaging. When WCF client talk to Weblogic service with Secure Reliable feature enabled.We got error when CreateSequence, the error message is below:

Price difference between PO and after GR

Hi Experts, we have an issue in price after the goods receipt. PO item price for 1PCE is 10EUR. After goods receipt the price is updated in order history as 490EUR at amount in local currency. GR has been done thourgh inbound delivery and no chance o

Diff between prt and raw material type

what is the difference between PRT and raw material material typeHi, Any material type defines the material views (Basic,Purchasing,Storage,Accounting....), Whether internally procured or extrenally procured,special type. whether it requires Qty & Va

Unsure how to sync ibooks between ipad and iphone

A few months ago I downloaded an extensive collection of work documents, in pdf format. They've been saved in ibooks on my iphone. After having synced my phone to my itunes, I currently see that I have those documents in Itunes. However, not knowing

Difference between 122 and 161 movement type

Hi, Can anyone explain me the difference between 122 and 161 movement type? How will be the finance postings? Can these movement types will be used in outbound delivery? If so,what kind of scenarios this can be used? Thanks SriniHi Both are belongs t

Communication between ECC and SCM via XI

I am trying to set up the scenario 'Purchase_Order_Processing' between ECC and SCM using XI. The SCM content for XI has been loaded into XI and this scenario is included in the content. We are running the following: ECC - Version 5.0 - 640 SP level 1

Difference between Java and C#?

What's the difference between Java and C#?Triple(!) post http://forum.java.sun.com/thread.jspa?threadID=674331&tstart=0 http://forum.java.sun.com/thread.jspa?threadID=674329&tstart=0Read other 2 answers

Functional differences between OBISE1 and OBIEE

Hello, beside the licensing restrictions, there are some funtional differences between OBISE1 and OBIEE. I have seen some very neat features in OBIEE which are not implemented in OBISE1, e. g. generating powerpoint or the assistants for bi publisher

Difference between ME58 and ME59

HI, What is the difference between ME58 and ME59 transactions?HI, ME58 allows the user to pick assigned requisitions and manually convert them into POs. First you enter the criteria to select the purchase requisitions. These are then grouped by vendo

Difference between FBL3N and KSB1

Hi, Which can be the reasons of the difference between FBL3N and KSB1. I understand that these reports have to have the same value. Regards, PabloHi, FBL3N gives the GL line Items, which includes GL accounts created with Cost Element as well as witho

Performance difference between page and scroll

Hi experts: What is the technical difference between paging and scrolling, especially as pertains to database access and performance?  The scenario would be a table result in a view where 200 results exist for a query.  A scrollable table would show

PS roles for making object links between cProjects and PS

Hello to everybody! Does anybody could give me a favour and tell which role I should grant to the user in order to allow him make object links between cprojects and PS elements from cProjects. I have already granted authorization to CJ01, CJ02, CJ03

TO get graph between month and value

Hi Gurus, Please help me , i had to make Graph between values and month and for every year lines should be different . its basically a stock vs time graph thorough ABAP coding. i had itab which have value for every month , but how to plot it i not ab

My phone automatically toggles between silent and ringer mode. How to fix ?

my phone automatically toggles between silent and ringer mode. How to fix ?Hey there Sam1011, It sounds like you are not flipping the side switch but the phone keeps muting and unmuting by itself. I would start by toggling the side switch manually to