Trip (travel) management History tables

[Former Member]

Hi friends,

Can any body tell Trip management tables.

I need to develop a report which shows TRIP history. Who changed, when changed, changing amount, cost centers.....

I tried in SDN & <b>ptrv_*</b> tables no data is available.

Thanks & Regards,

Kumar.

Message was edited by:

kumar wf

[Former Member · Accepted solution]

Hi,

For your information I just had the same problem and I think I found the solution.

The Trip history is stored in the TE cluster.

To read the cluster you will have to use the the following macro

rp-imp-c1-te.

To be short you will have to do the following to get the info

• history of trip

data: begin of aend occurs 10. "Tabelle Status/Änderer

include structure ptk11.

data: end of aend.

• TE-Cluster from PCL1

te-key-pernr = te_pernr.

te-key-reinr = te_reinr.

te-key-perio = te_perio.

te-key-pdvrs = te_pdvrs.

rp-imp-c1-te.

aend will contain the history

Unfortunately there are some other variables that you will have to declare otherwise it will not work

Here is the macro definition

define rp-imp-c1-te.

import te-version to ote-version

statu

beleg

exbel

abzug

ziel

zweck

konti

vsch

kmver

paufa

uebpa

beler

vpfps

vpfpa

rot

ruw

aend

kostr

kostz

kostb

kostk

v0split

editor "YKYK002848

user

from database pcl1(te)

id te-key.

rp-imp-te-subrc = sy-subrc.

end-of-definition.

Hope this will help you.

Regards

[Former Member · Accepted solution]

Hi Kumar,

In se11 check PRTV*

Regards,

Naresh.

[Former Member · Accepted solution]

Hi Jürgen Degraeve ,

Can you please provide more details on how to create this structure using the macro.

[zeeshan_xt · Accepted solution]

Its actually PTRV*

[Former Member]

PTRV_CHANGE is the table for history log of PR05

[Former Member]

Hi...,

Can anybody please....

Regards,

Kumar.

[Former Member]

Hi,

Check this link.

http://www.sapsecurity.co.uk/sap-tables.html.

This link has a HUGE list of SAP standard tables. It has tables on Travel Costs, Employee Grouping for Travel Etc. I am not sure if this is what you want. Apart from the tables in the link the following list is also available :

PTRV_ADMIN Travel Management: Administrative Data for

PTRV_APPL_KEY Application

PTRV_APPL_KEY_TX Application text

PTRV_ARCH_HEAD Prearchiving FI-TV: Entries from PTRV_HEAD

PTRV_ARCH_PERIO Prearchiving FI-TV: Entries from PTRV_PERI

PTRV_ARCHIVE Administrative Table for Archived Trip Dat

PTRV_BEIH_BEL Assignment of Receipts to a Subsidy for Tr

PTRV_BEIH_TAG Assignment of Days to a Subsidy for Trips

PTRV_BEIH_WEG Assignment of Trip Segments to a Subsidy f

PTRV_BEIHILFE Subsidies for Trips Home for Entire Separa

PTRV_CCC Error Receipts for Credit Card Clearing

PTRV_CCC_RUNS Assign Personnel Number to Credit Card Cle

PTRV_COMM_AMT Detail Data: Transfer to FM When Trip Save

PTRV_COMM_ITM Header Data: Transfer to FM When Trip Save

PTRV_COMP Comparison Calculation Results PS

PTRV_COUNT Number of function calls in posting run ma

PTRV_DOC_HD Transfer Travel -> FI/CO: Header of TRV in

PTRV_DOC_IT Transfer Travel -> FI/CO: Lines of TRV int

PTRV_DOC_MESS Transfer Travel -> FI/CO: CO Replacements

PTRV_DOC_TAX Transfer Travel -> FI/CO: Tax lines of TRV

PTRV_F_CLM Columns for Which Suppression in Form Bloc

PTRV_F_CLM_TXT Columns that may be suppressed in form blo

PTRV_F_COLDEP Display Forms for Texts

PTRV_F_COLDEPS Display Formats for Texts (Language-Depend

PTRV_F_FBLK Form Blocks of the Trip Costs Form

PTRV_F_FBLK_TXT Form Blocks of the Trip Costs Form

PTRV_F_SORTKEY Sort Key for Individual Receipt Block

PTRV_F_SORTKEY_T Sort Key for Individual Receipt Block

PTRV_HEAD General Trip Data

PTRV_KMSUM Table for Use of Miles/Kms Accumulation

PTRV_ME_CCC_RUN Assign Personnel Number to Credit Card

PTRV_OFFLINE_TXT Texts for Download to Offline Creation

PTRV_PERIO Period Data of a Trip

PTRV_PERNRPREFS Personalization at Employee Level

PTRV_REASGN_FM Conversion of FM Data in Trip (e.g. Fis

PTRV_REDUCTION Decision Fields: Change of Statutory Tr

PTRV_ROT_AWKEY Assignment of Trip Results to Posting D

PTRV_RPRPOSTD Log of Posting Program RPRPOSTD

PTRV_SADD Trip Statistics - Add. Receipt Data

PTRV_SBACKLOG Trip Statistics - Batch/Backlog Process

PTRV_SCOS Trip Statistics - Cost Assignment

PTRV_SHDR Trip Statistics - Trip Amounts

PTRV_SREC Trip Statistics - Receipts

PTRV_SUBSTITUTE ESA Fast Track - Expense Reporter Subst

PTRV_SYNC Customizing Synchronization with Offlin

PTRV_SYNC_OUT

PTRV_T706Z_DNPR Field Control Screens

PTRV_T706Z_DNPRT Field Control Screens

PTRV_T706Z_FLDS Field Names for Field Control

PTRV_TRIP_CHAIN Table of all Trip Destinations f. Proce

PTRV_TRIP_DELETE Trips Deleted in SAP System for Offline

PTRV_USERPREFS User Profiles in Travel Management

PTRV_WAF_CONFLCT Offline Travel Management: Conflict Proces

PTRV_WAF_FSEL Code Conversion: Screen Field Name into BA

PTRV_WAF_RESTART Restart File for Mobile Solution with Over

PTRV_WAFGUID Logging for Synchronization GUID (DUPRECS)

PTRV_WAFLOG Log File for Inbound Container in Travel M

PTRV_WAFLOG_CC Offline Log File - Settings

Hope this helps you:)

Thanks,

Pavithra.