Performance issue fetching huge number of record with "FOR ALL ENTRIES"

Hello,

We need to extract an huge amount of data (about 1.000.000 records) from VBEP table, which overall dimension is about 120 milions records.

We actually use this statements:

CHECK NOT ( it_massive_vbep[] IS INITIAL ) .

SELECT (list of fields) FROM vbep JOIN vbap

ON vbep_{vbeln = vbap}vbeln AND

vbep_{posnr = vbap}posnr

INTO CORRESPONDING FIELDS OF w_sched

FOR ALL ENTRIES IN it_massive_vbep

WHERE vbep~vbeln = it_massive_vbep-tabkey-vbeln

AND vbep~posnr = it_massive_vbep-tabkey-posnr

AND vbep~etenr = it_massive_vbep-tabkey-etenr.

notice that internal table it_massive_vbep contains always records with fully specified key.

Do you think this query could be further optimized?

many thanks,

-Enrico