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

[Former Member]

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   

[S0017256970 · Accepted solution]

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.

[Former Member]

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

[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

[Former Member]

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

Sandra

[S0017256970]

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.

[Former Member]

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

[former_member131723]

Hi Sandra

With the enhancement spot FITV_VERSIONING_ENHSPOT/FITV_VERSIONING_BADI_DEF- it saves a version of the trip at each change (in conjunction with archivelink server) as a document as such.

You need business function fin_travel_3 too  - this is from the IMG info

If you activate logging of history, the system logs the changes to travel requests and expense reports. Users can display the history in the following user interfaces:

• Personal object worklists (POWL) for travelers, assistents, and approving managers on the Web Dynpro ABAP-based user interface of Travel Management

• Transactions of the travel expense report in SAP GUI; for example, in the Travel Expense Manager (transaction PR05) or in the Travel Calendar (transaction PR02)

  If you do not activate logging of history, the system automatically logs the changes made to expense reports (as in earlier releases). Users can display the change history only in the transactions of the travel expense report in SAP GUI. 

Storage of Travel and Expense Forms in the Archive

If you have activated logging of history, you also can define that the travel request forms and expense report forms are to be automatically archived when certain events occur. You can determine which of the following events triggers the archiving of a form:

• When processing of a changed travel request or expense report is handed over from the user who makes the change to another user

• When the status of the travel request or expense report changes

• When a user saves the travel request or expense report

  You can archive the Adobe PDF forms or HTML forms for travel requests and expense reports, but not the forms for travel plans. If you use an ABAP list form, the system first converts this form to an HTML form and then archives the HTML form. 

In the following activities you define which kinds of forms the system uses:

• For travel requests, see Define Enterprise-Wide Control Parameters and attribute HTMLFORM_R_P.
• For expense reports, see Travel Expenses Control (Expert View), Other Settlement, field 24.

Hope its useful for you.

cheers

Sally

[Former Member]

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

[former_member131723]

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