Mobile Menu

Analytics solution provides varied queries based on travel expenses data application in source systems.

The main goal of Travel Expenses data flow and Reporting development is to provide an opportunity to analyze business trips KPIs in SAP environment, for example, trip expenses per organizational unit, CO2 emission report per vehicle type, distances per trip, etc.

Conducting business in more sustainable ways is becoming increasingly relevant today and a “must-have” in the future. The sustainability megatrend is driven by a growing population, accelerating urbanization, resource intensity, government regulation, climate change, and – most importantly – by the fact that consumers are increasingly demanding healthy, affordable, as well as socially and environmentally responsible products. Organizations react by implementing more sustainable practices to grow their business, to attract the best talent and to remain relevant to their investors.

One of the main ways for the company to be sustainable is to control its travel expenses and its CO2 emission per travel.

Standard BI content (Data Source 0FI_TV_01, “Travel Expenses: Totals and Receipts” InfoCube) for Travel Expenses provides information only about trips, travelling employees, expenses per trip. But there is no information about trip distances: mileage covered by trip, emission. The information about vehicles used in a trip is not collected, either. So, it is impossible to calculate emission per trips, per employees, per organizational units.

For this purpose, the standard data source 0FI_TV_01 was enhanced, new info provider /SKYBFR/FITV was created based on standard 0FITV_C01 but with additional dimensions for specific reporting. The information about trip distances and emission is collected from source systems from travel expenses application.

Here are the key features of /SKYBFR/RTE2 1.2 Achernar BW on HANA Reporting:

5383 :: BW Report: CO2 Emission by Vehicle Type

This report shows CO2 emission and distance in tons depending on different vehicle types (characteristic /SKYBFR/GRTYP (A, B, C, F, R, T..) original field /SKYBFR/GRTYP) per calendar month.

Average CO2 emission per different expense types can be found in table /SKYBFR/RTE1C_CO and customized through transaction /SKYBFR/RTE1_CO2.

5385 :: BW Report: Travel Costs

This report shows costs according to the Country of Destination (field 0TV_COUNTRY, original field ZLAND “Trip Country”). Costs per Employee Gender and Expense Type (0TV_EXPTYPE) can be found in the same list of the workbook.

5386 :: BW Report: Detailed List of Trips by Date

This report shows detailed information per trips and employee that helps to monitor the number of trips and check details per each trip.

5387 :: BW Report: Receipts Amounts

This report provides details on the number of receipts and the amounts the receipts are for according to the trip provision variant and the expense type.

5388 :: BW Report: Summarization Overview

This report provides an overview of Payment, Total Costs, Total miles/km, Trip Duration, Number per Trip Country.

5389 :: BW Report: Number of Trips

Based on Employee attributes like Organizational Unit or Personal Area, it is possible to show the number of trips and costs per these categories.

5390 :: BW Report: Top 10 Costs per Trip Country

Top 10 Costs per Trip Country (0TV_COUNTRY) shows 10 most costly directions of business travel.

5391 :: BW Report: Top 10 Costs per Employee

Top 10 Costs per Employee shows top 10 travelers.

5392 :: CO2 Emission Lumira Discovery Dashboard

Top managers can be provided with a dashboard to monitor CO2 Emission and Distances. The dashboard shows emission of CO2 per Calendar Month, Top Travel Countries by CO2 Emission, Top Vehicles Type by CO2 Emission, Travel Distances.