topic Re: FBL3N - Issue in Application Development and Automation Discussions

FBL3N - Issue

Former Member — Sat, 19 Oct 2013 06:05:57 GMT

Dear Expert

Am facing a serious issue with FBL3N T.code while am running this slandered t code it is taking much time generate out put approximately 10 minutes

input Screen

Company Code

G/l A/C

Business Area

All items : 15/10/2013 to 15/10/2013

I Have traced the particular transaction through ST05 this way i came to know this is happening due to TABLE -BSIS

Kindly suggest me how to resolve this issue

Re: FBL3N - Issue

former_member191939 — Sat, 19 Oct 2013 06:35:58 GMT

Hi Ajeesh,

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,

Eugene

Re: FBL3N - Issue

Former Member — Mon, 21 Oct 2013 05:13:03 GMT

I would be most grateful if anyone could provide me a solution

Regards

AJEESH.S

Re: FBL3N - Issue

nabheetscn — Mon, 21 Oct 2013 05:21:40 GMT

Since its a standard report please search for OSS for the same. For example i searched and found below mentioned notes for the same. Check if its relevant for you.

Re: FBL3N - Issue

Former Member — Mon, 21 Oct 2013 05:26:20 GMT

Dear Ajeesh .S,

check the below link.

http://scn.sap.com/thread/1538675.

Re: FBL3N - Issue

Former Member — Mon, 21 Oct 2013 06:13:16 GMT

Dear Expert

DB20

Table stats where last updated on 25.08.2013

Regards

Ajeesh.s

Re: FBL3N - Issue

Former Member — Mon, 21 Oct 2013 06:14:21 GMT

Dear Expert

Your notes list is not visible please give me a visible on

Regards

Ajeesh.s

Re: FBL3N - Issue

nabheetscn — Mon, 21 Oct 2013 06:24:58 GMT

1070629
676338
596865
1135916
1306400
1118110
1238122
194842
960327
904163

Re: FBL3N - Issue

RaymondGiuseppi — Mon, 21 Oct 2013 06:44:19 GMT

NB: Click on the picture to display in original resolution

Nothing prevents you from executing or asking basis to execute, an OSS search with the exact level of your system
In ST05 result did you click on Explain to analyze Execution Plan ?
Did you actually read Note 1135916 - Line items: Help for analysis for long runtime mentioned by Ranu (also in nabheet's list) => Look for "business area" in the note

Regards,

Raymond