Information about table RSPMADMIN

[Former Member]

Hello community,

we recently have upgraded to BW 7.5 and we now realized the existence of RSPMxyz-tables which oviously came into the system since BW 7.4.

However, during testing we an issue with table RSPMADMIN. We have a DTP-process which fails almost every second day duw to a lock situation with RSPMADMIN. We don't see any other processes which could cause the lock. We also would like to know under which circumstances the access to RSPMADMIN is needed.

There is one entry in that table: FREQUENT_CHECKS and the value for that parameter looks like a Timestamp.

Does anyone have more information about RSPM in general and table RSPMADMIN in detail ?

It seems that OSS does not help much here.

Thanks

[FCI]

Table is already there in a 740SP12 (empty in my case).

[MartinMaruskin]

Hi Marc,

thanks for reply. The Note you mentioned is fixing import param _scope of FM ENQUEUE_E_RSPM_ADMIN to have a value of 1 as default value is 2. I assume this fixes releasing of locks on the table RSPMADMIN. As the table is being used in constructor of class CL_RSPM_RUNTIME the table can be really busy...

cheers

[marcfbe]

You need SAP Note 2740848 - Lock on RSPMADMIN is not released automatically

[MartinMaruskin]

Haven't find much about the table either. It is just used by method FREQUENT_CHECKS of class CL_RSPM_RUNTIME. The method seem to be adding FREQUENT_CHECKS entry into the table in case it is not there already. Whereas for value of that entry an ABAP timestamp is populated (generated by GET TIME STAMP FIELD statement).

The table is definitely part of Request Status and Process Management (RSPM) of the higher versions of classic BWs (7.4, 7.5) and BW4.

Anyone else anything to be added?

Thanks