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.