I am doing select statement from two tables BKPF and BSET ,both the tables are taking too much time. Following is the query.
Select ... .... FROM BKPF into table itab2 for all entries in itab1 WHERE <primary keys> and XBLNR = itab1-Xblnr.
Select ... ... FROM BSET into table itab3 for all entries in itab2 WHERE BELNR = BELNR.
These two queries are taking two much time due to heavy data in BKPF and BSET is a cluster table.
So, any suggestions?