Mrp Performance & Archieving data

[phani1994]

When I Run MRP md02 in back ground with planning mode :Delete& recreate it is taking more than 14 hrs . Is there any possibility of Archiving Data So that performance may increase

Is there Any alternative Solution waiting For Reply thanks in Advance

[NTeunckens · Accepted solution]

See the Blogs from caetano.almeida :

• MRP / LTP Reports : link
• MRP Performance Analyzer : link

[phani1994]

I have developed Program caetano.almeida so Everything is green .There is huge data over flow in ztable at time of mrp. Thank you for all replies

[NTeunckens]

Good to see this helped in determining the (main) Issue.

If this is sufficient for you (at this time) please Consider Closing the Question ...

Kind Regards

Nic T.

[Caetano]

Data overflow in Z table makes me think about custom code. I suggest you to check which materials are taking a long time to be planned in MRP using report RMMDPERF and then run a trace in ST12 while planning them using transaction MD03.

[phani1994]

Will archiving data will improve MRP Performance for delete & recreate Planning

[JL23]

You want to say you have a single material that takes 14 hours in MD02 background transaction?

How long does it take in foreground? How long to open MD04?

What info does the job log have, can you post it?

did you already do a performance trace?

What do you want to archive? What do you think which old documents could have this impact on the performance? If old documents are affecting planning runs then I bet you can't archive them as they are probably open and hence in a status that does not allow to archive them.

[phani1994]

No it is not taking 14 hours for one material is taking nearly 6 minutes to 15 minutes have attached file

[phani1994]

I want to know if archive old data Resb has 7200000 records nearly so i thought if we archive last data of last 3- 6 years.

So that MRPperformance could increase

[swathi_rege]

Go through this great document..if you absolutely need to run mrp using mode 3 then consider increasing your parallel processing servers..the blog below should help you and point towards right direction.good luck

https://blogs.sap.com/2014/10/14/analyze-and-improve-mrp-performance/

[phani1994]

Can parallel Processing can be used for md02

[swathi_rege]

No..not for MD02..but you can do that for MD01