topic Re: Performance issue in Tcode FAGLB03 in Application Development and Automation Discussions

Performance issue in Tcode FAGLB03

Former Member — Fri, 18 Feb 2011 12:18:50 GMT

Hi,

We are exectuting the Tcode FAGLB03, While checking the line items at BALANCE (when you double click on BALANCE to display the documents for a period) it is giving the TIME OUT error. (Going into DUMP due to time out).

We have created a new Z ledger and ZFLAGFLEXA table. There is dynamic inner join on ZFLAGFLEXA and BKPF where it is taking long time to execute.

Are there any OSS Note or any way we can increase the performance of the Tcode.

There is no enhancement done from ABAP for ZFLAGFLEXA table. This is done from customizing side.

Thanks and Regards,

Shravan G.

Re: Performance issue in Tcode FAGLB03

Clemenss — Fri, 18 Feb 2011 14:16:11 GMT

Hi shravan,

first way out is to increase the online time limit.

You may check the dynamic inner join on ZFLAGFLEXA and BKPF. It may be replaced using BSEG secondary index tables BSIS and/or BSAS.

Regards,

Clemens

Re: Performance issue in Tcode FAGLB03

Former Member — Fri, 18 Feb 2011 16:11:35 GMT

Hello,

two tips:

1. Use PACKAGE SIZE addition with the select statement

2. Look for join condition and opportunity to use other conditions.

Thanks.

Krish.

Re: Performance issue in Tcode FAGLB03

Former Member — Fri, 18 Feb 2011 18:17:29 GMT

Hi Shravan,

Maybe check if the following note is applicable:

[Note 1384389 - FAGLB03: Performance during drilldown (entry view)|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1384389]

Kind regards,

Robert