topic Re: Insert/ Append into Itab having unique key in Application Development and Automation Discussions

Insert/ Append into Itab having unique key

Karan_Chopra_ — Thu, 06 May 2010 04:51:35 GMT

I have an Internal table(gi_sorted_material) with matnr as unique key but I have to insert values into it from another table(gi_material), but while inserting in loop it may be case that the gi_material may have multiple matnr with same number so i want that to be ignored while inserting , currently it gives runtime error or some syntax error.

I used this:

gi_sorted_material TYPE SORTED TABLE OF t_material WITH UNIQUE KEY matnr.

ls_sorted_material TYPE t_material.

READ TABLE gi_material INTO ls_material INDEX 1.

How to insert values from gi_material into gi_sorted_material

Re: Insert/ Append into Itab having unique key

Karan_Chopra_ — Thu, 06 May 2010 05:12:25 GMT

Pllz reply

Re: Insert/ Append into Itab having unique key

Former Member — Thu, 06 May 2010 05:19:15 GMT

Hi,

Pls. read help for 'UNIQUE' , which says

"For a table key specified with UNIQUE,

a row with a certain key field content can only occur once in an internal table of this type" ...

So, it's not possible to insert another record with the same key.

Regards,

Srini.

Re: Insert/ Append into Itab having unique key

Former Member — Thu, 06 May 2010 05:25:10 GMT

Hi,

Try below code

gi_sorted_material TYPE SORTED TABLE OF t_material WITH UNIQUE KEY matnr.
ls_sorted_material TYPE t_material.

loop at gi_maternal into ls_material.
 read table gi_sorted_material into wa_sorted_material with key matnr = ls_material-matnr.
 if sy-subrc eq 0.
 modify gi_sorted_material from ls_material index sy-tabix.
else
append ls_material to gi_sorted_material.
endloop.

Regards

Vinod

Re: Insert/ Append into Itab having unique key

Former Member — Thu, 06 May 2010 05:27:31 GMT

Hi,

Try This code,

loop at ls_sorted_material into wa.

insert wa into table gi_sorted_material."It will Not insert Duplicates of MATNR

endloop.

Regards,

Raghava Channooru

Re: Insert/ Append into Itab having unique key

Former Member — Thu, 06 May 2010 05:32:10 GMT

Hi Karan,

If you want a unique record in your gi_sorted_material table then you can do 1 thing,

Just delete the duplicate records from the internal table gi_material comparing matnr.

SORT gi_material BY matnr.

DELETE ADJACENT DUPLICATES FROM gi_material COMPARING matnr.

This will give you all unique records in gi_material itself.

Then loop into gi_material and assign the records in gi_sorted_material according to your requirement.

Hope this helps.

Regards,

Vaibhav