Skip to Content

Performance issue reg BSID and BSAD

Hi,

I'm using one RFC enabled z-FM - which in turn uses a z-structure with following fields --

BUDAT

VBELN

BELNR

WRBTR (sorted as CREDIT and DEBIT )

SGTXT

Now, while fetching records from bsid and bsad table in production, reports gets time-out.

Time-out limit is set to 5 Minutes only.

Here, my question is that if I'm going to use BAPI - BAPI_AR_ACC_GETSTATEMENT - for that account statement, would that make a difference and give the report within the time limit of 5 minutes?

or, should I go for Secondary Index..?

If secondary index is suggested to be preferred, then on which fields should the index be made?

My current query is like -

 SELECT VBELN BUDAT BELNR SHKZG WRBTR SGTXT FROM BSID
             INTO   TABLE IT_BSID
             WHERE KUNNR = KUNNR AND
             GJAHR = TEMP_YEAR AND
             BUDAT BETWEEN TEMPDT AND TO_DATE. 

Where, it_bsid is typed on the z-structure having fields as mentioned below --

VBELN TYPE BSID-VBELN,

BUDAT TYPE BSID-BUDAT,

BELNR TYPE BSID-BELNR,

SHKZG TYPE BSID-SHKZG,

WRBTR TYPE BSID-WRBTR,

SGTXT TYPE BSID-SGTXT,

Can you please give me some idea, as I'm pretty much confused.

Thanks in advance.

Kumar Saurav.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Oct 31, 2010 at 04:05 PM

    Please study the primary key of BSID and then your select query, I'm sure you can find the missing field in your WHERE clause yourself.

    Thomas

    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.