topic Re: programming problem in Application Development and Automation Discussions

programming problem

Former Member — Thu, 28 Sep 2006 05:07:55 GMT

Hi Friends,

I have one problem in programming.

data: itab like table of kna1,

itab1 like table of kna1.

select * from kna1 into table itab where kunnr = s_kunnr.

now my data is in itab.

*now i wanted to do the loop for every record & transfer it to itab1.

i had already fetch the data in internal table itab_doc.

**just like

loop at itab into itab1 where kunnr = itab_doc-kunnr.

append itab to itab1.

endloop.

but here i m getting the error itab cannot be converted to the line type of itab1.

will u tell me how to resolve this???

Re: programming problem

Former Member — Thu, 28 Sep 2006 05:12:42 GMT

put like this

Message was edited by: Prabhu Peram

Re: programming problem

Former Member — Thu, 28 Sep 2006 05:13:12 GMT

Hello,

Please try like this

data: itab like table of kna1 with header line,

itab1 like table of kna1 with header line.

loop at itab into itab1 where kunnr = itab_doc-kunnr.

append itab to itab1.

endloop.

Reward if helps

Regards,

Krishna

Re: programming problem

Former Member — Thu, 28 Sep 2006 05:13:47 GMT

your problem is

loop at itab into itab1 where kunnr = itab_doc-kunnr.

append itab to itab1.

endloop.

u can replace

kunnr = s_kunnr

Re: programming problem

Former Member — Thu, 28 Sep 2006 05:14:01 GMT

hi,

Do like this.

data: itab like table of kna1,

itab1 like table of kna1.

DAtA : wa_itab like kna1.

select * from kna1 into table itab where kunnr = s_kunnr.

loop at itab into wa_itab where kunnr = itab_doc-kunnr.

append wa_itab to itab1.

endloop.

regards'

Ahasan

Re: programming problem

Former Member — Thu, 28 Sep 2006 05:23:26 GMT

Hi Salil,

data: itab type standard table of kna1,

itab1 type standard table of kna1,

wtab type kna1.

select * from kna1 into table itab where kunnr = s_kunnr.

loop at itab into wtab where kunnr = itab_doc-kunnr.

append wtab to itab1.

endloop.

Best regards,

Prashant

Re: programming problem

Former Member — Thu, 28 Sep 2006 06:41:26 GMT

better way is to use MOVE CORRESPONDING in this case

loop at itab into itab1 where kunnr = itab_doc-kunnr.
<b>MOVE CORRESPONDING ITAB TO ITAB1.
append itab1.</b>
endloop

Move CORRESPONDING will move all the fields which are same in both the tables.

Regards

srikanth

Re: programming problem

anversha_s — Thu, 28 Sep 2006 06:51:05 GMT

hi salil.

this will work for u.

Tables : kna1.

data : itab like kna1 occurs 0 with header line,

itab1 like itab.

~~-ur select query~~-

if itab[] is not initial.

loop at itab where kunnr = itab_doc-kunnr.

append itab to itab1.

clear itab.

endloop.

endif.

rgds

anver

pls mark hlpful answers

Re: programming problem

Former Member — Thu, 28 Sep 2006 07:02:43 GMT

Hi,

use have to use header line

data: itab like table of kna1 with header line,

itab1 like table of kna1 with header line.Regards

amole