table name for the transaction data

[Former Member]

Hello Gurus,

what is the table name for the transaction data which we have created through t.code PRO5. we are generating report for the total kms per vehicle type for a employee. these data in which tables can i get? the data related to trips ?

thanks in advance

regds

ramachandra

[Former Member · Accepted solution]

Check tables,

PTRV_SADD

PTRV_SBACKLOG

PTRV_SCOS

PTRV_SHDR

PTRV_SREC

Regards

[Former Member · Accepted solution]

Thanks for your reply . But these tables are not showing vehicle type. From which table can i get vehilcle type wise kilometers? Pls can anyone tell me . we are entereing vehilcle type and kms in PRO5. In which tables these two fields are storing?

regds

ramachandra

[Former Member · Accepted solution]

Dear,

Check table:PTRV_KMSUM.

Regards,

[Former Member · Accepted solution]

very very thanks for your answer chandra. I am giving full points to you. cheerfull...................

thanks

regds

ramachandra

[Former Member · Accepted solution]

Hi,

Travel Expense data are stored in Cluster PCL1. In order to see these table run TCode PRTE. It is one of the most useful Tcodes is Travel.

I hope this helps.

[Former Member · Accepted solution]

thanks guys , this table has been the solution !

[Former Member]

Hi,

Pl use RPR_TRIP_HEADER_DATA programme for getting general trip data, which will have details about number of KM travelled by employee for each trip, amount to reimbursed to the employee etc.

Thanks,

Nandagopal C