Select on MSEG - performance optimalization

[Former Member]

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.

BR

Paul

[Former Member]

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.

BR

Paul

[Former Member]

Hello Paul,

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

regards,

Deepti