topic Re: check table update in Application Development and Automation Discussions

check table update

Former Member — Fri, 18 Sep 2009 09:03:43 GMT

i have a modify statement as below

MODIFY afvu FROM TABLE git_afvu1.

after this modify stmnt , database table is getting updated. now i want to check whether the update was successful or not to proceed further. what i need to do?

Re: check table update

former_member222860 — Fri, 18 Sep 2009 09:05:17 GMT

Check with the SY-SUBRC = 0

Re: check table update

SuhaSaha — Fri, 18 Sep 2009 09:05:45 GMT

Hello,

CHECK SY-SUBRC = 0.

This should suffice.

BR,

Suhas

Re: check table update

Former Member — Fri, 18 Sep 2009 09:07:25 GMT

sy-subrc = 0 in case , All lines were inserted or changed.

Sy-subrc = 4 in case , At least one line could not be processed as there is already a line with the same unique name

Sy-dbcount gives no of processed lines.

Re: check table update

Former Member — Fri, 18 Sep 2009 09:35:26 GMT

Hi,

After modify statement check SY-SUBRC = 0 or not. If SY-SUBRC = 0then put "COMMIT WORK" statement.

This may help you !!

Thanks !!

Vivek

Re: check table update

Former Member — Tue, 22 Sep 2009 04:25:46 GMT

solved

Re: check table update

Former Member — Wed, 28 Oct 2009 11:39:56 GMT

thanks