PSA/Changelogs not included in Process Chains

[former_member559220]

Hello All,  Please help me to find out PSA/Changelog tables which are not included in the Processchains. Is there any program/table to find out the PSA/Changelog tables?   Thanks in advance!  Regards, Rajagopal.

[RamanKorrapati · Accepted solution]

Hi Raj,

Accept with martin, you can find thru Table -  RSPCPROCEEELOG, Filter on  TYPE, above two types. you will get the chains which are included. By using table  rspcprocesslog, you will know chains which are running. i think if you use table - RSPCCHAIN, you may get whole chains which are on prodcution. but some times there will be chance to have unused chains which leads to take more time to you.

If you have very less/countable chains then go for manual.

Thanks

[former_member190024 · Accepted solution]

Hi Raj,

PSA requests can be found in table RSSTATMANPSA.

Change logs can be found in table RSREQICODS.

You can run the following sql statements from the SQL Command Editor in transaction DB02 (Performance -> Additional Functions -> SQL Command Editor). This might only work for Oracle database only as the sql syntax is different for other underlying DB management systems (DB2, MS SQL, AS/400 etc.).

Number of PSA requests per DataSource:

select psa, count(rnr) as b, min(datum_anf) as d from RSSTATMANPSA

group by psa

order by d;

In the result, column b will show how many requests for that PSA have not yet been deleted.

Column d will show the data of the oldest request that has not yet been deleted.

Number of change log requests per DSO:

select tabname, count(rnr) as b, min(timestamp) as d from rsreqicods

where typ = 'C'

group by tabname

order by d;

In the result, column b will show how many requests for that DSO have not yet been deleted.

Column d will show the data of the oldest request that has not yet been deleted.

Hope it will help you.

Rgds,

René

[yasemin_kilinc]

Hi Rajagopal,

I suppose you are trying to find the DSO's which you have not activate in process chains. If it is so, then you can directly get the list of DSO's activated in process chains from table RSPCVARIANT. Select TYPE as "ODSACTIVAT" you will see the DSO's name in "LOW" field. If you need to find PSA table names then you can go to RSTSODS table usşng DSO names as filter.

All the tables related with process chains start with RSPC* so you can take a look at those tables if any other information is required.

Hope it gives an idea

Yasemin

[MGrob]

Hi

Use table RSPCCHAIN and filter the type on PSADELETE and CHGLOGDEL to get all the ChainID's and Variants

for those included.. The other way around is probably manual effort

hope it helps

Martin

[former_member559220]

hi Martin, Thanks for the Information!  Regards, rajagopal

[Former Member]

Hi,

I don't think we have program for identifying which PSA/Change log tables are not included in the process chain.. You need to check it manually.

Is there any program/table to find out the PSA/Change-log tables?

you can find psa/change log table names based on respective Datasource & DSO.

Pls correct me if i understood your requirement incorrectly.

Thanks

Aakash Gujja