topic Re: Update vs Insert in Application Development and Automation Discussions

Update vs Insert

Former Member — Fri, 04 Apr 2008 12:45:21 GMT

Hi,

can we use update to fill data in Z table rather than using insert command.

Re: Update vs Insert

Former Member — Fri, 04 Apr 2008 12:47:10 GMT

Re: Update vs Insert

Former Member — Fri, 04 Apr 2008 12:48:38 GMT

use modify not update

Re: Update vs Insert

Former Member — Fri, 04 Apr 2008 12:49:13 GMT

No,

MODIFY

adds data if not available or updates when available

regards

Re: Update vs Insert

peter_ruiz2 — Fri, 04 Apr 2008 12:49:17 GMT

hi,

the answer is no but you can use modify table if you want to insert entries in case they do not exist in the database or update the z table if the keys exist.

regards,

peter

Re: Update vs Insert

Former Member — Fri, 04 Apr 2008 12:52:12 GMT

and still i tell you rather use insert or append than modify even tho modify works.

Re: Update vs Insert

Former Member — Fri, 04 Apr 2008 12:53:28 GMT

Well Matthias Rieken ,

Actually my requirment is that if data inserted into table i want to set one field which is FLAG in table as "N" means it inserted firsted time but when it already exist then that FLAG should be set "U" means it updated.

please advise..

Re: Update vs Insert

Former Member — Fri, 04 Apr 2008 12:56:22 GMT

check if the entry already exists in the Z table ..

select single * from ztable .....

if sy-subrc = 0.

update ... with flag = 'U'

else.

Insert .... with flag = 'N'

endif.

Re: Update vs Insert

Former Member — Fri, 04 Apr 2008 12:57:17 GMT

hmm

my first idea where



SELECT * FROM TABLE WHERE KEY = KEY 

IF SY-SUBRC = 0
   UPDATE ..... WHERE KEY=KEY 
ELSE 
   INSERT .....
ENDIF

Re: Update vs Insert

Former Member — Fri, 04 Apr 2008 13:00:03 GMT

You can use modify statement instead of update.

Modify statement updates the reocord when record already exits and it is inserted when the record does not exits.

Edited by: S@N on Apr 4, 2008 3:01 PM

Re: Update vs Insert

Former Member — Fri, 04 Apr 2008 13:14:45 GMT

You can Use Modify rather than Update.

Thank you

Nikunj shah

Re: Update vs Insert

Former Member — Fri, 04 Apr 2008 13:36:24 GMT

Thank you All................

Problem has been solved and confusion has been cleared now.

i did by this way...

INSERT zpayroll FROM it_final.

IF sy-subrc = 0.

COMMIT WORK.

ELSE.

it_final-updte = 'U'.

UPDATE zpayroll FROM it_final.

IF sy-subrc = 0.

COMMIT WORK.

ENDIF.

And Done.