topic Re: Error in Insert Statement in Application Development and Automation Discussions

Error in Insert Statement

Former Member — Thu, 23 Jul 2009 05:40:41 GMT

hi guru,

I am doing the unicode checking of the program... during that i hv found one error in insert statement.

the error is "The type of the database table and work area (or internal table) "WA_SRV" are

not Unicode convertible".

so plz help me on this matter..

INSERT ZSRVDET FROM WA_SRV.

where wa_srv is work area.

zsrvdet is z table.

Re: Error in Insert Statement

sridhar_meesala — Thu, 23 Jul 2009 05:44:11 GMT

Hi,

Declare the work area type same as that of the database table.

Thanks,

Sri.

Re: Error in Insert Statement

sreeramkumar_madisetty — Thu, 23 Jul 2009 05:45:41 GMT

check wherhetr your ztable struture and the work area structure in compatible or not?

ZSRVDET structure and WA_SRV structure should be in Synch.

Regards,

Sreeram

Re: Error in Insert Statement

Former Member — Thu, 23 Jul 2009 05:45:47 GMT

Maintain the same structure for the internal table as the db table

Thanks & Regards

Re: Error in Insert Statement

faisalatsap — Thu, 23 Jul 2009 05:45:59 GMT

Hi, Manish

Please Check the Type of WA_SRV it must same as ZSRVDET

Please Reply if any Issue,

Best Regards,

Faisal

Re: Error in Insert Statement

Former Member — Thu, 23 Jul 2009 05:48:00 GMT

i declared it like this... it has some error

TYPES : BEGIN OF GS_SRV,

INVNO LIKE ZSRVDET-INVNO, "Official Excise Document Number

MINVNO LIKE ZSRVDET-MINVNO, " mul invoice number

INVDATE LIKE ZSRVDET-INVDATE, "Excise Document Date

CUSTMAT LIKE ZSRVDET-CUSTMAT,"Material Number Used by Customer

MATNR LIKE ZSRVDET-MATNR, "Material Number

SRVNO LIKE ZSRVDET-SRVNO, "SRVNO

SRVDATE LIKE ZSRVDET-SRVDATE, "SRV DATE

QTY LIKE ZSRVDET-QTY, "Target quantity

NETAMOUNT LIKE ZSRVDET-NETAMOUNT, "NET AMOUNT PER MATERIAL

RECAMOUNT LIKE ZSRVDET-RECAMOUNT, "RECEIVED AMOUNT PER-

"-MATERIAL

NETAMOUNT1 LIKE ZSRVDET-NETAMOUNT1, "NETAMOUNT IN CURRENCY

END OF GS_SRV,

DATA: GT_SRV TYPE STANDARD TABLE OF GS_SRV,

DATA: WA_SRV TYPE GS_SRV,

Re: Error in Insert Statement

Former Member — Thu, 23 Jul 2009 05:48:43 GMT

Hi,

Please check if the internal table or the corresponding work area has the same structure as that of the database table. Only then the INSERT statement into the database will be successful.

Check if you have used the MANDT field in the declaration. That could probably be a reason for the error.


MANDT type SY-MANDT  "Try including this in your declaration as the first field in your structure

Re: Error in Insert Statement

Former Member — Thu, 23 Jul 2009 05:49:18 GMT

i declared it like this... it has some error

tables: zsrvdet

TYPES : BEGIN OF GS_SRV,

INVNO LIKE ZSRVDET-INVNO, "Official Excise Document Number

MINVNO LIKE ZSRVDET-MINVNO, " mul invoice number

INVDATE LIKE ZSRVDET-INVDATE, "Excise Document Date

CUSTMAT LIKE ZSRVDET-CUSTMAT,"Material Number Used by Customer

MATNR LIKE ZSRVDET-MATNR, "Material Number

SRVNO LIKE ZSRVDET-SRVNO, "SRVNO

SRVDATE LIKE ZSRVDET-SRVDATE, "SRV DATE

QTY LIKE ZSRVDET-QTY, "Target quantity

NETAMOUNT LIKE ZSRVDET-NETAMOUNT, "NET AMOUNT PER MATERIAL

RECAMOUNT LIKE ZSRVDET-RECAMOUNT, "RECEIVED AMOUNT PER-

"-MATERIAL

NETAMOUNT1 LIKE ZSRVDET-NETAMOUNT1, "NETAMOUNT IN CURRENCY

END OF GS_SRV,

DATA: GT_SRV TYPE STANDARD TABLE OF GS_SRV,

DATA: WA_SRV TYPE GS_SRV,

Edited by: Manish Sharma on Jul 23, 2009 7:50 AM

Re: Error in Insert Statement

Former Member — Thu, 23 Jul 2009 05:51:30 GMT

No iam not using mandt field in the table zsrvdet

Re: Error in Insert Statement

Former Member — Thu, 23 Jul 2009 05:52:13 GMT

Hi ,

check whether your internal table and workarea is of same type .

Please let me know if you still have any issues on this.

Thanks and regards,

Rajeshwar.

Re: Error in Insert Statement

Former Member — Thu, 23 Jul 2009 05:52:26 GMT

Hi,

Use the MANDT field as the first field in your declaration of the structure like I mentioned before.

Re: Error in Insert Statement

sridhar_meesala — Thu, 23 Jul 2009 05:53:34 GMT

Hi,

See whether all thesefields are there in the database table into which you are inserting. It should contain all the fields in the same order.

If not declare the internal table and work area similar to that of the database table.

DATA: GT_SRV TYPE STANDARD TABLE OF database_table.
DATA: WA_SRV TYPE database_table.

Thanks,

Sri.

Re: Error in Insert Statement

Former Member — Thu, 23 Jul 2009 05:56:36 GMT

Hi,

If the declaration of the strcuture is causing more problems, declare your internal table TYPE STANDARD TABLE of database table and the work are LIKE LINE OF the internal table.

The Unicode error occurs when the structures are different.