Database load on BKPF table
I am trying to reduce the databse load on BKPF table in my program.
I have written the select as follows:
SELECT BUKRS BELNR GJAHR BLART BUDAT AWKEY FROM BKPF
INTO TABLE IST_BKPF
FOR ALL ENTRIES IN IST_EKBE
WHERE BUKRS IN S_BUKRS AND
GJAHR = IST_EKBE-GJAHR AND
AWKEY = IST_EKBE-AWKEY.
AWKEY is obtained as follows:
LOOP AT IST_EKBE INTO WA_EKBE.
CONCATENATE WA_EKBE-BELNR WA_EKBE-GJAHR INTO WA_EKBE-AWKEY.
MODIFY IST_EKBE FROM WA_EKBE TRANSPORTING AWKEY.
CLEAR : WA_EKBE.
I have used all the primary keys available on BKPF table,please suggest me as to how i can reduce the load on it.
Presently the load is around 85% on BKPF table itself.
Thanks in advance