Update vs Insert

[Former Member]

Hi,

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

[Former Member]

no

[Former Member]

use modify not update

[Former Member]

No,

MODIFY

adds data if not available or updates when available

regards

[Former Member]

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..

[Former Member]

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.

[Former Member]

hmm

my first idea where

SELECT * FROM TABLE WHERE KEY = KEY 

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

[peter_ruiz2]

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

[Former Member]

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

[Former Member]

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

[Former Member]

You can Use Modify rather than Update.

Thank you

Nikunj shah

[Former Member]

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.

ENDIF.

And Done.