Performance issue in Tcode FAGLB03

[Former Member]

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.

[Clemenss]

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

[Former Member]

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.

[Former Member]

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