topic problem in Application Development and Automation Discussions

problem

Former Member — Thu, 06 Sep 2007 07:47:23 GMT

Hi abapers

declaration is :

CHANGENR like cdpos-CHANGENR,

CHANGENR1 like cdhdr-CHANGENR,

i have used the following code, it says that

"comma without procedding colon", but i have done it properly.

what could be the problem. pls advise me.

loop at ipos.

select single CHANGENR UDATE

from cdhdr

into ( ipos-CHANGENR1 , ipos-UDATE )

where CHANGENR = ipos-CHANGENR.

modify ipos.

endloop.

Thanks in advance.

Regards

Rajaram

Re: problem

Former Member — Thu, 06 Sep 2007 07:49:40 GMT

change your declaration to

DATA :

CHANGENR like cdpos-CHANGENR,

CHANGENR1 like cdhdr-CHANGENR.

Replace comma by '.'

remove space after comma -> into ( var1,var2 ) .

Reward points if helpful

Message was edited by:

taranam dhindsa

Message was edited by:

taranam dhindsa

Re: problem

Former Member — Thu, 06 Sep 2007 07:50:16 GMT

HI,

do like this.

loop at ipos.

select single CHANGENR UDATE

from cdhdr

into (ipos-CHANGENR1,ipos-UDATE) -

> no-gaps

where CHANGENR = ipos-CHANGENR.

modify ipos.

endloop.

reward if helpful

rgds,

bharat.

Re: problem

Former Member — Thu, 06 Sep 2007 07:51:25 GMT

i think that is because of into


into (ipos-CHANGENR1, ipos-UDATE) " check only 1 space after , and no other space

regards

shiba dutta

Re: problem

Former Member — Thu, 06 Sep 2007 07:52:43 GMT

Hi Raja,

Check that your declaration is done this way :

data : CHANGENR like cdpos-CHANGENR,

CHANGENR1 like cdhdr-CHANGENR.

Coz there is no problem with the query , but it will be toooooooooooo slow coz cluster tables with a select in loop and further with select end select.

Performance will be a major issue here .

Reward if helpful.

Best Regards,

Imran

Re: problem

Former Member — Thu, 06 Sep 2007 07:52:59 GMT

no yar not working

Re: problem

Former Member — Thu, 06 Sep 2007 07:54:34 GMT

Hi,

see that now.

i have modified a bit

rgds,

bharat.

Re: problem

Former Member — Thu, 06 Sep 2007 07:55:29 GMT

ya now it working yar thanks

its gap betbween (ipos-CHANGENR1 , ipos-UDATE)

<-->

regards

Rajaram