topic nested select in Application Development and Automation Discussions

nested select

Former Member — Fri, 18 May 2007 05:23:13 GMT

Hi friends,

SELECT objectclas objectid changenr udate utime username FROM cdhdr

INTO (cdhdr-objectclas, cdhdr-objectid, cdhdr-changenr,

cdhdr-udate, cdhdr-utime, cdhdr-username)

WHERE objectclas = 'CLASSIFY'

AND objectid = x_objectid.

ophalen nieuwe nieuwe waarde karakteristiek

SELECT tabkey value_new FROM cdpos

INTO (cdpos-tabkey, cdpos-value_new)

WHERE objectclas = cdhdr-objectclas

AND objectid = cdhdr-objectid

AND changenr = cdhdr-changenr

AND fname = 'ATWRT'.

karakteristiek ophalen

*Begin of modification TCS196699 - BV898.

SELECT SINGLE atnam FROM cabn INTO cabn-atnam
WHERE atinn = cdpos-tabkey+20(8).

SELECT atnam FROM cabn INTO cabn-atnam

UP TO 1 ROWS

WHERE atinn = cdpos-tabkey+20(8).

ENDSELECT.

*End of modification TCS196699 - BV898.

IF sy-subrc <> 0.

CLEAR cabn.

ENDIF.

zbtch_class_char-matnr = p_matnr.

zbtch_class_char-werks = p_werks.

zbtch_class_char-charg = p_charg.

zbtch_class_char-atnam = cabn-atnam.

zbtch_class_char-changenr = cdhdr-changenr.

zbtch_class_char-udate = cdhdr-udate.

zbtch_class_char-utime = cdhdr-utime.

zbtch_class_char-username = cdhdr-username.

zbtch_class_char-value_new = cdpos-value_new.

MODIFY zbtch_class_char.

ENDSELECT.

i want to improve the performane to the above code . How i can change the inside select query for better performance.Please help me.

Thanks for all.

Re: nested select

Former Member — Fri, 18 May 2007 05:29:51 GMT

Hi,

use inner join like the example shown below.for that the tables being joined should cotain some relation.

SELECT B_{BUTTON A}BUTTON_TEXT INTO (BUTT,BUTT_TEXT) FROM ZTMW_BUTTONS_TYP AS A

INNER JOIN ZTMW_BUTTON_GRP AS B ON B_{BUTTON = A}BUTTON AND B_{TMW_IMPL = A}TMW_IMPL

INNER JOIN ZTMW_WRKBNCH_TAB AS C ON C_{BUTTON_DIS_GRP = B}BUTTON_DIS_GRP AND C_{TMW_IMPL = B}TMW_IMPL

WHERE C_{WORK_BENCH_TAB = TAB_NUM AND C}TMW_IMPL = IMPL.

rgds,

bharat.

Re: nested select

Former Member — Fri, 18 May 2007 05:35:11 GMT

hi bharat,

plz go through your code again....

as <b>cabn </b> cant be used join condition and there is no relation between cabn and cdhdr you need to use <b>for all entries</b> while firing the query.

Try to avoid the nested select statemnts in ur programs as it will make some performance issue and also for large data the query gives the dumps.

regards,

sachin

plz reward if useful

Re: nested select

Former Member — Fri, 18 May 2007 05:37:05 GMT

good

1-Use Move Corresponding with all the select statement.

thanks

mrutyun^

Re: nested select

Former Member — Fri, 18 May 2007 05:43:15 GMT

Hi,

Use internal tables to populate the data. remove select endselect statements. Instead, use

select -

from cdhdr into corresponding fields of table itab where ---.

then in second select statement, write,

select -

from cdpos into coreesponding fields of table itab1 for all entries in itab where objectclas = itab-objectclas.

Use this method for other select statements as well. Use F1 help to find exact syntax of the statement if you dont get the syntax,

Pls reward points if helpful.

Karan

Re: nested select

Former Member — Fri, 18 May 2007 05:55:20 GMT

Hey bharath,

You are using horrible nested selectstatement. it will take lot of time for execution. Try with the above solution by using innerjoin.

Reply for queries. Shall post the updates.

Regards,

Kumar.