topic ABAP Performance Tunning in Application Development and Automation Discussions

ABAP Performance Tunning

Former Member — Thu, 21 Nov 2013 08:56:07 GMT

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

Re: ABAP Performance Tunning

nabheetscn — Thu, 21 Nov 2013 09:03:03 GMT

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

Re: ABAP Performance Tunning

Former Member — Thu, 21 Nov 2013 09:16:33 GMT

This message was moderated.

Re: ABAP Performance Tunning

Former Member — Thu, 21 Nov 2013 09:30:04 GMT

This message was moderated.

Re: ABAP Performance Tunning

former_member219762 — Thu, 21 Nov 2013 09:58:02 GMT

Hi Meenachi,

Define view in dictionary and use it.

Regards,

Sreenivas.

Re: ABAP Performance Tunning

former_member202771 — Sat, 23 Nov 2013 02:50:31 GMT

This message was moderated.

Re: ABAP Performance Tunning

Former Member — Sat, 23 Nov 2013 15:03:19 GMT

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