Database Reporting in Travel Expenses
Use
All Travel Expenses data is stored in database PCL1 and in tables PTRV_HEAD and PTRV_PERIO. In the case of incorrect or irregular settlement results, system administration can access this data directly in the database to track the possible source of errors as quickly as possible.
Features
The system saves the data under the keys for personnel number, trip number, trip period, and trip period version. The output of database reporting is sorted according to this key. You can use two forms of database reporting:
Overview of trips
With this program you can only display the cross-period general trip data (PTRV_HEAD) and the general trip data for a trip period (PTRV_PERIO).
Details of a trip
With this program you can display all of the data for a trip. It is not possible to limit output to cross-period general trip data (PTRV_HEAD) or general trip data of a period (PTRV_PERIO) as with the Overview of trips.
See also:
Display Overview of Trips Display Details of a Trip Display Credit Card Data Display Credit Card Settlement Runs Database Structure