The type of the database table and work area are not Unicode convertible

[Former Member]

***Data declaration

TYPES : BEGIN OF t_zle_lagerplanung,

SEl, "stores which row user has selected

kdauf TYPE zle_lagerplanung-kdauf,

kdpos TYPE zle_lagerplanung-kdpos,

etenr TYPE zle_lagerplanung-etenr,

papiermaschine TYPE zle_lagerplanung-papiermaschine,

runnr TYPE zle_lagerplanung-runnr,

prio TYPE zle_lagerplanung-prio,

werk TYPE zle_lagerplanung-werk,

durchmesser TYPE zle_lagerplanung-durchmesser,

breite TYPE zle_lagerplanung-breite,

anzle TYPE zle_lagerplanung-anzle,

lgpla TYPE zle_lagerplanung-lgpla,

lgtyp TYPE zle_lagerplanung-lgtyp,

art TYPE zle_lagerplanung-art,

anzhoehe TYPE zle_lagerplanung-anzle,

fa TYPE zle_lagerplanung-fa,

END OF t_zle_lagerplanung.

DATA : it_zle_lagerplanung TYPE STANDARD TABLE OF t_zle_lagerplanung INITIAL SIZE 0,

wa_zle_lagerplanung TYPE t_zle_lagerplanung.

Here I am getting the data in internal table by using thiis select statement.

SELECT kdauf kdpos etenr papiermaschine runnr prio werk durchmesser breite

anzle lgpla lgtyp art anzhoehe fa

FROM zle_lagerplanung INTO CORRESPONDING FIELDS OF TABLE it_zle_lagerplanung

WHERE kdauf IN s_kdauf

AND KDPOS IN s_kdpos

AND werk = p_werks.

But while updating the particular field in zle_lagerplanung using this statement

UPDATE zle_lagerplanung from table it_zle_lagerplanung.

it is giving syntax error

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

"IT_ZLE_LAGERPLANUNG" are not Unicode convertible. "

Could any one help me out how to resolve this problem....

Thanks in advance

[Former Member]

Dear Shayamal,

XXX....are not Unicode convertible

This  error comes while inserting or updating database and the fields are not matching between  data base table and structure .

Check you fields of data base table and  "zle_lagerplanung" and struture "it_zle_lagerplanung" . There fields must match.

thanks and regrds,

Anup Banerjee

[Former Member]

Hi Shyamal,

you should use TYPE TABLE OF in case of Internal Table

& TYPE in case of Work-Area

in your code above.

Thanks & Regards,

Manu

[former_member612567]

Hi. Even I am Facing the same Problem.. How to Resolve this Problem...

[Madhu2004]

Hi ,

Its simple..

The structure of database table and the structure of the work area you are using for updation should be the same

Regards,

Madhu

[prabhanjan_reddy]

hiiii,,

i am getting same problem and how do i need to resolve this one

and in some post they r saying to use funtion module and could u please help me out which function module and which parameters do i need to pass in this.

[Former Member]

Don't update the Database directly from the WD. Use Assistance class/ Fm's to do this.

[Former Member]

Hi,

Do you have any idea how to use FM ? Can I get the sample code ...

Let me know.

Thanks!

[Former Member]

Create a FM and use an importing parameter in this FM say FS_EMP type any/Database table reference.

Here fs_emp is TYPE of zdept.

Write the code in FM to update the database.

E.g.

INSERT into zdept VALUES fs_emp.

Use this FM in your WD method by passing the values in importing parameter.

Hope it helps you.