Leading business in sustainable way is becoming increasingly relevant today and a “must-have” in the future. 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 with new specific fields, which provide information about kilometers covered in business trip, vehicle type that was in use. New info provider /SKYBFR/FITV was created based on standard 0FITV_C01 cube but with additional dimensions for specific reporting. The information about trip distances and emission is collected from SAP Qualified Partner-Packaged Skybuffer Solution based on SAP Travel Expenses functionality. Google Cloud Platform integration provides distance calculation for different transportation types. Type-dependent distance calculation allows considering every kilometer in transportation expenses according to transportation routes.
On the screen shot below enhanced transformation rules between modified 0FI_TV_01 data source and new cube /SKYBFR/FITV are shown.
This report shows CO2 emission and distance in tons depending on different vehicle types per calendar month.
Column at the left side of the Query was build like “hierarchy” of restricted key figures based on different vehicle types (characteristic /SKYBFR/GRTYP (A, B, C, F, R, T..) original field /SKYBFR/GRTYP.
condition 1 | condition 2 | |
domestic | 0-480km | AND the same country |
short haul | 0-1500 | N/A |
medium Haul | 1501-4000 | N/A |
long-haul | >4001 | N/A |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.