topic Re: not unicode convertible in Application Development and Automation Discussions

not unicode convertible

Former Member — Wed, 06 Aug 2008 11:39:04 GMT

HI All

I am getting the following error message:

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

u201CWA_INVOICE_ITEMu201D are not Unicode convertible

DATA : BEGIN OF wa_invoice_item ,

MANDT LIKE ZINVOICE_ITEM-MANDT,

INVOICENO LIKE ZINVOICE_ITEM-INVOICENO,

INVOICEYEAR LIKE ZINVOICE_ITEM-INVOICEYEAR,

INVOICEITEM LIKE ZINVOICE_ITEM-INVOICEITEM,

GOODSDESC LIKE ZINVOICE_ITEM-GOODSDESC,

CATEGORY LIKE ZINVOICE_ITEM-CATEGORY,

QTY LIKE ZINVOICE_ITEM-QTY,

UOM LIKE ZINVOICE_ITEM-UOM,

RATE LIKE ZINVOICE_ITEM-RATE,

AMOUNT LIKE ZINVOICE_ITEM-AMOUNT,

col_flag(1),

END OF wa_invoice_item.

DATA : TB_INVOICE LIKE ZINVOICE OCCURS 0 WITH HEADER LINE,

WA_INVOICE LIKE ZINVOICE,

TB_INVOICE_ITEM LIKE WA_INVOICE_ITEM OCCURS 0 WITH HEADER LINE.

Could someone please tell me what is the problem??

Thanks and Regards,

Suresh

Re: not unicode convertible

Former Member — Wed, 06 Aug 2008 11:40:51 GMT

DATA : BEGIN OF wa_invoice_item ,
*MANDT LIKE ZINVOICE_ITEM-MANDT, " Commented
INVOICENO LIKE ZINVOICE_ITEM-INVOICENO,
INVOICEYEAR LIKE ZINVOICE_ITEM-INVOICEYEAR,
INVOICEITEM LIKE ZINVOICE_ITEM-INVOICEITEM,
GOODSDESC LIKE ZINVOICE_ITEM-GOODSDESC,
CATEGORY LIKE ZINVOICE_ITEM-CATEGORY,
QTY LIKE ZINVOICE_ITEM-QTY,
UOM LIKE ZINVOICE_ITEM-UOM,
RATE LIKE ZINVOICE_ITEM-RATE,
AMOUNT LIKE ZINVOICE_ITEM-AMOUNT,
col_flag(1),
END OF wa_invoice_item.

DATA : TB_INVOICE LIKE ZINVOICE OCCURS 0 WITH HEADER LINE,
WA_INVOICE LIKE ZINVOICE,
TB_INVOICE_ITEM LIKE WA_INVOICE_ITEM OCCURS 0 WITH HEADER LINE.

Re: not unicode convertible

Former Member — Wed, 06 Aug 2008 11:42:02 GMT

Hi,

check whether your data base table structure and internal table structure is same or not..

Re: not unicode convertible

Former Member — Wed, 06 Aug 2008 11:50:15 GMT

Thanks for your reply

i will Commented that line after same error will come

Thanks And Regards

Suresh

Re: not unicode convertible

Former Member — Wed, 06 Aug 2008 11:50:37 GMT

Did you use all the fields of database table in your ITAB?

Make sure you have all of them.

Thats is why you are getting that problem.

And if you want all the fields, why do u wanna put each field by field.You can just include your structure there.

Thanks

Kiran

Re: not unicode convertible

Former Member — Wed, 06 Aug 2008 11:51:17 GMT

In the Select query, ensure that you are retrieving only those fields which are mentioned in wa_item.

Re: not unicode convertible

Former Member — Wed, 06 Aug 2008 11:53:46 GMT

types : BEGIN OF ty_invoice_item ,

MANDT LIKE ZINVOICE_ITEM-MANDT,

INVOICENO LIKE ZINVOICE_ITEM-INVOICENO,

INVOICEYEAR LIKE ZINVOICE_ITEM-INVOICEYEAR,

INVOICEITEM LIKE ZINVOICE_ITEM-INVOICEITEM,

GOODSDESC LIKE ZINVOICE_ITEM-GOODSDESC,

CATEGORY LIKE ZINVOICE_ITEM-CATEGORY,

QTY LIKE ZINVOICE_ITEM-QTY,

UOM LIKE ZINVOICE_ITEM-UOM,

RATE LIKE ZINVOICE_ITEM-RATE,

AMOUNT LIKE ZINVOICE_ITEM-AMOUNT,

col_flag(1),

END OF ty_invoice_item.

DATA : TB_INVOICE type table of ty_invoice_item WITH HEADER LINE,

WA_INVOICE type ty_invoice_item .

Re: not unicode convertible

Former Member — Wed, 06 Aug 2008 11:58:33 GMT

Hi ,

Are u using any insert or modify stmt in ur program...

and also is there any field named col_flag in your data base table.

Re: not unicode convertible

Former Member — Wed, 06 Aug 2008 12:02:00 GMT

Hi,

Declaration is correct , check your rest code.

i checked with some other code, see below code it not showing any error.

DATA: BEGIN OF wa_item,
        mandt like vbap-mandt,
        vbeln like vbap-vbeln,
        posnr like vbap-posnr,
        matnr like vbap-matnr,
        matwa like vbap-matwa,
        pmatn like vbap-pmatn,
        charg like vbap-charg,
        matkl like vbap-matkl,
        arktx like vbap-arktx,
        colflag(1),
      END OF wa_item.
DATA:
  it_vbap LIKE vbap OCCURS 0 WITH HEADER LINE,
  wa_vbap LIKE vbap,
  it_item LIKE wa_item OCCURS 0 WITH HEADER LINE.

Regards

Adil

Re: not unicode convertible

Former Member — Wed, 06 Aug 2008 12:11:11 GMT

Thanks for your reply

i am the following code using

WHEN 'SAVE'.

WA_INVOICE-CREATEDBY = sy-uname.

WA_INVOICE-CREATEDATE = sy-datum.

INSERT INTO ZINVOICE VALUES WA_INVOICE.

cnt = 0.

LOOP AT TB_INVOICE_ITEM INTO WA_INVOICE_ITEM.

cnt = cnt + 1.

WA_INVOICE_ITEM-INVOICENO = WA_INVOICE-INVOICENO.

WA_INVOICE_ITEM-INVOICEYEAR = WA_INVOICE-INVOICEYEAR.

WA_INVOICE_ITEM-INVOICEITEM = cnt.

INSERT INTO ZINVOICE_ITEM VALUES WA_INVOICE_ITEM.

ENDLOOP.

MESSAGE i000(8i) WITH 'Invoice ' WA_INVOICE-INVOICENO

'is Created'.

PERFORM clear_wa.

LEAVE TO SCREEN 0.

LOOP AT TB_INVOICE INTO WA_INVOICE." Status check
LEAVE TO SCREEN 0.

Thanks and Regards

Suresh

Re: not unicode convertible

Former Member — Wed, 06 Aug 2008 12:13:01 GMT

data : wa_invoice_item type zinvoice_item,
         tb_invoice_item type standard table of zinvoice_tem.

DATA : TB_INVOICE LIKE ZINVOICE OCCURS 0 WITH HEADER LINE,
WA_INVOICE LIKE ZINVOICE.

Re: not unicode convertible

Former Member — Wed, 06 Aug 2008 12:40:49 GMT

Hi there,

The problem occurs when you transfer data into that structure, you must just make sure that whatever you are transferring is of the same type as the recipient, more specially cos you transferring the enire structure.

Hope that helped.

Khotso Lebitsa.