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

insert internal table into DB Table

Former Member — Wed, 08 Jul 2009 12:32:09 GMT

Hello Experts,

I am trying to insert an internal table into DDIC Table with

INSERT ZSRM_ADDR FROM table lt_addr_export.

I am gettimg the error message

The type of the db table are not Unicode convertible. What I can I do in this case ?

Regards

Marco

Re: insert internal table into DB Table

Former Member — Wed, 08 Jul 2009 12:34:41 GMT

Hi ,

check lt_addr_export is of table type ZSRM_ADDR .

Regards,

Prabhudas

Re: insert internal table into DB Table

Former Member — Wed, 08 Jul 2009 12:35:42 GMT

Check this link.May be useful for your req.

Thanks

Re: insert internal table into DB Table

Former Member — Wed, 08 Jul 2009 12:43:35 GMT

Hi,

You get such errors when the structure of your internal table lt_addr_export is different from that of your database table, here DDIC. Check your structures. You could probably missed the MANDT field in your internal table declaration.

Re: insert internal table into DB Table

Former Member — Wed, 08 Jul 2009 12:45:33 GMT

Hi,

Check the fields in your internal table and your Z table.

They must be same. Check their types also.

Regards,

Ankur Parab

Re: insert internal table into DB Table

Former Member — Wed, 08 Jul 2009 12:54:54 GMT

TYPES: BEGIN OF lty_addr_export,
           partner       TYPE bu_partner,
           partner_guid  TYPE bu_partner_guid,
           addrnumber    TYPE ad_addrnum,
           adr_kind      TYPE bu_adrkind,
           street        TYPE ad_street,
           city1         TYPE ad_city1,
           country       TYPE land1,
           name_org      TYPE bbp_bp_name_org,
           post_code1    TYPE ad_pstcd1,
           c_o_name      TYPE ad_name_co,
*           DISTRICT      TYPE AD_CITY2,
           building      TYPE ad_bldng,
           floor         TYPE ad_floor,
           roomnumber    TYPE ad_roomnum,
         END OF lty_addr_export,

data lt_addr_export TYPE STANDARD TABLE OF lty_addr_export,

DDIC TABLE ZSRM_ADDR

MANDT	MANDT
PARTNER	BU_PARTNER
PARTNER_GUID	BU_PARTNER_GUID
ADDRNUMBER	AD_ADDRNUM
ADR_KIND	BU_ADRKIND
STREET	AD_STREET
CITY1	AD_CITY1
COUNTRY	LAND1
NAME_ORG	BBP_BP_NAME_ORG
POST_CODE1	AD_PSTCD1
C_O_NAME	AD_NAME_CO
BUILDING	AD_BLDNG
FLOOR	AD_FLOOR
ROOMNUMBER	AD_ROOMNUM

They are equal

Re: insert internal table into DB Table

Former Member — Wed, 08 Jul 2009 12:59:32 GMT

Hi,

Your internal table does not contain the MANDT field as I mentioned previously

Add the field in the beginning


MANDT TYPE SY-MANDT.

Re: insert internal table into DB Table

Former Member — Wed, 08 Jul 2009 13:43:26 GMT

I regret to say

this command causes sy-subrc 4 after executing.

Additonaly no insertion took place

What can the reason for it ?

INSERT ZSRM_ADDR FROM TABLE lt_addr_export ACCEPTING DUPLICATE KEYS.

Edited by: Marco M on Jul 8, 2009 3:43 PM

Re: insert internal table into DB Table

former_member212005 — Wed, 08 Jul 2009 13:54:37 GMT

If the structure is same...would suggest you to declare the internal table as

DATA: lt_addr_export TYPE STANDARD TABLE OF lt_addr_export.

This will avoid all the problems!

Re: insert internal table into DB Table

Former Member — Wed, 08 Jul 2009 13:58:33 GMT

try this

http://help.sap.com/saphelp_nw04/helpdata/EN/fc/eb3a6d358411d1829f0000e829fbfe/content.htm

Re: insert internal table into DB Table

RaymondGiuseppi — Wed, 08 Jul 2009 14:06:29 GMT

Did you activate the unicode flag in the program ? ( Check [ABAP Development Under Unicode|http://help.sap.com/saphelp_nw04/Helpdata/EN/79/c55458b3dc11d5993800508b6b8b11/frameset.htm] )

Regards,

Raymond

Re: insert internal table into DB Table

Former Member — Wed, 08 Jul 2009 14:12:11 GMT

it is a function module where can I do it

Re: insert internal table into DB Table

RaymondGiuseppi — Wed, 08 Jul 2009 14:39:54 GMT

Activate it on the function group.

1. Select a function group in the Object Navigator.

2. Double-click on the function group name in the tree structure.

3. Set the Unicode Checks Active flag in the following dialog box

4. Save.

5. Activate the function group.

Regards,

Raymond

Re: insert internal table into DB Table

Former Member — Wed, 08 Jul 2009 22:45:55 GMT

hi, I have set the Unicode Checks active and am getting inserted only one line into the table.

Regards

Marco

Re: insert internal table into DB Table

RaymondGiuseppi — Thu, 09 Jul 2009 06:17:59 GMT

Did you check the key fields in the intenal table (also check for unique key indexes), are they different, else only one record mau be inserted, others are duplicate keys.

Try with the option ACCEPTING DUPLICATE KEYS just after INSERT statemzent

Regards,

Raymond

Re: insert internal table into DB Table

Former Member — Thu, 09 Jul 2009 06:28:33 GMT

Hi,

You may be getting one entry because of duplicate records.. It will not insert dupliacte records for the same key field.. Check your internal table values for the key fields and then check the database values.. To avaoid going to dump for using duplicate entries you can use the addition.. accepting duplicate records with your insert statement...

Re: insert internal table into DB Table

Former Member — Thu, 09 Jul 2009 07:29:23 GMT

hi please notice I have used the addition ACCEPTING DUPLICATE KEYS

INSERT ZSRM_ADDR FROM TABLE lt_addr_export ACCEPTING DUPLICATE KEYS

Regards

Marco

Re: insert internal table into DB Table

former_member404244 — Thu, 09 Jul 2009 07:36:44 GMT

HI,

Try with modify statemnt.

modify ZSRM_ADDR FROM TABLE lt_addr_export .

Regards,

Nagaraj

Re: insert internal table into DB Table

Former Member — Tue, 19 Jul 2016 07:04:07 GMT

This message was moderated.