Skip to Content
0
Former Member
Jan 11, 2007 at 02:54 PM

SELECT QUERY

22 Views

This select query

sort itab by lifnr matnr ekorg werks esokz

SELECT lifnr matnr ekorg esokz werks datbi datab knumh

FROM a017

INTO CORRESPONDING FIELDS OF TABLE it_a017

FOR ALL ENTRIES IN itab

WHERE kschl = 'PB00' AND

lifnr = itab-lifnr AND

matnr = itab-matnr AND

ekorg = itab-ekorg AND

werks = itab-werks AND

esokz = itab-esokz AND

datbi GT sy-datum.

is taking a very very long time....the no. of records in itab are 70k and a017 has the equal number. I made sure itab is not empty before this statement is executed. Could someone help me with this...to improve performance....thanks.