Skip to Content
0
Former Member
Dec 12, 2012 at 08:57 AM

Select on MSEG - performance optimalization

23 Views

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