Expense Receipts

Technical name: 0FITV_C01_Q0003

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

Use

The Expense receipts query shows the travel expense amounts for each trip provision variant dependent on the expense type (such as entertainment, car rental).

To break the evaluation down further you can display receipts already paid by the company separately or include them in the evaluation. In addition to this you can drilldown according to employee or organizational criteria.

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

  • Display by quarter
  • Display by calendar year

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 of the InfoObject (and restriction or calculation formula)

0TV_RECEIPT

Receipt number ([ ] 001 - 999)

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 receipts (no trip totals) flow into the query.

User-Defined Characteristics

InfoObject

Description

0TV_EXPCAT

Travel expense category

0TV_PAIDCOM

Receipt paid by company

0EMPLOYEE

Employee

0PERS_AREA

Personnel area

0PERS_SAREA

Personnel Sub Area

0EMPLSGROUP

Employee Subgroup

0CO_MST_AR

Controlling area of master cost center

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

0TV_EXPTYPE

Trip provision variant

Travel expense type

Columns

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0TV_COUNT1

Number

0TV_RECAMNT

Travel expense amount

In this query the characteristic Number refers to the number of receipts.