topic Re: how to optimize the ABAP select syntax in Application Development and Automation Discussions

how to optimize the ABAP select syntax

Former Member — Thu, 18 Sep 2008 02:32:27 GMT

Dear all:

Anyone can help me to optimize the ABAP syntax like this:

select objid stext from hrp1000

into (itab-plans,itab-plstx)

where plvar = '01'

and istat = '1'

and begda <= pn-begda

and endda >= pn-begda

and langu = sy-langu

and otype = 'S'.

if sy-subrc = 0.

select single * from hrp1001

where objid = itab-plans

and rsign = 'A'

and relat = '008'

and plvar = '01'

and begda <= pn-begda

and endda >= pn-begda

and sclas = 'P'

and otype = 'S'.

if sy-subrc <> 0.

append itab.

clear itab.

endif.

endselect.

In the table hrp1000 has almost 50000 records ,the table hrp1001 200000 records. I found that if i run the ABAP above ,my performance is so bad .

Andone can help me ?

Madhurivs23 — Thu, 18 Sep 2008 03:02:09 GMT

please go through se30->tips and tricks transaction

rgds,

Madhuri

Madhurivs23 — Thu, 18 Sep 2008 03:02:17 GMT

please go through se30->tips and tricks transaction

rgds,

Madhuri

Former Member — Thu, 18 Sep 2008 03:12:23 GMT

Try using this FM and check how is the performance.

RH_READ_OBJECT_SET