Skip to Content
author's profile photo Former Member
Former Member

Customer-Reports

Dear Friends,

In the Production server all the customer reports that is FBL5n, Customer over due items are taking 45 mts for one company code for all the customers. Where as the vendor reports are generating within seconds.Can any body help me and advise, why the customer reports are taking so much to generate as the situation is critical to me.

Thanks

Uma

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Feb 26, 2007 at 06:23 AM

    Dear Uma

    I am not sure which SAP release you are using. Either ways please review all these SAP notes for your release 340080, 394388, 532433, 686257, 536859, 671308, 733559, 798255, 960327.

    In case the performance is not better after applying above notes for your release. Please switch on the ST05 trace on tables and find out the select queries causing performance issues. Please create table indexes for these select queries for the fields used in 'Where' condition.

    If this helps please reward with points.

    Best Regards

    Kesav

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Kesav,

      Thanks for the reply. Not that vendors are less. The same data in the development server is getting generated within minutes. I will try to read the notes and we have proceeded with SAP also.

      Thanks

      Uma

  • author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2007 at 05:01 AM

    Hi Uma

    I can only think that you have very few vendors and large number of customer. Else in case my undesrtandng is not correct, then I would suggest that you approach the system administration guys to check the system performance.

    Thanks

    Ashok

    Assign points for useful answer

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.