topic delete any entry in the table before adding an entry? in Application Development and Automation Discussions

delete any entry in the table before adding an entry?

Former Member — Mon, 19 Jun 2006 13:04:15 GMT

Hello ABAP Experts,

I have the data in the work area. I can modify / update / insert to the table.

How to write the ABAP code for this situation.

1) to delete any entries in the table

2) update this entry

so finally always there would be only one entry.

Suggestions appreciated.

Thanks,

BWer

Re: delete any entry in the table before adding an entry?

Former Member — Mon, 19 Jun 2006 13:07:56 GMT

use update statement

update ztab from wa.

If there is a match with the same key fields, then the record will be updated, if not no updates wil be done.

Regards,

ravi

Re: delete any entry in the table before adding an entry?

Former Member — Mon, 19 Jun 2006 13:11:40 GMT

Hi,

Delete the entries of table by this stmt.

DELETE FROM (dbtabname).

Then insert the values from workarea

INSERT INTO dbtab VALUES <work_area>.

And u can upadte the entry with values of workarea by this stmr.

UPDATE (dbtabname) FROM wa.

Dont use MODIFY. It will add a new record if its a new entry.

Rgds,

Prakash

Re: delete any entry in the table before adding an entry?

Former Member — Mon, 19 Jun 2006 13:18:50 GMT

hi,

Delete the entries of table with

DELETE FROM <dbtable>.

For inserting the values from workarea Use

INSERT INTO <dbtable> VALUES <wa>.

For Updatimg the values from work area. Use

UPDATE <dbtabname> FROM wa.

Regards,

Santosh

Re: delete any entry in the table before adding an entry?

Former Member — Mon, 19 Jun 2006 13:28:11 GMT

Hi,

1) to delete any entries in the table

Delete From <database table name>

to delete specific entries

Delete From <database table name> where <condition>

2) update this entry

insert into <database table name> from <workarea>

Sameena

Message was edited by: sameena attarwala