topic Re: Simple Select Issue. in Application Development and Automation Discussions

Simple Select Issue.

former_member295881 — Wed, 10 Feb 2010 21:18:15 GMT

Hello experts,

Iu2019m trying to write a simple select but canu2019t make it working. All Iu2019m trying to do is to get values from KNA1 into 2 variables as follows.

select kunnr ktokd into v_kunnr v_ktokd

from kna1

where kunnr = v_kunnr.

endselect.

When I check SAP says u201CV_KTOKDu201D is not expected. However when I do the same code for 1 variable it work fine.

select kunnr into v_kunnr

from kna1

where kunnr = v_kunnr.

endselect.

Can please somebody correct my mistake.

Thanks a lot in advance,

Re: Simple Select Issue.

Former Member — Wed, 10 Feb 2010 21:21:56 GMT

write the coding as :

select kunnr ktokd into (v_kunnr , v_ktokd)

from kna1

where kunnr = v_kunnr.

endselect.

Re: Simple Select Issue.

former_member295881 — Wed, 10 Feb 2010 21:30:13 GMT

Thanks a lot Sirini. It worked.

Re: Simple Select Issue.

Former Member — Wed, 10 Feb 2010 22:00:12 GMT

Zero - this was an extremely basic question. One that could have been solved by pressing F1 on SELECT. please see and before posting.

Rob