12-12-2012 8:57 AM
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
12-12-2012 9:31 AM
Hello Paul,
You would probably need to extract data in chunks. Could be 50k at one time using appending internal table.
regards,
Deepti