Skip to Content

PSA/Changelogs not included in Process Chains

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Aug 23, 2013 at 07:01 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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é

  • Posted on Aug 23, 2013 at 06:34 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2013 at 06:27 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2013 at 06:42 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.