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!