check table update

[Former Member]

Hi

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?

[former_member222860]

Check with the SY-SUBRC = 0

[SuhaSaha]

Hello,

CHECK SY-SUBRC = 0.

This should suffice.

BR,

Suhas

[Former Member]

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.

[Former Member]

Hi,

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

This may help you !!

Thanks !!

Vivek

[Former Member]

solved

[Former Member]

thanks