SAP Query - BSEG Table with additional fields- Slow Response Time SE30
I am trying to create an ALV format report for SAP Query with doucment header and line item tables of SAP (BSEG) & (BKPF).
In order to join them, I have used table BSEG (to adopt few fields from there) and added new fields with coding to populate data from BKPF.
Query is populating data just fine. The issue is it's reponse time; it takes minutes to populate data.
As a result i performed a runtime analysis from SE30. I found out that database is taking enormous % of time (69%). Further, it was revealed that most of the time in the transaction is being taken by "Fetch BSEG" call.