Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Sap ECC6.0 Upgrade - Unicode_types_Not_Convertible Error

Former Member
0 Likes
704

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.

1 ACCEPTED SOLUTION
Read only

former_member194669
Active Contributor
0 Likes
656

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.

3 REPLIES 3
Read only

Former Member
0 Likes
656

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

Read only

former_member194669
Active Contributor
0 Likes
657

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.

Read only

0 Likes
656

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.