IH08 : Performance issue

[Former Member]

Hello Guys,

Need your help in below scenario.

User has reported performance issue for IH08 and he is entering below details.

Equipment Selection -> Equipment descriptn = '*AAA*'

General Data -> Equipment category = 'M'

Location Data -> Maintenance plant = '9999'

I debugged and found that IH08 is fetching data from view V_EQUI and it is in include MIEQUI20 (Main Program : RIEQUI20)

FORM select_v_equi_l

   SELECT * FROM (g_viewname)

             INTO CORRESPONDING FIELDS OF TABLE lt_v_equi_iflos

             FOR ALL ENTRIES IN equnr
                       WHERE equnr =  equnr-low
                       AND   eqart IN eqart
                       AND   ingrp IN ingrp
                       AND   rbnr  IN rbnr
                       AND   proid IN proid
                       AND   daufn IN daufn
                       AND   aufnr IN aufnr
                       AND   submt IN submt
                       AND   erdat IN erdat
                       AND   ernam IN ernam
                       AND   aedat IN aedat
                       AND   aenam IN aenam
                       AND   begru IN begru
                       AND   krfkz LIKE krfkz
                       AND   kmatn IN kmatn
                       AND   matnr IN matnr
                       AND   sernr IN sernr
                       AND   charge IN charge
                       AND   kunde IN kunde
                       AND   anlnr IN anlnr
                       AND   hequi IN hequi
                       AND   swerk IN swerk
                       AND   eqfnr IN eqfnr
                       AND   bukrs IN bukrs
                       AND   kokrs IN kokrs
                       AND   gsber IN gsber
                       AND   stort IN stort
                       AND   eqtyp IN eqtyp
                       AND   liznr IN liznr
                       AND   kostl IN kostl
                       AND   serge IN serge
                       AND   tidnr IN tidnr
                       AND   kund2 IN kund2
                       AND   anlun IN anlun
                       AND   iwerk IN iwerk
                       AND   typbz IN typbz
                       AND   beber IN beber
                       AND   mapar IN mapar
                       AND   kund3 IN kund3
                       AND   elief IN elief
                       AND   abckz IN abckz
                       AND   answt IN answt
                       AND   waers IN waers
                       AND   kund1 IN kund1
                       AND   msgrp IN msgrp
                       AND   herst IN herst
                       AND   ansdt IN ansdt
                       AND   heqnr IN heqnr
                       AND   tplnr IN strno
                       AND   vkorg IN vkorg
                       AND   vtweg IN vtweg
                       AND   spart IN spart
                       AND   datab IN gr_datab
                       AND   datbi IN gr_datbi
                       AND   herld IN herld
                       AND   baujj IN baujj
                       AND   invnr IN invnr
                       AND   groes IN groes
                       AND   brgew IN brgew
                       AND   gewei IN gewei
                       AND   eqktu IN eqktx
                       AND   auldt IN auldt
                       AND   inbdt IN inbdt
                       AND   werk  IN werk
                       AND   lager IN lager
                       AND   gewrk IN i_gewrk
                       AND   ppsid IN i_ppsid
                       AND   uii   IN gr_uii
                       AND   (gt_where) .

Out of these many selection parameter , user is using  eqtyp , swerk and eqktu.

Please advice on how to improve performance.

Thanks in advance.

Regards,

Mayur

[shah_viraj]

This message was moderated.

[shah_viraj]

Have a look at below OSS notes:

782017

771364

871622

385914

407169

[Former Member]

Hi Viraj,

I checked above but nothing  is useful . Do you know any other way to improve performance.

[RaymondGiuseppi]

As it is a standard report, look for and read (even if old) OSS notes (*) on IH08 and performance.

(check for version and database)

Then if none is useful, you could consider changing user, creation of secondary index, some modification to force selection of more criteria or implementation of hints, or upgrade of servers...

Regards,

Raymond

(*) Last note seems to be 723484 - Lists: Selection with status long runtime.