topic Re: ALV Report performance & export problem in Application Development and Automation Discussions

ALV Report performance & export problem

Former Member — Fri, 16 Mar 2007 07:23:27 GMT

Hi,

We have developed an complex ALV report which accesses the data from FI Tables like BKPF, BSEG, BSAK etc., There are almost 100 lac records in BSEG and every day around 20000 records are getting added to that. Eventhough I have used specific search criteria, system is taking lot of time. Due to this I forced to run the report in background. In background also it is taking around 4 - 6 hours.

1) How can I improve the performance of the report. Especially to access data from huge database table like BSEG with lot of conditions. Any best practices

2) I want to have an option (at selection screen) to get the report directly saved in a Excel file at desired path.

Please help me.

Thanks in advance,

Mallik

Re: ALV Report performance & export problem

Former Member — Fri, 16 Mar 2007 08:06:57 GMT

hi Mallik,

Refer these for performance tuning

http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm

Regards,

Santosh

Re: ALV Report performance & export problem

Former Member — Fri, 16 Mar 2007 09:10:44 GMT

refer to this link related to performance of FI tables:

/people/rob.burbank/blog/2006/02/07/performance-of-nested-loops

**reward if helpful

regards,

madhumitha

Re: ALV Report performance & export problem

Former Member — Fri, 16 Mar 2007 09:52:17 GMT

Hi Mallik,

Already i faced this problem before. At that time i follow some precuations:

1) Check the estimation cost for that report with the basis people.

2) The selection fields mentionedin the select statement and fields order in the internal; table should match with order of Data base fields order.

3) Define type statements and then refer internal table to that types.

4) Define secondary indexes in the where condition properly.

5) Add BINARY SEARCH to read table statement.

6) if possible attach package size n to the select statement.

7) Avoid nested loops and nested selects.

😎 After populating the final internal table free all the internal tables.

9) check how much time taking for each select statemnt through SY05.

Hope this helps you. reply for queries.

Regards,

Kumar.