Overview of Travel Expenses

Technical name: 0FITV_C01_Q0001

Based on InfoCube 0FITV_C01 (Travel Expenses: Trip Totals and Receipts)

Use

The Overview of travel expenses query can be used primarily as a control instrument for the costs incurred by business trips. It displays, by trip provision variant, the total costs of all the trips created, the miles/kilometers traveled and the trip duration in days.

If you also include the user-defined characteristics Trip country and Settlement status, you can, for example, display the costs incurred for all trips to the USA created with the trip provision variant 01 (Germany) that have already been settled.

You can also restrict the display to a specific time frame:

  • Display by calendar year
  • Display by quarter

If you select a filter value, only the data for the quarter or calendar year entered is displayed. To view the values of several quarters or years next to one another for comparison, use the appropriate time characteristic to expand the evaluation.

Filters

InfoObject

Description

0TV_RECEIPT

Receipt number (= #)

For the characteristic Receipt number a difference is made between two types of record: receipts and trip totals. The filter set here means that only records with trip totals (no receipts) flow into the query.

User-Defined Characteristics

InfoObject

Description

0TV_COUNTRY

Trip country / trip country group

0EMPLOYEE

Employee

0PERS_AREA

Personnel area

0PERS_SAREA

Personnel Sub Area

0EMPLSGROUP

Employee Subgroup

0MAST_CCTR

Master cost center

0ORGUNIT

Organizational unit

0CALQUARTER

Calendar year/quarter

0CALYEAR

Calendar year

Rows

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0TV_VARIANT

Trip provision variant

Columns

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0TV_COUNT1

Number

0TV_SPAYOUT

Payment

0TV_STOTAL

Total costs

0TV_KM_TOT

Total miles/kms

0TV_DURATIO

Trip duration

The characteristic Number represents the number of all the trips created. If you want to break the number down further, you have to expand the display in the query by the user-defined characteristic Settlement status.