I'm using one RFC enabled z-FM - which in turn uses a z-structure with following fields --
WRBTR (sorted as CREDIT and DEBIT )
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.