Split the Select Query

[Former Member]

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

[Former Member]

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]

Hi,

Duplicate posting not allowed.

Sujay