Split the Select Query

Former Member — Thu, 23 Sep 2010 10:33:14 GMT

hello ,

can anyone help me how to split this above mentioned query in chunks

like i have 2 'IN' operator... keeping that in mind that both the IN operators have around 10000 values so needs to be chunked...

please help me in splitting this SQL

SELECT MATNR ERNAM

INTO TABLE IT_MARA_FINAL

FROM MARA

WHERE MATNR = '100-100'

OR MATNR = '000000000000000170'

OR MATNR IN ('000000000000000038', '000000000000000043',

'000000000000000058', '000000000000000059',

'000000000000000068', '000000000000000078',

'000000000000000088', '000000000000000089',

'000000000000000098','000000000000000023' )

AND MATNR LT '000000000000000089'

and ernam = 'AAA'

or ernam in ('BBB','CCC','DDDD').

Moderator message: please continue your original thread, do not open duplicates.

locked by: Thomas Zloch on Sep 23, 2010 1:20 PM

Re: Split the Select Query

Former Member — Thu, 23 Sep 2010 11:13:03 GMT

Search about "PACKAGE SIZE"... I remember something like SELECT ...INTO... PACKAGE SIZE n

where n is the number of records to be processed first. Please share it with us once worked or solution that worked for your issue.

Former Member — Thu, 23 Sep 2010 11:14:12 GMT

Hi,

Duplicate posting not allowed.

Sujay