Travel Expenses: Totals and Documents

Technical name: 0FI_TV_01

Use

The InfoSource delivers all the travel expense transaction data created using the R/3 component Travel Expenses. This is the data that has been transferred to the BW Business Content according to the settings in the extractor (this means, if no filter was used in the extract this will be all the available data).

Characteristics

InfoObject

Description

Data Element

Field in Transfer Structure

0TV_DEDFLAG

Deduction indicator

BELAZ

DED_FLAG

0TV_PAIDCOM

Receipt paid by company

BEZFA

PAID_COM

0TV_RECDATE

Receipt date

BELDT

REC_DATE

0TV_RECEIPT

Receipt number

NRBEL

RECEIPTNO

0TV_ABOVLIM

Customizing limit for travel expense type exceeded

PTRV_ABOVE_LIMIT

ABOVE_LIMIT

0TV_APPR_ST

Indicator for approved travel request or trip

ANTRG

ANTRG

0TV_ACCO_ST

Indicator: open/to be settled/settled

ABREC

ABREC

0TV_TRANDME

Indicator: DME transfer

UEBDT

UEBDT

0TV_TRAN_FI

Indicator: FI transfer

UEBRF

UEBRF

0TV_TRANPAY

Indicator: HR Payroll transfer

UEBLG

UEBLG

0COUNTRY_ID

Country grouping

MOLGA

MOLGA

0EMPLOYEE

Employees

PERNR_D

PERNR

0TV_REGION

Main destination region

HRGIO

HRGIO

0TV_DEPDATE

Trip segment: beginning date

REBED

DATV1

0TV_DEPTIME

Trip segment: beginning time

REBEU

UHRV1

0TV_ARRDATE

Trip segment: end date

REEND

DATB1

0TV_ARRTIME

Trip segment: end time

REENU

UHRB1

0TV_TT_STAT

Trip type - statutory

KZREA

KZREA

0TV_TT_COMP

Trip type - enterprise-specific

BEREI

BEREI

0TV_COUNTRY

Trip country/trip country group

LNDGR

ZLAND

0TV_TRIP

Trip number

REINR

REINR

0TV_VARIANT

Trip provision variant

MOREI

MOREI

0TV_SCHEMA

Trip schema

RSCHE

SCHEM

0TV_EXPTYPE

Travel expense type

SPKZL

EXP_TYPE

0TV_ACTYPE

Trip activity type

KZTKT

KZTKT

0TV_P_ETYPE

Record type trip data

PTRV_BW_ENTRY_TYPE

ENTRY_TYPE

0TV_ACMD_PD

Accommodations were settled per diem

UEPKZ

UEBKZ

0TV_MEAL_PD

Meals were settled per diem

VERPA

VERPA

Units

InfoObject

Description

Data Element

Field in Transfer Structure

0CURRENCY

Currency

WAERS

WAERS

In the appropriate source system (OLTP system) all amounts are translated into the trip currency on the respective end date of the trips. The trip currency depends on the trip provision variant for which the trip has been created.

For queries in which trips from different trip provision variants are evaluated, the amounts are translated to one currency in the query in the BW system (OLAP system). This currency is taken from the settings made in BW Customizing.

Key Figures

InfoObject

Description

Data Element

Field in Transfer Structure

0TV_SPAYOUT

Payment amount

PTRV_SUM_PAYOUT

SUM_PAYOUT

0TV_RECAMNT

Expense receipt amount

PTRV_LOC_AMOUNT

LOC_AMOUNT

0TV_SREIMBU

Reimbursement amount for a trip

PTRV_SUM_REIMBU

SUM_REIMBU

0TV_STOTAL

Total costs for a trip

PTRV_TRIP_TOTAL

TRIP_TOTAL

0TV_SADDAMT

Trip additional amount (tax to be paid by employee)

PTRV_ADDIT_AMNT

ADDIT_AMNT

0TV_KM_TOT

Total miles/kilometers

KMGES

M_TOTAL

0TV_DURATIO

Trip duration in days

PTRV_TRIPDUR

TRIPDUR

0TV_SPAIDCO

Travel expenses paid by company

PTRV_SUM_PAIDCO

SUM_PAIDCO

0TV_SPDMILE

Total flat rate travel costs

PTRV_PD_MILEAGE

PD_MILEAGE

0TV_SPDFOOD

Total per diem for meals

PTRV_PD_FOOD

PD_FOOD

0TV_SADVANC

Total advances for a trip

PTRV_SUM_ADVANC

SUM_ADVANC

0TV_SPDHOUS

Total per diem for accommodations

PTRV_PD_HOUSING

PD_HOUSING