topic Re: RESB-Fetching in Application Development and Automation Discussions

RESB-Fetching

Former Member — Thu, 01 May 2008 06:06:20 GMT

How to improve the performance while fetching data from RESB table

Re: RESB-Fetching

Former Member — Thu, 01 May 2008 06:21:12 GMT

hi,

1. Use all the primary key fields in the where condition of your select statement.

2. Do not use joins.

3. Select only the required entries ... rather than selecting all the entries ...

4. Make use of secondary indexes explicitly when using non key fields in your select statements..

Regards,

Santosh

Re: RESB-Fetching

Former Member — Thu, 01 May 2008 06:57:26 GMT

hi santose,

thank u for ur response.

i have tried but till it takes long time....

Re: RESB-Fetching

Former Member — Thu, 01 May 2008 06:59:39 GMT

Hi Friend,

Can you Give me the Select Statement That u r using.

Regards,

Suresh Linga.

Re: RESB-Fetching

Former Member — Thu, 01 May 2008 10:40:35 GMT

hi,

s_matnr ,s_werks are Select-option variables.

IT_RESB is the intermediate table.

SELECT MATNR WERKS BDTER

INTO TABLE IT_RESB

FROM RESB

WHERE matnr IN s_matnr AND

werks IN s_werks .

please give me the correct solution...

Regards

Nihtiyanandam.S

Edited by: Nithiyanandam Somasundaram on May 1, 2008 12:43 PM

Re: RESB-Fetching

Former Member — Thu, 01 May 2008 11:40:22 GMT

hi,

few suggestions:

1) Check if there is a secondary index on matnr and werks. Probably it will be there.

2) Use the following code to fetch data.

DATA: s_cursor TYPE cursor.

OPEN CURSOR WITH HOLD s_cursor FOR

SELECT MATNR WERKS BDTER

FROM RESB

WHERE matnr IN s_matnr AND

werks IN s_werks .

DO.

FETCH NEXT CURSOR s_cursor

APPENDING

TABLE IT_RESB

PACKAGE SIZE '2000'.

IF sy-subrc <> 0.

CLOSE CURSOR s_cursor.

EXIT.

ENDIF.

ENDDO.

Re: RESB-Fetching

Former Member — Fri, 02 May 2008 03:04:46 GMT

Hi,

can u tell me

what is the maximum package size .because in resb table having lot of data....

Re: RESB-Fetching

Former Member — Mon, 05 May 2008 18:44:47 GMT

Hi ~

One small addition - You might be already checking it in the code but just wanted to double check with you.

Check the range s_matnr is not initial before the RESB select query. Otherwise it fecthes all the data from RESB table.

Thanks,

- Srikanth.