Trip not found in PR05,UWL,TRIP

[Former Member]

An employee created a trip(trip id 0000420399) and submitted for manager approval,once manager approved even payment(reimbursement) also done long back, after few days when we are checking this particular  trip no 0000420399 is not found in PR05,TRIP,UWL also.we wonder even either employee or manager cant delete this trip id as this is done through credit card transaction.this trip is not found even database table(se16) also we also tried with PTRV_Head & PTRV_Perio), BAPI_TRIP_GET_DETAILS(functional module), but no where this trip no. displayed. This trip is created some 01 2013, i am able to see all the trip ids apart from this trip id, even i can see trip ids which were created before this(2012,2011 etc).

[former_member131723 · Accepted solution]

Hi Shilpa

If the trip is not in PTRV_HEAD or PERIO or even in the archive table (PTRV_ARCHIVE) or existing anywhere at DB level then for sure it is gone.. I could only imagine perhaps was it deleted with RPTTDORL?

You are right though if it contained a paid by company CC receipt, it should usually not be deleted once CC clearing is active- is the receipt assigned to a trip in tcode PRTE?  The only known occurence of trips being deleted not by user was to do with those created through PR02 but this was corrected with note 1790793.

But all the same, if it is not existing anywhere at DB level - then there is no way to recover it. (Also, we do have a new report now that shows the delete history of a trip - 1876453 - No log available for deleted trips)

cheers

Sally

[Former Member · Accepted solution]

Hi Sally.....Thanks for time and sharing information,we have initiated to implement note mentioed above  so that we can track on deleted trips in future days....

[former_member131723]

No worries Shilpa..I just spotted a typo in my earlier reply (still foggy following new year!) but in fact if you look to tcode PRTC, this is the raw data for the credit card data for the buffer and inbel, so also a good place to check with regard to credit card receipts (you mentioned this was assigned and you can see was a receipt written back to the buffer.. could be the case if the trip was indeed deleted and contained a reimburse to employee receipt)

The report I mentioned is relatively new and requires you to be at a certain SP level also but if you notive future occurences, you can avoid user deletion through authorizations also.

Anyway, I'll update this thread as closed once no more queries.

Happy New Year!

Sally

[Former Member]

Thanks a lot Sally, i appreciate your eagerness to interact and share the knowledge.

[Former Member]

Hi,

if you cannot find the trip id (transaction prte) this trip is gone for ever!

There is no "history table" to track deletion of trip id's.

Best regards,

Sigi

[Former Member]

Thx sigi for sharing information.