topic Re: insert internal table into DB Table in Application Development and Automation Discussions

insert internal table into DB Table

Former Member — Wed, 06 Nov 2019 11:40:54 GMT

I have using this: iNSERT z_my_db FROM TABLE iT_tab[] ACCEPTING DUPLICATE KEYS.

but this is error:

The types of the database table and the workspace or internal table "it_tab" are not Unicode convertible.

why?

thanks

former_member1716 — Wed, 06 Nov 2019 11:49:39 GMT

Your data declaration for ITAB should be wrong, what is the data declaration for ITAB.

Is accepting duplicate key is part of your requirement?

if not you can use Modify statement as below, here gt_tab must be a internal table of type ZTAB. if possible can you paste your code?

     "Insert Into table
     MODIFY ZTAB FROM TABLE gt_tab.

Regards!

FredericGirod — Wed, 06 Nov 2019 11:49:44 GMT

A lot of times it is because the structure of IT_ITAB is not the same as the Z_MY_DB

Former Member — Thu, 07 Nov 2019 10:05:55 GMT

Can you help furnish the types of Z_MY_DB and IT_ITAB please ?