Web: My Cost Centers – Travel Expenses – Detail
Web: My Cost Centers – Travel Expenses – Detail
Technical name: 0FITV_C01_Q1004
Based on InfoCube
Travel Expenses: Totals and Receipts
Use
This query displays the document number and amount for each expense type for individual trips of an employee. A column shows whether the defined expense limit was exceeded.
The sum of the reimbursed costs are displayed, as well as the costs of reimbursed documents, sorted by expense type.
The information can be filtered by trip number or employee.
You can personalize the controlling area of the master cost center and
trip provision variant so that they are selected automatically. Without personalization, you must enter this information when you start the query.See also:
WEB: Personalization.This query is intended chiefly for use in the Web Cockpit
My Cost Centers – Current Situation, although it can also be accessed individually.
IDs for integration with the Web Cockpit:
<BW_URL>&CMD=LDOC&WBID=6P6XSB4NMGAVES3DCTF431LKL&PAGEID=costctr_start
IDs for individual access to the query in the Web:
<BW_URL>&CMD=LDOC&WBID=6P6XSB4NMGAVES3DCTF431LKL&PAGEID =travel_details
In the Web Cockpit, it functions together with the following queries:
My Cost Centers – Travel Expenses – Year My Cost Centers – Travel Expenses – Current My Cost Centers – Travel Planning – Current My Cost Centers – Travel Expenses – Last 12 Months My Cost Centers – Travel Expenses – Quarterly
This query is included in the workbook
My Cost Centers – Travel Expenses – Detail.Filters
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0TV_VARIANT |
Trip provision variant (variable &0P_TWAR&), personalization |
|
0TV__P_ETYPE |
Type of trip data (S = trip totals for travel expenses, E = individual receipt for travel expenses) |
User-Defined Characteristics
|
InfoObject |
Description |
|
0TV_TRIP |
Trip number (variable &0P_TRIP&, trip number) |
Rows
|
Row Name |
Description |
|
0TV_EXPTYPE |
Expense type |
|
0TV_RECEIPT |
Document number |
|
0TV_ABOVLIM |
Customizing limit for travel expense type exceeded |
Columns
|
Column Name |
Description |
|
Structure |
Document amount 0TV_RECAMNT |
|
Meals per diem 0TV_SPDFOOD |
|
|
Per diem for accommodations 0TV_SPDHOUS |
|
|
Travel flat rate 0TV_SPDMILE |
|
|
Document amount + meals per diem + per diem for accommodations + travel flat rate |