Travel Expenses: Totals and Receipts

Technical name: 0FI_TV_01

Technical Data

Type of DataSource

Transaction data (movement data)

Application Component

FI-TV

Available from OLTP Release

4.5B

Available from Plug-In Release

SAP R/3 Plug-In 99

RemoteCube-Compatible

No

Prerequisites

You must have generated the statistics data for Travel Management Customizing: Financials ® Financial Accounting ® Travel Management ® Define Structure of Trip Statistics.

Use

The DataSource provides all travel expense transaction data created using SAP Travel Expenses. This is the data that is transferred to the BW Business Content based on the settings in the extractor (if no filter was used in the extractor, this will include all available data).

Delta Update

Not possible

Origin Fields in the Extract Structure

Field in Extract Structure

Description of Field in Extract Structure

Table of Origin

Field in Table of Origin

PERNR

Personnel number

PTRV_HEAD

PERNR

REINR

Trip number

PTRV_HEAD

REINR

ENTRY_TYPE

Type of trip data

*)

*)

WAERS

Currency key

PTRV_HEAD

WAERS

MOLGA

Country grouping

PTRV_HEAD

MOLGA

MOREI

Trip provision variant

PTRV_HEAD

MOREI

SCHEM

Trip schema

PTRV_HEAD

SCHEM

KZREA

Trip type - statutory

PTRV_HEAD

KZREA

BEREI

Trip type - company-specific

PTRV_HEAD

BEREI

KZTKT

Trip activity type

PTRV_HEAD

KZTKT

ZLAND

Trip country/trip country group

PTRV_HEAD

ZLAND

HRGIO

Main destination region

PTRV_HEAD

HRGIO

DATV1

Trip segment: Beginning date

PTRV_HEAD

DATV1

UHRV1

Trip segment: beginning time

PTRV_HEAD

UHRV1

DATB1

Trip segment: End date

PTRV_HEAD

DATB1

UHRB1

Trip segment: end time

PTRV_HEAD

UHRB1

ANTRG

Indicator: travel request or trip approved

PTRV_PERIO

ANTRG

ABREC

Indicator: open/to be settled/settled

PTRV_PERIO

ABREC

UEBLG

Indicator: HR Payroll transfer

PTRV_PERIO

UEBLG

UEBRF

Indicator: FI transfer

PTRV_PERIO

UEBRF

UEBDT

Indicator: DME transfer

PTRV_PERIO

UEBDT

VERPA

Meals per diem settlement

PTRV_PERIO

VERPA

UEBKZ

Accommodations per diem settlement

PTRV_PERIO

UEBKZ

ADDIT_AMNT

Trip additional amount (tax to be paid by employee)

PTRV_SHDR

ADDIT_AMNT

SUM_REIMBU

Reimbursement amount for a trip

PTRV_SHDR

SUM_REIMBU

SUM_ADVANC

Total advances for a trip

PTRV_SHDR

SUM_ADVANC

SUM_PAYOUT

Payment amount

PTRV_SHDR

SUM_PAYOUT

SUM_PAIDCO

Travel expenses paid by company

PTRV_SHDR

SUM_PAIDCO

TRIP_TOTAL

Total costs for a trip

PTRV_SHDR

TRIP_TOTAL

PD_FOOD

Reimbursement amount (total) meals per diem

PTRV_SHDR

PD_FOOD

PD_HOUSING

Reimbursement amount (total) accommodations per diem

PTRV_SHDR

PD_HOUSING

PD_MILEAGE

Reimbursement amount (total) travel flat rate

PTRV_SHDR

PD_MILEAGE

M_TOTAL

Total miles/kilometers

PTRV_SHDR

M_TOTAL

TRIPDUR

Trip duration in days

PTRV_SHDR

TRIPDUR

RECEIPTNO

Document number

PTRV_SREC

RECEIPTNO

PAID_COM

Paid by company

PTRV_SREC

PAID_COM

EXP_TYPE

Travel expense type

PTRV_SREC

EXP_TYPE

LOC_AMOUNT

Receipt amount in local currency

PTRV_SREC

LOC_AMOUNT

REC_DATE

Document date

PTRV_SREC

REC_DATE

ABOVE_LIMIT

Customizing limit for trip expense type exceeded

PTRV_SREC

ABOVE_LIMIT

DED_FLAG

Deduction indicator

PTRV_SREC

DED_FLAG

*) If the fields table and field name in table are not filled, the field does not come directly from a database table but is determined in the extractor.