ALV Report performance & export problem

[Former Member]

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

[Former Member]

hi Mallik,

Refer these for performance tuning

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

Regards,

Santosh

[Former Member]

hi

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

[Former Member]

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.