Skip to Content
avatar image
Former Member

PR05, mileage fuel expense details

Hi experts,

In pr05 , if we open a trip , we have an option to enter mileage ,fuel  expenses on top right corner. I wanted to know where these values can be found in database. I mean in which table can these details can be found. On clicking F1 i can see only the structure not the table .i have tried searching for it in ptrv_* tables,but no luck.Can someone please help. Also if there exists any bapi or function module which can get me these details ?

thank you.

Br, shadab

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 26, 2015 at 03:16 PM

    Hello Shadab,

    If you save your business trip than the number of kilometers and the per diems for kilometer/mileage will be stored in statistic table PTRV_SHDR (PD_Mileage/M_Total)

    If you approve and settle your business trip than you can see the mileage in cluster tabe KMVER.

    You can check these results via transactions PRTE.

    The settlements results for kilometer are stored in table ROT ( with wagetypes which belongs tor pd receipt FAK)

    BR

    Klaus

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      call transaction se16 with table PTR_ROT_AWKEY with a testpersonel number

      You will find two different AWLIN lines.

      Check the RUNID  (posting run number)

      Call transaction PRRW with the RUNID. Doubleclick the result. Select Button FI/CO Documents

      select from the pop.up the 'Accounting Document'. here you will find the Number of Line Item Within the Accounting Document.

      PTRV_DOC_IT  refers also to the accounting document (comapre HKONT and LIFNR) with the accounts on the document.

      Hope this helps further

      BR

      Klaus

  • avatar image
    Former Member
    Nov 02, 2015 at 06:16 PM

    i found the correct table for the required question was cluster table pcl1 and the cluster region was TE.It contains ROT and EXBEL tables which provides the required data.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2015 at 05:24 AM

    Hi All,

    Is there any standard SAP report in Travel management which shows start kms and end kms of mileage details

    thanks in advance

    Add comment
    10|10000 characters needed characters exceeded