Performance issue reg BSID and BSAD

94 Views

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.