cancel
Showing results for 
Search instead for 
Did you mean: 

FBL3N T-code takes lot of time to produced output.

Former Member
0 Kudos

Hi expert,

FBL3N T-code takes lot of time to produced output.

and many times accure TIME_OUT Runtime error.

REgards,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Vivek,

When you run the T-code FBL3N , Monitor SM50 and check the tables and run the statistics on the specified tables using Db20 t-code.

Refer to below link for more information.

http://help.sap.com/saphelp_nwpi71/helpdata/en/45/d59f51b3735594e10000000a1553f7/content.htm

Also

Refer to Note 1135916 - Line items: Help for analysis for long runtime

Check whether a suitable database index has been created in the dictionary (transaction SE11 -> indexes). If no index has been created, create the corresponding index and activate it.

Possible fields may be:

BSIS/BSAS: MANDT, BUKRS, HKONT, BUDAT

BSIK/BSAK: MANDT, BUKRS, LIFNR, BUDAT

BSID/BSAD: MANDT, BUKRS, KUNNR, BUDAT

Regards,

Sravanthi

Edited by: Sravanthi.sap on Jan 9, 2012 10:17 PM

Answers (2)

Answers (2)

Former Member
0 Kudos

Dear Vivek

We also face same issue with fbl3n,only solution you can give is to ask the user to run in Background,This tcode search bsis,bsas tables which have lakhs of entries.So better to run in Background..Is your system upgraded from 4.7 ?

Former Member
0 Kudos

thanks to all

Former Member
0 Kudos

Hi Vivek,

Is this a strange behavior, that is noticed recently ??

Check, for the following,

Version changes of the reports that being called thru this Trx.

Tables size, for all tables that are being called.

Stats of these tables & index updates .

check the selection criteria, if any, and try to rebuild index, based on those fields.

check the variant, that being used, may be there could be infinite looping. Try doing a debugging, with help of an ABAPer.

check the cost of the SQL queries, thru ST04 > Wait Event Analysis > session Monitoring > (select the SQL statment) and click 'Explain'.

hope this helps!!

~Rajesh