Skip to Content
0
Former Member
Jul 28, 2016 at 09:36 AM

Select Query using ForAllEntries with Huge Internal Table

1735 Views

Hi All,

I'm currently facing query which takes ages to load (or even Dump when it takes too long).

I have a internal table "itab" which contained tons of data, [49927x30(336)]Standard Table, and i have a query as below which will do ForAllEntries on mentioned internal table.

SELECT a~vkorg a~kunnr a~vbeln b~sfakn b~fksto

INTO TABLE it_bill FROM vrkpa AS a

JOIN vbrk AS b ON b~vbeln = a~vbeln

FOR ALL ENTRIES IN itab WHERE a~kunde IN r_kunde

AND a~vkorg IN s_vkorg

AND a~fkart IN ('Z01','Z51')

AND a~vbeln = itab-vbeln.

Please help to guide how to make the query processed much faster.

Thanks!