Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

If you are using PM Rapid Mart for SAP Version 3.2, you may notice that C_ServiceConfirmation_Section_SAP takes forever to pull data. The join should be optimized for a highly loaded ERP system.

The solution would be to :

a) Better move join conditions from "where" tab to "join" tab. Make it explicitly "inner" join.

b) Give AFRU table a high join rank. This will ensure better performance on delta loads. For the initial load it might sound like a bad idea but we will take care of it in the next step. This will save you on delta loads.

c) Filter AFRU table based on ORIND filed (should be "3") This will ensure you are only getting PM confirmations (not the PP or other ones)

This decreased my load time from forever to only a few seconds. Before optimization, it was trying to parse all 1 millon records of confirmations for only 50 thousand PM confirmations.

Remember to always check generated abap for optimization opportunities.

Labels in this area