topic Re: AS02 multiple users update same time? how in Application Development and Automation Discussions

AS02 multiple users update same time? how

Former Member — Mon, 15 Mar 2010 06:32:20 GMT

I am working on ECC6.0

Customer wants to update asset data from tr-cd AS02 .Problem is that

multiple users may need to update same asset record at same time.

How to solve this update same single record with multiple user at same time.

from my understanding, when you open AS02 with single record of asset, it will be locked for other users.

how to make unlock and solve this problem.

Pls advice.

Thanks

jai

Re: AS02 multiple users update same time? how

Former Member — Mon, 15 Mar 2010 06:43:18 GMT

Hi Jai,

Sometimes your responsibility is simply to say no. There's a good reason that data records are locked to prevent multiple simultaneous updates: If you disable the locking the last one making a change would win. So if you do what you're asked to do, be sure that lots of users in the future would start complaining about missing updates...

I.e. I'm talking about a simple scenario where both users A and B open the record at the same time, then they modify it and then A saves it and then B. Since B didn't have A's changes, he basically overwrites the changes that A has done.

In theory of course it could be that different users need to access different parts of records, so simultaneous updates might actually be valid without introducing any data collisions/synching problems. Standard SAP doesn't offer this though and I personally doubt that you want to start creating complex transactions to accomplish that.

Cheers, harald

Re: AS02 multiple users update same time? how

Former Member — Mon, 15 Mar 2010 06:44:02 GMT

HI Jaichan,

I think its not posssible. Entries in Table will locked at database level, and only once user can update a record at a time.

Regards

Srikanth M

Re: AS02 multiple users update same time? how

Former Member — Mon, 15 Mar 2010 08:00:13 GMT

hi herald

Yes, You are right. Problem is this.

i.e. I'm talking about a simple scenario where both users A and B open the record at the same time, then they modify it and then A saves it and then B. Since B didn't have A's changes, he basically overwrites the changes that A has done.

Any SAP standard mechanism is there to resolve this problem while posting record by multiple users at same time.

Appreciate response if possible.

Regards

Jai

Re: AS02 multiple users update same time? how

SuhaSaha — Tue, 16 Mar 2010 05:19:51 GMT

Hello Jai,

I agree with Harald. You must have a look at the SAP documentation on [Lock Mechanism|http://help.sap.com/saphelp_nw70/helpdata/en/41/7af4c5a79e11d1950f0000e82de14a/content.htm].

SAP Locks are different from DB locks, they are logical locks & do not lock the DB records. The DB locks are actually active during a DB LUW (INSERT, UPDATE, MODIFY, DELETE statements in the code).

More on this can be found from the SAP online documentation.

BR,

Suhas