Skip to Content
avatar image
Former Member

Change history for PR05 (looking for before and after values)

In searching through SDN I found that for Travel and Expense changes made to an expense report via PR05 are captured in the cluster table PCL1.  I've found the abap RPCLSTTE that provides a user with information concerning those changes.   However, I do not see how to get the details of the changes.  For example if I change the mileage from 0  to 111.   I only see 111 on the report - and really no indication that 111 was a change - except it exists via this abap.   If I change the mileage from 111 to 222.   I see the 222 now but I do not see any reference that 111 was the prior mileage amount.  

Does this PCL1 table have the BEFORE and AFTER change values or does it only capture the AFTER?   If it only captures the AFTER what are my options for capturing the BEFORE and AFTER?   I've considered adding it to the change process via transaction SCDO.   And I also just read about config for travel expense that turns on the History (but I'm not sure if that does the BEFORE and AFTER). 

Thoughts?

Thanks

Sandra   

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    Apr 24, 2013 at 03:56 PM

    Hi Sandra

    Go to the Cluster and enter any Personnel Number and look for his booked trips. Versions are generated based on changes. The initial Trip request is always 99 and the number of changes after postings are done are recorded in these versions as 98...97...96.. depending on the changes. Here you can compare and see what has changed from the prev version.

    For example, I created a Trip on 01.04.2013 of Hotel 100 $ posted it FI doc generated..

    on 5h I changed the amout as 350 and again posted it and transferred to FI.

    If you go to the cluster and check then you will see to same Trip number with 2 diff version.

    Hope you are clear on this now. Do revert if any other question. Also assign points.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 02, 2013 at 02:38 PM

    Hi Sandra

    In the current versions,  the AEND in the report  RPCLSTTE (tcode PRTE) only gives the change before and after posting to FI but you are right there is no in-depth change log and only the history log button in PR05 (same technical limitation though)

    Cheers

    Sally

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 02, 2013 at 03:06 PM

    Sally - thank you for the confirmation.

    As I mentioned in my original post I found what looks to be like a new feature (new history and archiving of forms). 

    http://help.sap.com/erp_mss_addon10/helpdata/en/1e/9467498ee0444f9d06070d3e267364/content.htm

    Has anyone turned on the history/logging and does it provide the before and after of changes made to a trip? 

    Sandra

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Sally Redmond

      Sally,

      Thank you for your response - we have since activated the logging but do not see any difference in the PR05 history.  Nor do I see any additional table entries that would allow us to report on the details of the change.   For example if a trip was created with a mileage of 100 and someone changed the mileage to 200.  We see the new mileage amount of 200, the id of the person who made the change and the date it was changed.   What we do not see is the previous mileage of 100.  

      We are still working on this to see what we are missing.   I'll take a look at the links you provided above

      Sandra

      Sandra

  • Apr 23, 2013 at 08:47 PM

    In the Expense Clusters, it doesnt store teh differences but if someone changing anything on the line item level like amout, exp type, miles etc etc then you can identify the changes based on version.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 23, 2013 at 09:02 PM

    Can you tell me more about the versions?   I don't see any versions in the tables that I have looked at.

    Sandra

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 24, 2013 at 07:13 PM

    To summarize - if a trip has not been posted (i.e. does not have any accounting documents associated with it) - version history does not exist from what I have been able to determine.   It is only after the FI documents are created does versioning help.

    Thanks everyone for your responses.

    Sandra

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sandra and other gurus,

      I am facing the same issue.

      In PR05 tcode for a trip my user wants to get the data from history first open entry date. by default system giving the last changed(latest entry).

      We are unable to find the table name. we tried by using F1 but its showing the structure.

      Regards,

      Bwian