Tables involved in Travel expense (Tcode TRIP)

[Former Member]

Hi All ,

I'm working on Travel Management and need to know some of the tables required for Travel expense .

I could find FTPT_REQUEST , FTPT_HEAD which mainly store the data for travel request (details such as booking details for hotel , flight , car etc )

Similarly I need the tables which store the data for Travel expense ( with details such as expenditure type , ammount etc).

Which tables should I refer ???

Thanks ,

Sonu M.

[lisa_miller3 · Accepted solution]

Try tables:

 PTRV_HEAD
 PTRV_PERIO 
 PTRV_KMSUM
 PTRV_SADD
 PTRV_SCOS
 PTRV_SHDR
 PTRV_SREC
 etc.

Lisa

[Former Member · Accepted solution]

Hi Lisa ,

Thanks a lot .. It solved my problem ..

PTRV_SREC was the table i was looking for ..

Thanks ,

Sonu M.

[Former Member]

HI

GOOD

CHECK OUT WITH THESE TABLES

PRMF Travel Expenses: Feature TRVFD

PRMO Travel Expenses: Feature TRVCO

PRMP Travel Expenses: Feature TRVPA

THANKS

MRUTYUN

[Former Member]

Hi Mrutyun ,

I'm sorry , but I couldnt find these table names in the database. Are these tables or clusters ???

Thanks ,

Sonu M.

[Former Member]

HI

GOOD

SOORY FOR AND WRONG ANSWER

CHECK OUT WITH THE TABLE PCL2

ITS A TRANSPARENT HR CLUSTER TABLE

Database Table PCL2

· The database table PCL2 contains the following data areas:

B2 time accounting results

CD cluster directory of the CD manager

PS generated schemas

PT texts for generated schemas

RX payroll accounting results/international

Rn payroll accounting results/country-specific ( n = HR country indicator )

ZL personal work schedule

Cluster Definition

· The data definition of a work area for PCLn is specified in separate programs which comply

with fixed naming conventions.

· They are defined as INCLUDE programs (RPCnxxy0). The following naming convention applies:

n = 1 or 2 (PCL1 or PCL2)

xx = Relation ID (e.g. RX)

y = 0 for international clusters or country indicator (T500L) for different country cluster

CHECK THIS OUT.I HOPE THIS WILL HELP YOU.

THANKS

MRUTYUN

[Former Member]

Hello Sonu,

U can do a runtime analysis which will help to get details of tables.

[former_member181962]

Hi Sonu,

Check the following tables:

FTPT_CAR_PREF

FTPT_FLIGHT_PREF

FTPT_HOTEL_PREF

FTPT_PNR

FTPT_TRAIN_PREF

FTPT_VAR_INFO

Regards,

Ravi

[Former Member]

Hi Ravi ,

These tables store the data for Travel Request . I want to know the tables which store the data for <b>Travel Expenses </b> .

Thanks .

Sonu M.

[former_member181962]

Hi Sonu,

Give ftpt* in se11 and press f4. YOu can find so many tables related to travel.

REgards,

Ravi