topic Re: Update & Insert into Internal table in Application Development and Automation Discussions

Update & Insert into Internal table

Former Member — Mon, 25 Feb 2008 09:38:37 GMT

Dear Abapers,

Is it possible to update a entry in the internal table if exists, otherwise inserts a new one.

I think MODIFY <Internal Table> will not insert new one if the matching entry is not there.

MODIFY <database_table> have this facility.

Thanks in advance,

Satish

Re: Update & Insert into Internal table

Former Member — Mon, 25 Feb 2008 09:40:43 GMT

Hi,

use collect statment it will do it.

Regards

Re: Update & Insert into Internal table

Former Member — Mon, 25 Feb 2008 09:42:22 GMT

Hi,

'COLLECT' statement can solve your problem.....just check it.

Re: Update & Insert into Internal table

Former Member — Mon, 25 Feb 2008 09:47:03 GMT

Satish,

First check in database table whether entri existed or Not.

If yes

MODIFY

else.

Append.

ENDIF.

Re: Update & Insert into Internal table

Former Member — Mon, 25 Feb 2008 09:48:15 GMT

Hi,

The MODIFY statement works like INSERT/UPDATE, If key found then it will work like UPDATE, else work like INSERT.

Rgds,

Bujji

Re: Update & Insert into Internal table

Former Member — Mon, 25 Feb 2008 09:48:37 GMT

COLLECT: adds the values of its numeric components to the corresponding values of existing rows with the same key.

But i dont want to add, just changs the contents of the exisitng row in an internal table.

Re: Update & Insert into Internal table

Former Member — Mon, 25 Feb 2008 09:51:03 GMT

Hi,

collect will append if entry is not there if entry is all already there it wll modify the contents of the exisitng row in an internal table.

Regards

Re: Update & Insert into Internal table

Former Member — Mon, 25 Feb 2008 09:55:20 GMT

Bujji,

I think you are wrong. Its throwing sy-subrc = 4.

plz give me an example, if you are sure.

Satish

Re: Update & Insert into Internal table

Former Member — Mon, 25 Feb 2008 09:58:30 GMT

KPN,

You can only use the COLLECT command in a table if all of its non-key fields are numeric (type I, P, or F). P or F).

But there are no numeric fields in my table.

satish

Re: Update & Insert into Internal table

Former Member — Mon, 25 Feb 2008 10:05:45 GMT

Hi,

i dont know what type of fields u r having but about collect statement i am correct

The following special statement allows you to summate entries in an internal table:

COLLECT wa INTO itab.

itab must have a flat line type, and all of the fields that are not part of the table key must have a numeric type (f, i, p). You specify the line wathat you want to add as a work area that is compatible with the line type of itab.

When the line is inserted, the system checks whether there is already a table entry that matches the key. If there is no corresponding entry already in the table, the COLLECT statement has the same effect as inserting the new line. If an entry with the same key already exists, the COLLECT statement does not append a new line, but adds the contents of the numeric fields in the work area to the contents of the numeric fields in the existing entry.

REPORT demo_int_tables_COLLECT .

DATA: BEGIN OF line,

col1(3) TYPE c,

col2(2) TYPE n,

col3 TYPE i,

END OF line.

DATA itab LIKE SORTED TABLE OF line

WITH NON-UNIQUE KEY col1 col2.

line-col1 = 'abc'. line-col2 = '12'. line-col3 = 3.

COLLECT line INTO itab.

WRITE / sy-tabix.

line-col1 = 'def'. line-col2 = '34'. line-col3 = 5.

COLLECT line INTO itab.

WRITE / sy-tabix.

line-col1 = 'abc'. line-col2 = '12'. line-col3 = 7.

COLLECT line INTO itab.

WRITE / sy-tabix.

LOOP AT itab INTO line.

WRITE: / line-col1, line-col2, line-col3.

ENDLOOP.

The list output is:

abc 12 10

def 34 5

The example fills a sorted table. The first two COLLECT statements work like normal insertion statements. In the third COLLECTstatement, the first line of itab is modified.

Regards

Re: Update & Insert into Internal table

Former Member — Mon, 25 Feb 2008 10:09:47 GMT

Hi,

APPEND :

IT IS USED TO GET THE RECORD FROM THE INTERNAL TABLE HEADER TO THE BODY AREA

IT ALLOWS DUPLICATION

COLLECT:

IT IS USED TO A GET A RECORD FROM HEADER TO THE BODY AREA BUT IT WILL NOT ALLOW ANY DUPLICATION EXCEPT IF THERE IS ANY NUMERIC FIELS IT ADDS THAT FIELDS DATA BUT NOT AS A NEW RECORD

MODIFY:

IT IS USED TO ADD A NEW RECORD

MODIFY DBTAB FROM WORKAREA(WA)

Cheers,

vasavi

Re: Update & Insert into Internal table

Former Member — Mon, 25 Feb 2008 10:17:02 GMT

Hi ,

Update-- if the record already exists then that record is updated and if the record doesn't exists then it inserts the record.

Modify-- if the record exists then only the record is modified and it doesn't insert the record as UPDATE does.

Re: Update & Insert into Internal table

Former Member — Mon, 25 Feb 2008 10:28:21 GMT

KVN Boss,

You are right.

For modify, collect statement will not change the contents of the row.

for eg;

report z_test.

parameters p_carrid type scarr-carrid.

data scarr_tab type sorted table of scarr

with unique key carrid.

data scarr_wa type scarr.

select *

from scarr

into table scarr_tab.

read table scarr_tab into scarr_wa

with table key carrid = p_carrid.

scarr_wa-currcode = 'abc'.

collect scarr_wa into scarr_tab.

- > collect cannot change/modify int he above case. may be it can insert a new line.

Re: Update & Insert into Internal table

Former Member — Mon, 25 Feb 2008 10:33:41 GMT

Hi,

in that case u can use modify

Regards

Re: Update & Insert into Internal table

Former Member — Mon, 25 Feb 2008 11:11:57 GMT

Hi Satish,

MODIFY-Inserts new lines or updates existing lines in a database table (s. relational database). If a record with the specified primary key already exists, UPDATE is executed(existing record is changed). Otherwise, INSERT is performed(new record is added).

Your sy-subrc is giving values according to:

SY-SUBRC = 0:

All lines were successfully inserted or updated.

SY-SUBRC = 4:

One or more lines could not be inserted or updated.

So it might be that your one or more lines were not inserted or updated.

Plz tell me if you have any more doubts.

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Feb 25, 2008 6:15 PM

Re: Update & Insert into Internal table

Former Member — Mon, 25 Feb 2008 11:35:22 GMT

Hi Sathish.,

Say we have one internal table of customers with name itab.

data: itab type table of kna1 with header line,

wa type kna1,

v_lines type sy-tabix.

and you have filled this internal table with some values. and now you have a new record and want to add this new record to internal table if no match found or modify the record if match is found.

say you have new record in work area wa.

*--Get the no. of lines.

Describe table itab lines v_lines.

*-- Check if record already exist

read table itab with key kunnr = wa-kunnr.

if sy-subrc = 0. "Record exist

modify itab from wa index sy-tabix. "Modify record

else. " Record doesn't exist then insert record

*-- increase the line count

v_lines = v_lines + 1.

insert wa into itab index v_lines. "insert record at the next line

endif.

Regard,

Yellappa.