Select on MSEG - performance optimalization

Former Member — Wed, 12 Dec 2012 08:57:36 GMT

Hi experts,

I have following selects to execute:

1.     SELECT mblnr matnr dmbtr ebeln menge meins
        FROM mseg
        INTO TABLE lt_mseg
        WHERE mjahr IN so_gjahr
        AND bukrs = p_bukrs
        AND aufpl = ls_act-aufpl
        AND aplzl = ls_act-aplzl.

2.   SELECT mblnr matnr dmbtr ebeln menge meins
      FROM mseg
      INTO TABLE lt_mseg
      WHERE mjahr IN so_gjahr
      AND bukrs = p_bukrs
      AND ps_psp_pnr = l_objnr_tmp.

In MSEG table there are 16M of records and the execution takes very long. Any hints for optimalization? Thank you in advance.

Paul

Re: Select on MSEG - performance optimalization

Former Member — Wed, 12 Dec 2012 09:31:25 GMT

Hello Paul,

You would probably need to extract data in chunks. Could be 50k at one time using appending internal table.

regards,

Deepti

topic Re: Select on MSEG - performance optimalization in Application Development and Automation Discussions

Select on MSEG - performance optimalization

Re: Select on MSEG - performance optimalization