16 Replies Latest reply: Jun 5, 2013 10:05 AM by Suhas Saha RSS

SAP Query - BSEG Table with additional fields- Slow Response Time SE30

Arslan Q
Currently Being Moderated

Hey All,

 

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.

 

I need to make few reports with these tables. Please advise; is there anything i can do to reduce this reponse time.

 

Thank You

Actions