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

select - endselect issue..

Former Member — Wed, 23 Jul 2008 15:59:59 GMT

hi,

in my code i am having some select, select single and select count(*) statements. during syntax check it gives me the error saying nesting of select is not proper and that i need to include an endselect.

whats wrong !!

i just have single line select statements and no block of code to be executed, if so i wouldhave put a select and endselect.

pl advise. thks

Re: select - endselect issue..

Former Member — Wed, 23 Jul 2008 16:01:39 GMT

select single must have endselect .

Re: select - endselect issue..

ThomasZloch — Wed, 23 Jul 2008 16:01:50 GMT

A SELECT without SINGLE or aggregate function like COUNT (*) or INTO TABLE addition usually requires an ENDSELECT.

Thomas

Re: select - endselect issue..

JozsefSzikszai — Wed, 23 Jul 2008 16:02:09 GMT

copy your code here...

venkatesh appikonda:

"select single must have endselect ."

unfortunately this is wrong...

Re: select - endselect issue..

Former Member — Wed, 23 Jul 2008 16:05:28 GMT

Thanks Eric, here is my select related code..this is in the user exit save_document_prepare of MV45AfZZ.

SELECT LAND1 INTO L_LAND1 FROM KNA1 WHERE KUNNR = XVBAK-KUNNR.

SELECT COUNT(*) INTO L_LINES FROM Zcusttable WHERE ALAND = L_ALAND AND LAND1 = L_LAND1.

SELECT SINGLE TDIIX INTO L_TDIIX FROM TVLK WHERE LFART = L_LFARV.

Re: select - endselect issue..

ThomasZloch — Wed, 23 Jul 2008 16:07:25 GMT

SELECT SINGLE LAND1 INTO L_LAND1 FROM KNA1 WHERE KUNNR = XVBAK-KUNNR.

Re: select - endselect issue..

JozsefSzikszai — Wed, 23 Jul 2008 16:08:04 GMT

SELECT SINGLE LAND1 INTO L_LAND1 FROM KNA1 WHERE KUNNR = XVBAK-KUNNR.

pls. correct (in bold)

you select only one record (KUNNR is the only key field in KNA1)

Re: select - endselect issue..

ThomasZloch — Wed, 23 Jul 2008 16:08:57 GMT

I did read your mind, friend

Going home now.

Cheers

Thomas

Re: select - endselect issue..

Former Member — Wed, 23 Jul 2008 16:09:39 GMT

Hi Friend,

Please change :

SELECT LAND1 INTO L_LAND1 FROM KNA1 WHERE KUNNR = XVBAK-KUNNR.

SELECT SINGLE LAND1 INTO L_LAND1 FROM KNA1 WHERE KUNNR = XVBAK-KUNNR.

Check this link. I think this might help you.

http://www.sapbrainsonline.com/sapinfo/tutorial.php?artid=414

Hope this helps you.

Regards,

Chandra Sekhar

Re: select - endselect issue..

JozsefSzikszai — Wed, 23 Jul 2008 16:09:57 GMT

or I did yours

dann bis Morgen

Re: select - endselect issue..

Former Member — Wed, 23 Jul 2008 16:10:35 GMT

please try to include single after select.

SELECT Single LAND1 INTO L_LAND1 FROM KNA1 WHERE KUNNR = XVBAK-KUNNR.

HOpe this solves ur issue.

Shreekant