06-25-2008 6:00 AM
can we update a single table from two different locations at a same time.
06-25-2008 6:44 AM
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
06-25-2008 6:02 AM
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 ....
06-25-2008 6:44 AM
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
06-25-2008 6:47 AM
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
06-25-2008 6:48 AM
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.
06-25-2008 6:51 AM
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.