topic Re: Update statement not working in Application Development and Automation Discussions

Update statement not working

Former Member — Tue, 22 Sep 2009 13:35:06 GMT

Hi,

I need to update a ztable in my program.

I have used the following statement.

UPDATE zeps_pr_eos FROM TABLE tab4.

But an entry alredy exists in the ztable zeps_pr_eos with the values in tab4 table.But still after the update statement the sy-subrc value is 0.It should show sy-subrc value as 4.

Which is the correct statement to update the ztable table

Re: Update statement not working

Former Member — Tue, 22 Sep 2009 13:41:17 GMT

Hi ,

Try this.

MODIFY TABLE TABLE NAME FROM INTERNAL TABLE.

if sy-subrc = 0.

COMMIT WORK AND WAIT.

else.

roll back.

endif.

Regards,

Vijay

Re: Update statement not working

rainer_hbenthal — Tue, 22 Sep 2009 13:41:18 GMT


> But an entry alredy exists in the ztable zeps_pr_eos with the values in tab4 table.But still after the update statement the sy-subrc value is 0.It should show sy-subrc value as 4.
> 
> Which is the correct statement to update the ztable table

Update is working only with existant rows.

Are you looking for inserting new rows?

Re: Update statement not working

former_member191735 — Tue, 22 Sep 2009 13:42:59 GMT

Use commit work after update statement if sy-subrc = 0. Usually, if there is a record in table with same key it should give you subrc value 4 but if you get 0 use commit work statement after check subrc

To insert new rows, you could use Modify or insert statement. Update statement will updates the existing row.

good luck

Re: Update statement not working

Former Member — Tue, 22 Sep 2009 13:44:28 GMT

Please F1 on UPDATE statement ... You will get the answer

Re: Update statement not working

Former Member — Tue, 22 Sep 2009 13:44:35 GMT

Hi,

If the primary key fields of the internal table matches with those of the database table, the update statement will update them irrespective of what the other fields contains. Thats why SY-SUBRC = 0.

Only if the primary ket field of the internal table does not match with the primary key fields of the database table, SY-SUBRC will be 4.

Regards,

Vikranth

Re: Update statement not working

awin_prabhu — Tue, 22 Sep 2009 13:47:11 GMT

Hi Friend,

I think u are confused between UPDATE and INSERT statements.

UPDATE statement will upate all records in databse table with new values from the internal table for matching records.

INSERT statement will insert new records into database table when that record does not exist already.

Press F1 on both UPDATE & INSERT statements and see.

Note: When source(internal table) is empty sy-subrc is always zero.

Thanks,

Edited by: Sap Fan on Sep 22, 2009 3:47 PM

Re: Update statement not working

Former Member — Tue, 22 Sep 2009 13:51:14 GMT

HI,

Check after giving this..

*'COMMIT WORK'*

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT.

Regards

Surya

Re: Update statement not working

Former Member — Tue, 22 Sep 2009 16:05:12 GMT

hi abaper,

how do you expect update would fail here?

update only works if a record exist. so its perfectly fine.

only insert statement will fail(sy-subrc=0) if a corresponding entry exist..