on 03-29-2013 9:18 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Can you tell me more about the versions? I don't see any versions in the tables that I have looked at.
Sandra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
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:
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:
Hope its useful for you.
cheers
Sally
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.