Adobe Form - Car Mileage

[Former Member]

Hello,

I am wrting a report which will list peoples car mileage claims.

I have come across a db table PTRV_SHDR which is seems to be the master

table for the trip segments i.e. each journey

I can't find the db table which holds the individual journeys i.e. details

of each claim.

On the system the screen is referencing a structure PTK10 against

the deatils.

Any body help please???

[Former Member]

I haven't ever used the trip information on SAP but I tried to find out where the PTRV_SHDR table was used in programs on our system. I found a program called RPR_TRIP_DATA_TOP that was using a TABLES statement to define several areas for that program. One of those tables was a view called v_ptrv_head. This table view looks like it joins PTRV_HEAD (general trip data), PTRV_SHDR (trip statistics), and PTRV_PERIO (period data of a trip).

Not sure if this is helpful or not and you may have already known about those, but if not it might give you something that will help point you in the right direction.

Edited by: John Russell on Jan 22, 2010 9:57 PM

[Former Member]

Cheers John,

Many thanks for the useful information.

Andy