problem

[Former Member]

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

[Former Member]

change your declaration to

DATA :

CHANGENR like cdpos-CHANGENR,

CHANGENR1 like cdhdr-CHANGENR<b>.</b>

Replace comma by '.'

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

Reward points if helpful

Message was edited by:

taranam dhindsa

Message was edited by:

taranam dhindsa

[Former Member]

HI,

do like this.

loop at ipos.

select single CHANGENR UDATE

from cdhdr

into (<b>ipos-CHANGENR1,ipos-UDATE</b>) -

---

> no-gaps

where CHANGENR = ipos-CHANGENR.

modify ipos.

endloop.

<b>reward if helpful</b>

rgds,

bharat.

[Former Member]

no yar not working

[Former Member]

Hi,

see that now.

i have modified a bit

rgds,

bharat.

[Former Member]

i think that is because of into

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

regards

shiba dutta

[Former Member]

ya now it working yar thanks

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

<-->

regards

Rajaram

[Former Member]

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