Start of Content Area

Object documentation Data Structures in Travel Expenses  Locate the document in its SAP Library structure

Definition

Travel Expenses data is stored in database PCL1 and in tables PTRV_HEAD and PTRV_PERIO.

Structure

The system compresses the data of trips, which is stored in different internal tables, in the PCL1 database under the keys: personnel number, trip number, trip period and trip period version in a data record. The Travel Expenses data is given the additional key TE in the PCL1. The credit card clearing data is given the additional key TC or TA.

Key TE

Detailed data for a trip number is stored under the key TE.

Key TC

Under key TC, the credit card transactions stored in internal tables INBEL and CCBEL by the system during credit card clearing are saved for the respective personnel numbers.

Key TA

The imported credit card company settlement runs are stored under the key TA.

Database access

Database access for the additional key TE takes place via the macros RP-IMP-C1-TE (data import) and RP-EXP-C1-TE (data export). Database access for keys TA and TC of credit card clearing takes place via the macros RP-IMP-C1-TA, RP-IMP-C1-TC, RP-EXP-C1-TA and RP-EXP-C1-TC

Integration

Evaluation of PCL1, PTRV_HEAD and PTRV_PERIO takes place via the four special database reporting programs.