Table is not Unicode Convertible

Former Member — Wed, 10 Oct 2007 09:51:39 GMT

hello,

i am getting error the type of tha database table or work area or internal table are not unicode convertible. please help me.

REPORT ZEXCISE_INVOICE_RTNS

LINE-COUNT 100

MESSAGE-ID 8I.

********************************************************************

*INCLUDES

********************************************************************

INCLUDE RVADTABL.

********************************************************************

*TABLES

********************************************************************

TABLES : T001, "Company Codes

T005, "Countries

LFA1, "Vendor Master (General Section)

EKKO, "Purchasing Document Header

EKPO, "Purchasing Document Item

MKPF. "Header: Material Document

*Excise Tables

TABLES : J_1IEXCHDR, "Excise invoice header detail

J_1IEXCDTL, "Excise invoice line item details

J_1IEXCDEF, "Tax default informations

J_1IMOVEND. "Vendor Master Excise Additional Data

********************************************************************

*INTERNAL TABLES AND STRUCTURES

********************************************************************

DATA : BEGIN OF TJ_1IEXCDTL OCCURS 0.

INCLUDE STRUCTURE ZJ1IEXCDTL.

DATA : END OF TJ_1IEXCDTL.

DATA : i_mseg like mseg occurs 0 with header line.

DATA : TJ_1IEXCDTL_Temp like TJ_1IEXCDTL occurs 0 with header line.

DATA : begin of it_ekpo occurs 0,

ebeln like ekko-ebeln, "PO Number

ebelp like ekpo-ebelp, "Line item number

meins like ekpo-meins, "Unit of measurement

mwskz like ekpo-mwskz, "Tax on Sales/Purchases Code

netpr like ekpo-netpr, "unit price

end of it_ekpo.

DATA : begin of it_a003 occurs 0,

knumh like a003-knumh, "Condition record number

kappl like a003-kappl, "Application

kschl like a003-kschl, "Condition type

mwskz like a003-mwskz, "Tax on Sales/Purchases Code

end of it_a003.

DATA : begin of it_konp occurs 0,

knumh like konp-knumh, "Condition record number

kappl like konp-kappl, "Application

kschl like konp-kschl, "Condition type

mwsk1 like konp-mwsk1, "Tax on Sales/Purchases Code

kbetr like konp-kbetr, "Rate/unit

end of it_konp.

DATA : begin of it_konv occurs 0,

knumv like konv-knumv, "Number of the document condition

kposn like konv-kposn, "Condition item number

kschl like konv-kschl, "Condition type

krech like konv-krech, "Calculation type for condition

kbetr like konv-kbetr, "Rate (condition amount or percentage)

kwert like konv-kwert, "Condition value

end of it_konv.

********************************************************************

*VARIABLES

********************************************************************

DATA: RETCODE LIKE SY-SUBRC. "Returncode

DATA: REPEAT(1) TYPE C.

DATA: XSCREEN(1) TYPE C. "Output on printer or screen

DATA: G_FM_NAME TYPE RS38L_FNAM,

V_SUBTOTAL LIKE J_1IEXCDTL-EXBAS.

DATA : V_CHID(45) TYPE C,

V_DESC1(30) TYPE C,

V_DESC2(30) TYPE C,

V_DESC3(30) TYPE C.

DATA : v_document(15) TYPE C.

***********************************************************************

SELECTION SCREEN

***********************************************************************

SELECTION-SCREEN : BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.

PARAMETERS: p_mblnr like mkpf-mblnr OBLIGATORY,

P_time like SY-UZEIT.

SELECTION-SCREEN END OF BLOCK b1.

***********************************************************************

START-OF-SELECTION

***********************************************************************

start-of-selection.

PERFORM GET_DATA.

CHECK RETCODE = 0.

Get the form name

PERFORM GET_FORM_NAME.

Call the form

PERFORM CALL_FORM.

***********************************************************************

End-Of-Selection

***********************************************************************

end-of-selection.

********************************************************************

*FORM GET DATA

********************************************************************

FORM GET_DATA.

SELECT single * from mkpf where mblnr = P_MBLNR.

IF sy-subrc <> 0.

RETCODE = 4.

message i078(8I).

exit.

ELSE.

PERFORM GET_EXCISE_INVOICE.

if retcode <> 0.

MESSAGE i301(8I).

else.

PERFORM GET_EXCISE_DETAILS.

endif.

ENDIF.

ENDFORM. "GET_DATA

********************************************************************

*FORM GET EXCISE DETAILS

********************************************************************

FORM GET_EXCISE_DETAILS.

DATA: KAWRT LIKE KOMV-KAWRT. "Excise Duty - Base Amount

SELECT * FROM J_1IEXCDTL INTO TABLE TJ_1IEXCDTL

WHERE TRNTYP = J_1IEXCHDR-TRNTYP

AND DOCYR = J_1IEXCHDR-DOCYR

AND DOCNO = J_1IEXCHDR-DOCNO.

Re: Table is not Unicode Convertible

Former Member — Wed, 10 Oct 2007 09:55:04 GMT

Hi,

If I see this right, the internal table has structure ZJ1IEXCDTL and the db table has structure J_1IEXCDTL - are the structures identical?

Regards, Joerg

Re: Table is not Unicode Convertible

Former Member — Thu, 09 Dec 2010 16:37:48 GMT

The structures do NOT have to be the same for a CORRESPONDING FIELDS. This works in a test program I have:

==================

DATA: itab TYPE STANDARD TABLE OF istruct.

SELECT *

FROM ztab

INTO CORRESPONDING FIELDS OF TABLE itab

WHERE vkorg = 'XYZ'

AND zyear = '2007'

AND werks = '00A'.

===================

where "istruct" is the same as the DB table definition plus two additional columns and minus MANDT.

However, in another program I get the "not Unicode compatible" error when I try to activate it.

Why does it work in one case and not the other? Is it some program setting?

topic Re: Table is not Unicode Convertible in Application Development and Automation Discussions

Table is not Unicode Convertible

Re: Table is not Unicode Convertible

Re: Table is not Unicode Convertible