Web: My Profit Center Travel Expenses Last Three Months 
Web: My Profit Center Travel Expenses Last Three Months
Technical name: 0FITV_C01_Q1007
Based on InfoCube
Travel Expenses: Totals and Receipts
Use
This query displays the travel expenses of the profit center for which the user is responsible. In the connected query 0COOM_C02_Q1020, all cost centers assigned to the profit center are automatically derived from InfoCube 0COOM_C02 (
CO-OM: Costs and Allocations (Delta Extraction).
The query shows the number of trips, the trip duration, and the total costs for the last three months.
The data is displayed by country and can be filtered by trip number, employee, or master cost center.
You can personalize the controlling area of the master cost center and
trip provision variant so that you dont need to enter them each time you call up the query.See also:
WEB: Personalization.
This query is intended chiefly for use in the
Web Cockpit: My Profit Center Current Situation, although it can also be accessed individually.
IDs for accessing the Web Cockpit:
<BW_URL>&CMD=LDOC&WBID=9IFZT67YG2FTF0105SK5BVCKQ&PAGEID=profitctr_start
ID for individual access to the query in the Web:
<BW_URL>&CMD=LDOC&WBID=33D2ZYSN24XVVH7A3RHAM35AT&PAGEID=q4
In the Web Cockpit, it functions together with the following queries:
My Profit Center Travel Expenses Year My Profit Center Travel Expenses Quarterly My Profit Center Travel Months My Profit Center Plan/Actual Current and YTD My Profit Center Plan/Actual Quarterly
This query is included in the workbook
My Profit Center Travel Expenses Current.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) |
|
0EMPLOYEE__0CO_MST_AR |
Controlling area of master cost center (variable &0P_COAEM&, my controlling area, single value entry, personalization) |
User-Defined Characteristics
|
InfoObject |
Description |
|
0TV_TRIP |
Trip number |
|
0EMPLOYEE |
Employee |
|
0EMPLOYEE__0MAST_CCTR |
Master cost center (variable &0SPPCTRE&, cost centers for my profit center, personalization) |
Rows
|
Row Name |
Description |
|
0TV_COUNTRY |
Trip country |
Columns
|
Column Name |
Description |
|
Structure months (&0T_CMNTH& &0T_MYEAR&) |
Characteristic: Calendar Year/Month (variable &0CMLMON&, last month) |
|
Characteristic: Calendar Year/Month (variable &0CMLMON-1&, last month 1) |
|
|
Characteristic: Calendar Year/Month (variable &0CMLMON-2&, last month 2) |
|
|
Summation of last three months: &0T_CMNTH& &0T_MYEAR& + &0T_CMNTH& &0T_MYEAR& + &0T_CMNTH& &0T_MYEAR& |
|
|
0TV_COUNT1 |
Number |
|
0TV_DURATIO |
Trip duration |
|
0TV_STOTAL |
Total costs |