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

[Former Member]

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.

[Sm1tje]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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,

Sg