Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Database load on BKPF table

Hi Experts

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.

ENDLOOP.

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

Rehman

Former Member
Not what you were looking for? View more on this topic or Ask a question