Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Performance issue reg BSID and BSAD

former_member186491
Contributor
0 Kudos
160

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.

2 REPLIES 2

ThomasZloch
Active Contributor
0 Kudos
54

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

0 Kudos
54

Hi,

Yes, resolved that.

Thank you very much.

Kumar Saurav.