[PP] AFRU table data - taking long time to access

Your query is simple but quite bad in terms of performance.

Change it to something like:

SELECT [...]
FROM afko 
INNER JOIN afvc ON afko~aufpl = afvc~aufpl
INNER JOIN afru ON afvc~rueck = afru~rueck
WHERE afko~aufnr = [...]

For more information you can check OSS note 187906 Performance: Customer developments in PP and PM.

출처: http://forums.sdn.sap.com/thread.jspa?threadID=1434770



  clear: lv_xmnga_c.
    select sum( a~xmnga )
      into lv_xmnga_c
      from afru as a inner join afvc as b
                             on a~rueck eq b~rueck
                            and b~aufpl eq gt_itab-aufpl
     where aufnr eq gt_itab-aufnr
       and stokz eq space.

    clear: lv_xmnga_d.
    select sum( a~xmnga )
      into lv_xmnga_d
      from afru as a inner join afvc as b
                             on a~rueck eq b~rueck
                            and b~aufpl eq gt_itab-aufpl
     where aufnr eq gt_itab-aufnr
       and stokz eq 'X'.

    gt_itab-xmnga = lv_xmnga_c - lv_xmnga_d.