Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

tables

Former Member
0 Kudos
80

can we update a single table from two different locations at a same time.

1 ACCEPTED SOLUTION

Former Member
0 Kudos
63

Hi,

No we cannot update single table from two differerent location at same time because SAP is a real time system if we do so inconsistancy of data may occur for more its imp to deal with table singly for example if any table contain primary key and if you are updating from 2 diff location at same time how come the system knows what data to upload wether its of first or second......................

Thanks

Revert back in case of more clarification

5 REPLIES 5

Former Member
0 Kudos
63

hi,

i think we can that but then the result may not be consistent....

but its advisable noy to do......

it should be like ..... lock the table update the entries... and then unlock the table ......

Mark the post answered once ur problem is solved ....

Former Member
0 Kudos
64

Hi,

No we cannot update single table from two differerent location at same time because SAP is a real time system if we do so inconsistancy of data may occur for more its imp to deal with table singly for example if any table contain primary key and if you are updating from 2 diff location at same time how come the system knows what data to upload wether its of first or second......................

Thanks

Revert back in case of more clarification

Former Member
0 Kudos
63

Hi ,

We can't update a single table from two different locations at same time becoz when ever the first user updating the table, it will not allow to edit mode for another user.

Regards,

KV

former_member181995
Active Contributor
0 Kudos
63

Amit,

Yes obviously we can update single table from two dieefent location at same time.

try to think in as way that in any company sales order are creating from many sales office in around the world.and if is it so than obviously VBAP is getting updating.

surely yes we can update same time any DB.

Amit.

Former Member
0 Kudos
63

Hi Amit Kumar,

We cannot update at the same time because if a data is being updated from one location and if at the same time another request comes to the processor for the same updations it holds the second updation and allows it after the updation of the first.

Thanks,

Chandrsekhar.