topic Re: Avoiding select..........endselect in Application Development and Automation Discussions

Avoiding select..........endselect

Former Member — Wed, 28 May 2008 20:56:39 GMT

HI,

i have to fetch a field auart from table aufk into variable lv_auart for order no aufnr without using endselect.

this is the query:

SELECT auart

FROM aufk

INTO lv_auart

WHERE aufnr = ls_segtype-aufnr.

please help me .

thanks,

Anand.

Re: Avoiding select..........endselect

Sm1tje — Wed, 28 May 2008 21:32:31 GMT

use select single

SELECT SINGLE auart FROM

INTO lv_auart

WHERE aufnr = ls_segtype-aufnr.

Or when you don't have the whole key use

UP TO 1 ROWS.

Edited by: Micky Oestreich on May 28, 2008 11:32 PM

Re: Avoiding select..........endselect

Former Member — Thu, 29 May 2008 03:48:14 GMT

hi,

since u r passing aufnr, u'll get only one auart for that aufnr.

so use:

SELECT SINGLE auart
FROM aufk
INTO lv_auart
WHERE aufnr = ls_segtype-aufnr.

regards,

madhu

Re: Avoiding select..........endselect

Former Member — Thu, 29 May 2008 13:55:05 GMT

hi anand,

in table AUFK the Key field is AUFNR.

so do a SELECT SINGLE based on AUFNR.

so the statement will look like

SELECT SINGLE AUART

from AUFK

into lv_auart

where AUFNR = ls_segtype-aufnr.

this avoids using the ENDSELECT statement.

Hope this was useful.

Reward if found useful.

Thanks

Venugopal

Re: Avoiding select..........endselect

Former Member — Fri, 30 May 2008 03:46:15 GMT

Hi Anand!

Hope ur query is solved.

As ritely mentioned above..using select single will solve ur problem.

Never use select- endselect.

SELECT SINGLE auart

FROM aufk

INTO lv_auart

WHERE aufnr = ls_segtype-aufnr.

rewars if useful.

Re: Avoiding select..........endselect

Former Member — Fri, 30 May 2008 04:31:54 GMT

Hi Anand..

There is no need to use Select and End Select as AUFNR is Key Field in Order Master Data..

select single auart from aufk

into lv_auart

where aufnr = ls_segtype-aufnr.

do't know how you are geting this value ....ls_segtype-aufnr..

close the thread once answered.

Regards,