topic Re: Insert in Application Development and Automation Discussions

Insert

Former Member — Thu, 16 Aug 2007 15:26:59 GMT

Hi Gurus,

I need to get data from one of my custom table z_header into one of my internal table it_tab.

What would be the easiest way of doing that.

Thanks

Rajeev Gupta

Re: Insert

Former Member — Thu, 16 Aug 2007 15:29:24 GMT

Hi Use following code :

select f1 f2 ... from z_header into table it_tab .

Reward points if helpful.

Regards.

Srikanta Gope

Re: Insert

former_member378318 — Thu, 16 Aug 2007 15:30:34 GMT

SELECT * FROM Z_HEADER INTO TABLE IT_ITAB.

Re: Insert

Former Member — Thu, 16 Aug 2007 15:32:11 GMT

data: lt_tab type table of z_header,
            ls_tab type z_header.


select * from z_header into table lt_tab.
if sy-subrc eq 0.
loop at lt_tab into ls_tab.
* do your data manupulation here.
endloop.
endif.

Re: Insert

Former Member — Thu, 16 Aug 2007 15:37:19 GMT

good

use select statement.

thanks

mrutyun^

Re: Insert

Former Member — Thu, 16 Aug 2007 15:40:59 GMT

Thanks for the reply,

I tried doing this and i m getting the following error:

" it_tab are not unicode convertible.

Thanks

Rajeev Gupta

Re: Insert

Former Member — Thu, 16 Aug 2007 15:42:05 GMT

paste your code please..

Re: Insert

Former Member — Thu, 16 Aug 2007 16:51:08 GMT

HI,

Data : itab like standard table of z_header,

wa like z_header.

select * from z_header into table itab.

if sy-subrc eq 0.

loop at itab into wa.

write wa.

endloop.

endif.

Thansk

mahesh

Re: Insert

former_member378318 — Thu, 16 Aug 2007 21:21:03 GMT

Try it like this:

Data : itab like standard table of z_header,

wa like line of itab.

select * from z_header into table itab.

if sy-subrc eq 0.

loop at itab into wa.

You should print each field of wa separately

write: wa-field1, wa-field2, wa-field3.

endloop.

endif.

See if that works.