Skip to Content

fluctuation of % MRP .....

Dec 14, 2016 at 02:46 PM


avatar image
Former Member

While Calculating MRP% Report. We apply Vlookup in 2 reports ( MB51 & Z_MM_60 ) to get common items of VB, ND & #N/A.

So what #N/A items denotes, they come under VB , ND or in Some other. Also Some items after running MRP (MD02). Does not comes under VB after applying Vlookup in Excel File.Is this a problem of Schedule line generation ?? Why is so that ?? DUE TO THIS OUR %MRP REDUCES.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jürgen L Dec 14, 2016 at 08:02 PM

I read it several times but do not really get any idea about what you are talking. All sentences are just half and do not connect into any logical flow.

Also I do not know what %MRP is. As well is a Z_MM_60 totally unknown to strangers, as it is a home made program.

Further we do not see what you have in Excel and where you put your VLOOKUP formula and how this was defined, I just know from experience that many people have quite some difficulties using VLOOKUP

Maybe you should re-read your question again from a stranger point of view who has not seen your Excel, and not seen your transactions and does not know anything about your goal. Then re-write the questions and provide screenshots to make it more understandable.

10 |10000 characters needed characters left characters exceeded