Sap ECC6.0 Upgrade - Unicode_types_Not_Convertible Error

[Former Member]

Hi! experts.

Please check belows.

<before>

DATA: buffer(30000) OCCURS 10 WITH HEADER LINE.

SELECT * FROM (query_table) INTO buffer WHERE (options).

endselect.

(query_table), (options) are Dynamic Sql.

-->

I also changed like this

Data : buffer type string occurs 10 with header line.

but it isn't work.

How can i change buffer declare of data type?

please help me.

Thanks.

[Former Member]

Hi! experts.

Please check belows.

<before>

DATA: buffer(30000) OCCURS 10 WITH HEADER LINE.

SELECT * FROM (query_table) INTO buffer WHERE (options).

endselect.

(query_table), (options) are Dynamic Sql.

-->

I also changed like this

Data : buffer type string occurs 10 with header line.

but it isn't work.

How can i change buffer declare of data type?

please help me.

Thanks.

[Former Member]

Hi,

The occurs 10 with header line clause can only be used with internal tables and not with string variables.

Try declaring something like this.

Data: begin of it_buffer occurs 10,
         field1(300) type c,
         field2(300) type c,
         end of it_buffer.


SELECT * FROM (query_table) INTO CORRESPONDING FIELDS OF table it_buffer WHERE (options).

Regards,

Vik

[former_member194669]

Change this way

DATA: buffer(30000) OCCURS 10 WITH HEADER LINE.

SELECT * FROM (query_table)  WHERE (options).
    write : (query_table) to buffer.
    append buffer.
endselect.

a®

[former_member194669]

Or

 data: dref type ref to data.           
  field-symbols: <wa> type any.
  create data dref type (query_table).   
  assign dref->* to <wa>.                
    select * from (query_table) into <wa> where (options).
      write : <wa> to buffer.
      append buffer.
    endselect.

a®