topic Re: Help me - Error ABAP in Application Development and Automation Discussions

Help me - Error ABAP

former_member1335810 — Wed, 20 May 2009 01:22:23 GMT

I'm expanding the staff 2lis_11_vaitm extractor.

But I'm with error which indicates that the internal table can not be converted to unicode.

code below:

data:begin of it_lips occurs 0,

vbeln type lips-vgbel,

posnr type lips-posnr,

lfimg type lips-lfimg,

end of it_lips.

data:begin of it_lips_tot occurs 0,

vbeln type lips-vgbel,

posnr type lips-posnr,

lfimg type lips-lfimg,

end of it_lips_tot.

LOOP AT c_t_data INTO r_mc11va0itm.

v_tabix = sy-tabix.

clear : it_lips, it_lips_tot.

select *

from lips

into table it_lips (here is where the error indicates)

where vgbel = R_MC11VA0ITM-vbeln and

posnr = R_MC11VA0ITM-posnr.

sort it_lips.

loop at it_lips.

move-corresponding it_lips to it_lips_tot.

collect it_lips_tot

R_MC11VA0ITM-ZZLFIMG = it_lips_tot-lfmig.

MODIFY c_t_data FROM r_mc11va0itm INDEX v_tabix.

Message error :

The type of the database table and work area (or internal table)

"IT_LIPS" are not Unicode convertible. .

Re: Help me - Error ABAP

Former Member — Wed, 20 May 2009 01:32:15 GMT

Hi ,

taht is bcoz in the internal table it_lips ur having only 3 fileds...

vbeln type lips-vgbel,

posnr type lips-posnr,

lfimg type lips-lfimg,

but in the select querry ur tryying to get all fields...(*)

so try this

select *

from lips

into corresponding fields of table it_lips

where vgbel = R_MC11VA0ITM-vbeln and

posnr = R_MC11VA0ITM-posnr.

select vbeln

posnr

lfimg

from lips

into table it_lips

where vgbel = R_MC11VA0ITM-vbeln and

posnr = R_MC11VA0ITM-posnr.

Re: Help me - Error ABAP

venkat_o — Wed, 20 May 2009 02:39:50 GMT

Hello Thiago Mösken, Try to change your code from


into table it_lips


into corresponding fields of table it_lips

I believe that it works. Thanks Venkat.O

Re: Help me - Error ABAP

former_member189059 — Wed, 20 May 2009 02:49:30 GMT

In Mr. A's post, the second option is the better one performance wise

Re: Help me - Error ABAP

former_member229729 — Wed, 20 May 2009 03:11:09 GMT

Hi,

The Internal table you created is:

data:begin of it_lips occurs 0,

vbeln type lips-vgbel,

posnr type lips-posnr,

lfimg type lips-lfimg,

end of it_lips.

(1) While selecting the rows from the standard table, the syntax should be:

into corresponding fields of table it_lips

(2) Otherwise, the Internal table table declaration should be:

data: it_lips like lips occurs 0 with header line.

For your case, we have to adopt the step (1) given above.

Regards,

RamaniN

Re: Help me - Error ABAP

Former Member — Wed, 20 May 2009 06:34:17 GMT

u can use INTO CORRESPONDING FIELDS OF TABLE IT_LIPS insted of into table it_lips