topic Re: Rollback for database updates FMs in Application Development and Automation Discussions

Rollback for database updates FMs

Former Member — Thu, 10 Aug 2006 14:51:23 GMT

Hi,

I'm using function modules : ISU_DB_EVER_UPDATE & FKK_ACCOUNT_UPDATE for updating the tables FKKVKP & EVER respectively. These FMs seem to perfrom a commit before leaving. I've to update multiple records. But if there's an error while updating, say, 4th record the chnages made to the first 3 records have to be reverted back.

Right now records are being updated one by one in the table.

Does anyone know a way through this problem?

Thanks...

Re: Rollback for database updates FMs

Former Member — Thu, 10 Aug 2006 14:54:54 GMT

hi,

put a flag to check if all teh records are correctly proccessed. finally u do commit work explicitly else roll back if teh flag is initiated.

theja.

Re: Rollback for database updates FMs

Former Member — Thu, 10 Aug 2006 14:57:56 GMT

Hi Munish,

see if the fms have a parameter on setting which, the commits are not made(Something like simulate/test run).

Pass that flag and commit when all updates are succesful.

Regards,

ravi

Re: Rollback for database updates FMs

Former Member — Thu, 10 Aug 2006 15:05:55 GMT

The Fm ISU_DB_EVER_UPDATE doesn't have any flag like that & for FKK_ACCOUNT_UPDATE I'm not being able locate it.

One more thing, these tables are to be updated one after the other. So if there's any error, changes are to be reverted back on both of these tables.

Thanks...

Re: Rollback for database updates FMs

Former Member — Thu, 10 Aug 2006 15:14:52 GMT

It would be best to use a BAPI for this if you can find one. That way you should be able to run a test of all the updates before actually doing them.

What release are you on?

Rob

Re: Rollback for database updates FMs

Former Member — Thu, 10 Aug 2006 15:17:15 GMT

Hi,

I'm on 4.6.

I'm trying to find the BAPI.

Thanks..