topic Unicode Conversion error in Application Development and Automation Discussions

Unicode Conversion error

Former Member — Wed, 13 May 2015 08:49:54 GMT

Hi ,

i am getting b>The type of the database table and work area (or internal table)are not Unicode convertible. Unicode convertible</b>". error while using select query.

SELECT SINGLE *

FROM ZTYPE_INVOICES

INTO wa_FREIGHT1

WHERE LIFNR = ZSEA_CHARGES-LIFNR.

TYPES : BEGIN OF TY_ZSEA_CHARGES,

MANT TYPE ZSEA_CHARGES-MANT,

LIFNR TYPE ZSEA_CHARGES-LIFNR,

BELNR TYPE ZSEA_CHARGES-BELNR,

NAME1 TYPE ZSEA_CHARGES-NAME1,

FKDAT TYPE ZSEA_CHARGES-FKDAT,

WRBTR TYPE ZSEA_CHARGES-WRBTR,

KURST TYPE ZSEA_CHARGES-KURST,

DMBTR TYPE ZSEA_CHARGES-DMBTR,

THC_CHRG TYPE ZSEA_CHARGES-THC_CHRG,

DOC_CHRG TYPE ZSEA_CHARGES-DOC_CHRG,

SEAL_CHRG TYPE ZSEA_CHARGES-SEAL_CHRG,

ENS_CHRG TYPE ZSEA_CHARGES-ENS_CHRG,

HAZ_CHRG TYPE ZSEA_CHARGES-HAZ_CHRG,

AMS_CHRG TYPE ZSEA_CHARGES-AMS_CHRG,

ISPS_CHRG TYPE ZSEA_CHARGES-ISPS_CHRG,

BLSURRENDER_CH TYPE ZSEA_CHARGES-BLSURRENDER_CH,

SURVEY_CHRG TYPE ZSEA_CHARGES-SURVEY_CHRG,

PLUGIN_CHRG TYPE ZSEA_CHARGES-PLUGIN_CHRG,

AMENDMENT_CHRG TYPE ZSEA_CHARGES-AMENDMENT_CHRG,

OTHER_CHRG TYPE ZSEA_CHARGES-OTHER_CHRG,

OTHER_CHRG_AMT TYPE ZSEA_CHARGES-OTHER_CHRG_AMT,

NETLASHING_CHR TYPE ZSEA_CHARGES-NETLASHING_CHR,

SERVICETAX TYPE ZSEA_CHARGES-SERVICETAX,

EDUCATION_CESS TYPE ZSEA_CHARGES-EDUCATION_CESS,

SEC_CESS TYPE ZSEA_CHARGES-SEC_CESS,

TOTAL_AMT TYPE ZSEA_CHARGES-TOTAL_AMT,

END OF TY_ZSEA_CHARGES.

IT_FREIGHT1 TYPE STANDARD TABLE OF TY_ZSEA_CHARGES,

WA_FREIGHT1 TYPE TY_ZSEA_CHARGES.

Thanks,

Amit Dwivedi

Re: Unicode Conversion error

RaymondGiuseppi — Wed, 13 May 2015 09:06:10 GMT

Check compatibility of TY_ZSEA_CHARGES and ZTYPE_INVOICES (*) or use a CORRESPONDING option in SELECT statement.

Regards,

Raymond

(*) Open SQL - Work Areas in Statements

Re: Unicode Conversion error

Former Member — Wed, 13 May 2015 09:06:16 GMT

Hi Amit,

You are selecting all the fields from the table ZTYPE_INVOICES into work area.

But your work area structure is different you declared in the program, Declare the work area with same type as ZTYPE_INVOICES.

DATA : WA_FREIGHT1 TYPE ZTYPE_INVOICES.

Regards

Mani

Re: Unicode Conversion error

Former Member — Wed, 13 May 2015 09:08:17 GMT

Dear Amit,

Then error is due to the difference in the number of fields in the select query and in the WA_FREIGHT1.

give the field names in the select query and that should match with the fields in TY_ZSEA_CHARGES structure in the same sequence .

Best Regards,

Noufal P

Re: Unicode Conversion error

Former Member — Wed, 13 May 2015 09:12:22 GMT

hello amit,

As you may be using less number of field in module pool designing when compared to your database structure. First you need to define work area depending up on your database table and pick the values in that work area and pass it to your screen elements.

Regards,

Divya.

Message was edited by: divya shree

Re: Unicode Conversion error

Former Member — Wed, 13 May 2015 09:18:58 GMT

Hi Nagamani,

Done as u said but still giving the error.

Thanks,

Amit

Re: Unicode Conversion error

Former Member — Wed, 13 May 2015 09:19:54 GMT

I want to select the entire row based on LIFNR and dsiplay on screen.

i am working on Module pool.

Thanks,

Amit

Re: Unicode Conversion error

Former Member — Wed, 13 May 2015 09:24:57 GMT

Hi Amit,

Then check the where condition WHERE LIFNR = ZSEA_CHARGES-LIFNR.

the type of the LIFNR in both the tables are same or not.

Regards

Mani

Re: Unicode Conversion error

Former Member — Wed, 13 May 2015 09:30:15 GMT

Hi,

Both are same.

Thanks,

Amit Dwivedi

Re: Unicode Conversion error

former_member185177 — Wed, 13 May 2015 09:30:28 GMT

Hi Amit,

I guess ZSEA_CHARGES is customized table.

Need to declare the table on top of your types.

Tables: ZSEA_CHARGES.

Regards,

Krishna Chaitanya.

Re: Unicode Conversion error

Former Member — Wed, 13 May 2015 09:40:16 GMT

Hi Krishna,

That's already there.

Thanks,

Amit Dwivedi

Re: Unicode Conversion error

former_member185177 — Wed, 13 May 2015 09:51:41 GMT

Then your entire code should be in CHAIN .... ENDCHAIN.

Re: Unicode Conversion error

Former Member — Wed, 13 May 2015 09:57:26 GMT

Hi Krishna,

I do not want to validate the fields.

I just want to select data from database table from internal table or work area.

Thanks,

Amit Dwivedi

Re: Unicode Conversion error

RaymondGiuseppi — Wed, 13 May 2015 10:05:40 GMT

So for *******, either


SELECTSINGLE *
         FROM ZTYPE_INVOICES
         INTO CORRESPONDING FIELD OF wa_FREIGHT1
WHERE LIFNR = ZSEA_CHARGES-LIFNR.


SELECTSINGLE *
         FROM ZTYPE_INVOICES
         INTO wa_INVOICES " defined as TYPE ZTYPE_INVOICES
         WHERE LIFNR = ZSEA_CHARGES-LIFNR.
MOVE-CORRESPONDING wa_INVOICES TO wa_FREIGHT1.

Regards,

Raymond

Re: Unicode Conversion error

Former Member — Wed, 13 May 2015 10:29:03 GMT

Hi Raymond,

I tried using ur 1 option bt now it is giving error "Field "LIFNR" unknown".

what may be the cause of this error.

Thanks,

Amit

Re: Unicode Conversion error

Venkat_Sesha — Wed, 13 May 2015 10:33:47 GMT

Make sure the Data Elements are matched in the your Type declaration as well as with your Database Table.

Hope this works

Re: Unicode Conversion error

Former Member — Wed, 13 May 2015 10:34:12 GMT

Hi Guys,

The issue is resolved.

Thanks,

Amit Dwivedi

Re: Unicode Conversion error

former_member185177 — Thu, 14 May 2015 07:30:20 GMT

Hi Amit,

Appreciate if you share the solution for this.

Regards,

Krishna Chaitanya.

Re: Unicode Conversion error

Former Member — Wed, 27 May 2015 05:47:18 GMT

Hi Krishna,

I mentioned wrong table name in my select query. The table name an the wa have different structures.

That's the reason it was giving error.

Thanks,

Amit Dwivedi