Travel Expenses: Totals and Receipts

Technical name: 0FITV_C01

Use

The InfoCube Travel Expenses: Totals and Receipts contains all the transaction data transferred from the source system (OLAP system) to the BW system for travel expense reports created using the R/3 component Travel Expenses.

You can use the Calendar Day, Calendar Year/Month, Calendar Year/Quarter, and Calendar Year as time dimensions in your evaluations. You can evaluate these key figures according to various attributes:

  • Personal data of the traveler (such as nationality, gender, and language)
  • Organizational data (such as personnel area, employee group, and organizational unit)
  • General trip data (such as beginning and end date of a trip, trip type, trip provision variant)
  • Travel expense status and attributes of the travel expense receipts

The update rules specify how the time characteristics are to be determined for the key figures. All indicators with the trip end date are to be updated.

InfoSources

Data is transferred to this InfoCube from the following InfoSources:

0FI_TV_01: Travel Expenses: Trip Totals and Receipts

Characteristics

InfoObject

Description

0TV_DEDFLAG

Deduction indicator

0TV_PAIDCOM

Receipt paid by company

0TV_RECDATE

Receipt date

0TV_RECEIPT

Receipt number

0TV_ABOVLIM

Customizing limit for travel expense type exceeded

0TV_ACCDATE

Trip settlement date

0TV_APPR_ST

Indicator for approved travel request or trip

0TV_ACCO_ST

Indicator: open/to be settled/settled

0TV_TRANDME

Indicator: DME transfer

0TV_TRAN_FI

Indicator: FI transfer

0TV_TRANPAY

Indicator: HR Payroll transfer

0COUNTRY_ID

Country grouping

0EMPLOYEE

Employee

0TV_REGION

Main destination region

0TV_DEPDATE

Trip segment: Beginning date

0TV_ARRDATE

Trip segment: End date

0TV_TT_STAT

Trip type - statutory

0TV_TT_COMP

Trip type - company-specific

0TV_COUNTRY

Trip country/trip country group

0TV_TRIP

Trip number

0TV_VARIANT

Trip provision variant

0TV_SCHEMA

Trip schema

0TV_EXPTYPE

Travel expense type

0TV_ACTYPE

Trip activity type

0TV_P_ETYPE

Record type trip data

0TV_ACMD_PD

Accommodations were settled per diem

0TV_MEAL_PD

Meals were settled per diem

  • The characteristic Traveler is no longer used and should no longer be used. The InfoObject OEMPLOYEE (employee) should be used instead.
  • The Travel expense type has the navigation attribute Travel expense category, that you can also include in an evaluation.

Time Characteristics

InfoObject

Description

0CALDAY

Calendar day

0CALMONTH

Calendar year/month

0CALQUARTER

Calendar Year/Quarter

0CALYEAR

Calendar year

Key Figures

InfoObject

Description

0TV_COUNT1

Number

0TV_SPAYOUT

Payment amount

0TV_RECAMNT

Expense receipt amount

0TV_SREIMBU

Reimbursement amount for a trip

0TV_STOTAL

Total costs for a trip

0TV_SADDAMT

Trip additional amount (tax to be paid by employee)

0TV_KM_TOT

Total miles/kilometers

0TV_DURATIO

Trip duration in days

0TV_SPAIDCO

Travel expenses paid by company

0TV_SPDMILE

Total flat rate travel costs

0TV_SPDFOOD

Total per diem for meals

0TV_SADVANC

Total advances for a trip

0TV_SPDHOUS

Total per diem for accommodations

Units

InfoObject

Description

0CURRENCY

Currency Key

All amounts are translated into the trip currency on the respective end date of the trips in the relevant source system(s) (OLTP system). The trip currency depends on the trip provision variant in which the trip was 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.