FBL5N times out

[Former Member]

Hi Sappers!!

When the user tries to run FBL5N with one company code and one business area, the transaction gets a short dump. Basically way too much data. The report is very important.

I thought of splitting the report based on account groups but that's too much of work I guess as this report needs to be run frequently by the user.

Is there any other way of getting customer open items for customers per company code AND per business area?

Custom repot is the last option....

Thanks for your time!!

[Former Member · Accepted solution]

Check from when the postings are happening? Try restricting by date. It seems that the customers line items are not cleared on a regular basis.

Try clearing them using F.13 or F-32 and see the performance. Or instruct your basis guy to increase teh time put period.

This should solve your problem

Reward if useful.

sarma

[Former Member · Accepted solution]

Thanks for your inputs!

I cannot ask for more memory from Basis.

Regarding F.13 I need to ask one question: clearing through F.13 will still display the open items in FBL5n? The user is using FBL5N to display open items.

Thanks again!

Edited

[Former Member]

Cleared open items.

[former_member188826]

The very first thing you could try is ask the user to run in background and get the spool.

[Former Member]

Thanks for your response!

The transaction failed in foreground and background.

Can I maybe run execute a report on BSID table.

I think it has all the fields that are displayed in FBL5N.

Would it crash like it did for the background job?

Appreciate your time!

[former_member188826]

If you are just after open items , you can certainly go ahead.

[Former Member]

The transaction failed in background?? How much time did it take before failing in background?

Also, if you are running this for a single customer, it should not fail unless you have way too many records, probably more than 600-700k.

We used to have the same problem before for F-32. When we enter a document number and press enter, the system would not go to the next screen to show the document for 10 minutes. We then de-activated a BTE (Business transaction event) in FIBF that did the trick.

The thing is, we had too many dispute cases for that specific customer and FBL5n was looping on all the dispute cases for each document. Try getting your ABAPer debug FBL5n and see if there are any BTE's ...that are prolonging the process.

Assign points if found useful. Thanks

[Former Member]

Debug FBL5N?

It uses a standard SAP program.

I think I mentioned this before, there is way too much data and I am looking for an alternative way to get the report.

I don't think my ABAPer would modify standard SAP program.

[Former Member]

I am stuck at one point.

In the BSID table, field open items at key date is not available.

This field is required.

Would appreciate your comments!

[Former Member]

VR

Yes, you can debug FBL5n.

I am not asking you to change the program. I know we cannot do that.

You can debug FBL5n with the help of an ABAPer to find at what point the program is taking long times. We did the same thing and found that there is a BTE, which was taking unnecessarily longer times.

We then opened a note to SAP and they suggested us to deactivate a BTE, which we later did and found tremendous improvement in performance.

[Former Member]

Hi,

In the production just check the customer group field status which is assigned

for the creation of that customer when u try to execute.

even i got the Short Dump when i am executing the MIRO so

i was checking for two 3 days then i came to know when all the vendor groups

field status are supressed i couldnt run the MIRO in quality test, but in Dev

all the field status is option for that group so i transported and got solved

so i guess u also might have done same mistake

Regards,

Padma

[Former Member]

Hmm..

Not sure how the customer field status is relevant to getting a short dump becasue of large data...

[Former Member]

You could write abap query and use logical database DDF

pls assign pts to say thanks.

[Former Member]

Thanks for your time!

Can you elaborate a lil on that?

I am not familiar with ABAP lingo