Standard Table Getting Locked

[Former Member]

Hello,

I have a standard table <b>RSPCABAPASYNC</b> in BW in functional module

RSPC_ABAP_FINISH.

I have been calling this FM parallely thru many Programs.

As some times two or more programs coincide with, updation of the standard table <b>RSPCABAPASYNC</b> the table is getting locked and my job is running indefinitely.

Can any one suggest, like how I can check if the table is being used ?

if it is used then i'll wait for few secs and again try to update thru the FM.

Is there any FM which will tell if the table is being updated.

Thanks

Dutta

[Former Member]

Hello,

I have a standard table <b>RSPCABAPASYNC</b> in BW in functional module

RSPC_ABAP_FINISH.

I have been calling this FM parallely thru many Programs.

As some times two or more programs coincide with, updation of the standard table <b>RSPCABAPASYNC</b> the table is getting locked and my job is running indefinitely.

Can any one suggest, like how I can check if the table is being used ?

if it is used then i'll wait for few secs and again try to update thru the FM.

Is there any FM which will tell if the table is being updated.

Thanks

Dutta

[former_member194669]

First check thru SM12 transaction what is lock object for this table.

go to sm12--> select the lock entry > press the details button> window will popup giving details about lock object.

if lock objects are there then

use fm ENQUEUE_READ that give you list of lock objects

aRs

[Former Member]

HI dutta,

SAP benefitis that only. it restrict the multiple updations at a time for one table, just execute DB01 or SM66 or ST04> oracle session.

Then u are able to see what are all the programs and tables are getting executed and updated.

Hope this helps you.

regards,

kumar,