topic Re: Problem with Write Statement in Application Development and Automation Discussions

Problem with Write Statement

Former Member — Thu, 10 Jul 2008 07:04:07 GMT

Hi Friends,

Select * from ekko into table i_ekko up to 100 rows.

loop at i_ekko into w_ekko.

write : w_ekko.

endloop.

when i write the above code i am getting an error "cannot be converted in to charater type".

but i want to display the all the coloums and rows from the DB table in the report.

regards

kumar m

Re: Problem with Write Statement

Former Member — Thu, 10 Jul 2008 07:06:37 GMT

Either you have to specify each and every column like w_ekko-field1, w_ekko-field2

or you have to dynamically assign field-symbols to do the job if number of fields are very high

Re: Problem with Write Statement

GauthamV — Thu, 10 Jul 2008 07:07:01 GMT

hi,

w_ekko is workarea so u cannot get data into that,u have to define all the fileds in order to get them in output.

Re: Problem with Write Statement

Former Member — Thu, 10 Jul 2008 07:07:51 GMT

hi,

loop at i_ekko into w_ekko

Here w_ekko is considered as the field string which cannot be written with name with reference of the field name.

You shold try this

loop at i_ekko into w_ekko.
write : w_ekko-filed1.

endloop

This will work.

Regards

Sumit Agarwal

Re: Problem with Write Statement

Former Member — Thu, 10 Jul 2008 07:08:39 GMT

Hi Mukesh,

Here you are writing the field string at once. It considers the field string as a completer character type. But it contains fields other than character type. So, they cannot be converted into character type.

Instead you try to write each field individually as

wa_ekko-field1 etc.

Regards,

Chandra Sekhar

Edited by: Chandrasekhar Gandla on Jul 10, 2008 9:08 AM

Re: Problem with Write Statement

Former Member — Thu, 10 Jul 2008 07:08:51 GMT

my issue was.

List all the rows from the table LAGP(Storage Bins) in a report

Re: Problem with Write Statement

Former Member — Thu, 10 Jul 2008 07:10:19 GMT

Hi,

Use

Loop at itab into wa .

write: wa-field.

Endloop.

Regards,

Sujit

Edited by: Sujit Pal on Jul 10, 2008 9:10 AM

Re: Problem with Write Statement

bpawanchand — Thu, 10 Jul 2008 07:10:26 GMT

W_EKKO is only a work area which is like the line type of your internal table so you haveto explicitly write all teh column names

write :

/ W-EKKO-<name of the column>.

Regards

Pavan

Re: Problem with Write Statement

Former Member — Thu, 10 Jul 2008 07:12:07 GMT

HI mukesh,

When you loop at a internal table without a header line,that time while retrieving/printing the data , you should deal at field level & not work area level.

So instaed of writing the complete work area,try to write field one by one.

eg,

write : workarea-field 1,
         workarea-field 2,

The code which you have writeen would work for table with header line..

Good luck

Bhumika

Re: Problem with Write Statement

Former Member — Thu, 10 Jul 2008 07:12:16 GMT

hi,

you need to specify the fields in the write statement as your work area which contains a single row of your internal table , can not be converted into a single character string.

so u have to specify lilke this inside a loop statement:

write 😕 w_ekko-fld1 , w_ekko-fld2 , .......

Re: Problem with Write Statement

Former Member — Thu, 10 Jul 2008 07:13:33 GMT

But LAGP contains 50 fields,,

ok if Any table contain 250 fields

i should write

wa-<tab>-field1 ....... to wa_<tab>-field250. ?

Re: Problem with Write Statement

venkatasriram_mygapula — Thu, 10 Jul 2008 07:18:14 GMT

Hi,

yes on that time declare the field symbol like <fs> type any.

aassign internal table to this field symbol.

finally.

write:/ <fs>.

regards.

sriram.

Re: Problem with Write Statement

venkatasriram_mygapula — Thu, 10 Jul 2008 07:21:02 GMT

Hi,

in yoour code try like this,

FIELD-SYMBOLS: <FS>.

Select * from ekko into table i_ekko up to 100 rows.

loop at i_ekko into w_ekko.

assign lw_ekko to <FS>.

write : <FS>.

endloop.

regards.

sriram.

Re: Problem with Write Statement

Former Member — Thu, 10 Jul 2008 07:22:15 GMT

I think structure of i_ekko and wai_ekko not same as ekko DB table. You have define them.

Syed Tayab shah

Re: Problem with Write Statement

Former Member — Thu, 10 Jul 2008 07:25:41 GMT

Hi,

U cannot call the Itab directil into the write statement. Instead u have to specify whatever fields you want in the output that u have to give.

For eg.

loop at itab into w_itab.

write:/ w_itab-field1,

w_itab-field2,

w_itab-field3,

w_itab-field4.

endloop.

Hope this helps you.

Reward points if helpfull.

Thanks & Regards,

Y.R.Prem Kumar.

Re: Problem with Write Statement

Former Member — Thu, 10 Jul 2008 07:26:36 GMT

Hi Mukesh,

Actually you can do like this because each record is taken into the work area w_ekko . But probably you have some fields which cannot be converted into character types. and this character type can be of type C , N , D or T. And I also think that you might have observed some special characters also which appear. So it is always advisable to write the fields individually.

Regards,

Swapna.

Re: Problem with Write Statement

Former Member — Thu, 10 Jul 2008 08:22:30 GMT

Try this it may work.

data : iekko like ekko occurs 0.

data : wekko like ekko.
field-symbols : <fs> type any.

select * from ekko into table iekko up to 100 rows.

loop at iekko into wekko.
do 100 times.
assign component sy-index of structure wekko to <fs>.
if sy-subrc = 0.

write :  <fs>.
else.
exit.
endif.
unassign <fs>.

enddo.
write : /.
endloop.