topic Re: select and append in Application Development and Automation Discussions

select and append

Former Member — Thu, 24 Apr 2008 14:52:06 GMT

hello friends,

i tried the below code,

it was giving sytax error appending,

can some one correct it.

loop at i_marc.

select aennr aetyp objkt revlv aedat ccsto from aeoi

into APPENDING CORRESPONDING FIELDS OF TABLE lt_aeoi

where matnr in i_marc.

endloop.

thanks.

Re: select and append

Former Member — Thu, 24 Apr 2008 14:53:16 GMT

remove into before appending ..

loop at i_marc.

select aennr aetyp objkt revlv aedat ccsto from aeoi

APPENDING CORRESPONDING FIELDS OF TABLE lt_aeoi

where matnr in i_marc.

endloop.

thanks.

Re: select and append

b_deterd2 — Thu, 24 Apr 2008 14:53:35 GMT

delete APPENDING in your code

Re: select and append

Former Member — Thu, 24 Apr 2008 14:54:33 GMT

Hi Sanjana,

you have to type like

loop at i_marc.

select aennr aetyp objkt revlv aedat ccsto from aeoi

into CORRESPONDING FIELDS OF TABLE lt_aeoi

where matnr in i_marc.

endloop.

you must not use appending.its not the syntax.

rewards points if helpful.

Re: select and append

Former Member — Thu, 24 Apr 2008 14:54:48 GMT

Hi Sanjana,

loop at i_marc.

select aennr aetyp objkt revlv aedat ccsto from aeoi
APPENDING CORRESPONDING FIELDS OF TABLE lt_aeoi
where matnr in i_marc.
endloop.

Regards,

Sunil

Re: select and append

Former Member — Thu, 24 Apr 2008 15:20:36 GMT

Hi,

Take out 'into' from the select statement.


loop at i_marc.

select aennr aetyp objkt revlv aedat ccsto from aeoi 
APPENDING CORRESPONDING FIELDS OF TABLE lt_aeoi 
where matnr in i_marc.

endloop.

Have u used delete adjacent duplicates for i_marc internal table before looping, otherwise you have duplicate entries.

Thanks,

Sriram Ponna.