ABAP Performance Tunning

[Former Member]

Hi Guru's,

how to optimize the following select query

SELECT A~AUFNR A~AUART A~OBJNR B~EQUNR
  FROM AUFK AS A
  INNER JOIN AFIH AS B
  ON B~AUFNR = A~AUFNR
  INNER JOIN IHPA AS C
  ON C~OBJNR = A~OBJNR
  INNER JOIN JCDS AS D
  ON D~OBJNR = C~OBJNR
  INTO CORRESPONDING FIELDS OF TABLE LT_ORDER
  WHERE stat  = lc_i0009 OR stat  = lc_i0045.

Thanks & Regards,

Meenachi.R

[Former Member]

Hi Guru's,

how to optimize the following select query

SELECT A~AUFNR A~AUART A~OBJNR B~EQUNR
  FROM AUFK AS A
  INNER JOIN AFIH AS B
  ON B~AUFNR = A~AUFNR
  INNER JOIN IHPA AS C
  ON C~OBJNR = A~OBJNR
  INNER JOIN JCDS AS D
  ON D~OBJNR = C~OBJNR
  INTO CORRESPONDING FIELDS OF TABLE LT_ORDER
  WHERE stat  = lc_i0009 OR stat  = lc_i0045.

Thanks & Regards,

Meenachi.R

[nabheetscn]

Hi

Why are you doing select on JCDS you can have try to use JEST if it suits your requirement. JEST has an index created on stat field..Any reason for choose JCDS.?

thanks

Nabheet

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[former_member219762]

Hi Meenachi,

Define view in dictionary and use it.

Regards,

Sreenivas.

[former_member202771]

This message was moderated.

[Former Member]

Hi,

I  I guess for better understanding you can split the select queries instead of joins in a one select. If you split the queries and may be database hits may be reduced.

-> get the OBJNR inner join of two table JEST and IHPA into table it_obj where Status in ( I0009,I00045)

* No relavent secondary index find to read Order Numbers(AUFNR) 

-> Get the AUFNR , AFURT from AUFK table it_aufk for entries it_OBJ where OBJNR = IT_OBJ-OBJNR

-> GET the AUFNR EQUNR from AFIH into table it_equnr where AUFNR = IT_AUFK-AUFNR.

Thanks,

Kiran