Fleet Vehicle Trip, Fuel and Driver Allowance Tracking Program
Short answer: A custom program for companies running their own fleet that imports the fuel card statement into SAP, matches each transaction to a vehicle by plate or card number, takes trips from shipment documents and calculates the driver travel allowance. Kilometres, litres, consumption per 100 km and cost per km appear per vehicle in one list, and fuel and allowance costs are posted to the vehicle's cost object.
- Estimated effort
- M · 8–10 working days
- System
- ECC and S/4HANA
- Tables
- 9
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
Fleet management in plant maintenance keeps vehicle data and measuring points, and odometer and fuel readings are entered one by one with IK11; there is no import that reads the fuel card statement. Driver allowances are tracked separately in PR05 travel expenses or in accounting and are not linked to the vehicle or the trip. As a result, total cost and consumption per vehicle can only be seen by combining data in Excel.
Who uses it? Fleet and logistics managers, shipment planners, expense accounting and cost control teams.
Closest standard alternatives
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| FLEETFleet Attributes | Fleet object: plate, fuel card number, fuel type | Read | ECC + S/4 |
| EQUIEquipment Master Data | Vehicle equipment and object number | Read | ECC + S/4 |
| IMPTTMeasuring Point | Odometer and fuel measuring points of the vehicle | Read | ECC + S/4 |
| IMRGMeasurement Document | Check of the last counter reading; new odometer and fuel readings are written as measurement documents | Read / write | ECC + S/4 |
| VTTKShipment Header | Shipments counted as trips: dates, route, plate | Read | ECC + S/4 |
| VTPAShipping Partner | Driver on the shipment (partner with personnel number) | Read | ECC + S/4 |
| PA0001HR Master Record: Infotype 0001 (Organizational Assignment) | Driver's company code and cost center | Read | ECC + S/4 |
| AUFKOrder Master Data | Maintenance or internal order collecting the vehicle's costs | Read | ECC + S/4 |
| BKPFAccounting Document Header | Accounting documents created for fuel and allowance | Write | ECC + S/4 |
BAPIs and functions used
- BAPI_ACC_DOCUMENT_CHECKAccounting: Check Document. Checks the posting in test mode
- BAPI_ACC_DOCUMENT_POSTAccounting: Post Document. Posts the fuel invoice and the allowance to the vehicle's cost object
- BAPI_TRANSACTION_COMMITCommit a BAPI transaction. Commits the posting
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_FILE | Fuel card statement (CSV or XLSX) | Single value | — | Yes | C:\temp\yakit_2026_10.xlsx |
| P_BUKRS | Company code | Single value | BKPF-BUKRS | Yes | 1000 |
| P_LIFNR | Fuel company vendor account | Single value | LFA1-LIFNR | Yes | 100780 |
| S_IDATE | Trip and fuel period | Range / multiple | IMRG-IDATE | Yes | 01.10.2026 – 31.10.2026 |
| P_ALLOW | Also calculate and post the driver allowance | Checkbox | — | No | X |
| P_TEST | Test mode (check without posting) | Checkbox | — | No | X |
Input file columns
The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.
| # | Column | Target field | Required |
|---|---|---|---|
| 1 | Card number | FLEET-CARD_NUM | No |
| 2 | Plate | FLEET-LICENSE_NUM | Yes |
| 3 | Transaction date | IMRG-IDATE | Yes |
| 4 | Transaction time | IMRG-ITIME | No |
| 5 | Odometer | IMRG-CNTRR | No |
| 6 | Litres | IMRG-RECDV | Yes |
| 7 | Amount | BSEG-WRBTR | Yes |
| 8 | Currency | BKPF-WAERS | Yes |
| 9 | Station | BSEG-SGTXT | No |
Sample upload file
| 1 | Card number | Plate * | Transaction date * | Transaction time | Odometer | Litres * | Amount * | Currency * | Station |
|---|---|---|---|---|---|---|---|---|---|
| 2 | 7083 **** **** 1142 | 34 ABC 128 | 10/03/2026 | 07:42 | 184,520 | 412.50 | 18,975 | TRY | Gebze Otoyol |
| 3 | 7083 **** **** 1187 | 34 ABD 455 | 10/03/2026 | 18:10 | 92,310 | 186 | 8,556 | TRY | Bursa Çevreyolu |
| 4 | 7083 **** **** 1142 | 34 ABC 128 | 10/06/2026 | 06:55 | 185,870 | 398.20 | 18,317.20 | TRY | İzmir Kemalpaşa |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Plate | FLEET-LICENSE_NUM |
| 2 | Vehicle | EQUI-EQUNR |
| 3 | Trips | Calculated VTTK records carrying the vehicle's plate in the period |
| 4 | Kilometres | Calculated Last IMRG-CNTRR − counter at period start |
| 5 | Fuel (l) | Calculated Σ litres in the file |
| 6 | Fuel amount | Calculated Σ amount in the file |
| 7 | Consumption per 100 km (l) | Calculated Fuel (l) / kilometres × 100 |
| 8 | Cost per km | Calculated (Fuel amount + allowance) / kilometres |
| 9 | Allowance | Calculated Trip days × daily amount |
| 10 | Status | Calculated Posted, warning, test OK or error |
Sample result list
| Plate | Vehicle | Trips | Kilometres | Fuel (l) | Fuel amount | Consumption per 100 km (l) | Cost per km | Allowance | Status |
|---|---|---|---|---|---|---|---|---|---|
| 34 ABC 128 | 10004211 | 9 | 6,840 | 2,210.40 | 101,684 | 32.30 | 16.92 | 14,000 | Posted |
| 34 ABD 455 | 10004212 | 6 | 3,920 | 1,014 | 46,644 | 25.90 | 14.22 | 9,100 | Posted |
| 34 ABE 702 | 10004215 | 4 | 2,150 | 912.60 | 41,979.60 | 42.40 | 22.85 | 7,150 | Warning |
| 34 ABF 019 | 0 | 120 | 5,520 | Error |
How does the program work?
- The fuel card provider’s statement (CSV or XLSX) is read; the provider’s column layout is mapped during installation. Each row is linked to a vehicle (EQUI) by card number (FLEET-CARD_NUM) or plate (FLEET-LICENSE_NUM); unmatched rows go to the error list.
- The vehicle’s odometer and fuel measuring points are found in IMPTT. If the odometer value in the file is lower than the last reading (IMRG), or the consumption between two fill-ups is outside the defined limit, the row gets a warning; valid readings are recorded as measurement documents.
- Trips are read from the shipment documents (VTTK) that carry the vehicle’s plate in the period; the field holding the plate is set during installation. The driver comes from the partner role with a personnel number on the shipment (VTPA).
- The allowance is calculated as trip days × the daily amount defined during installation; domestic and international trips use different amounts. The driver’s cost center comes from PA0001.
- Posting: fuel spend is posted with BAPI_ACC_DOCUMENT_POST as a credit to the fuel company’s vendor account and a debit to the vehicle’s maintenance order (AUFK) or cost center. The allowance is written to the driver’s employee vendor account in a separate document. In test mode only BAPI_ACC_DOCUMENT_CHECK runs.
- Report per vehicle: number of trips, kilometres, litres, fuel amount, consumption per 100 km, cost per km and allowance. Vehicles whose consumption deviates clearly from the vehicle type average are flagged.
Performance notes
Read FLEET and EQUI once with the plates and card numbers from the file. Take only the most recent IMRG record per measuring point for the last counter readings. Post accounting entries totalled per vehicle and day; do not create a separate document for every fuel receipt.
Features
- Test mode (check without posting)
- Line-by-line result and error log
- Download failed lines as a separate file Statement rows that cannot be matched to a vehicle can be downloaded for correction.
- Runs as a background job When the provider drops the statement into a server folder, a weekly job processes it automatically.
- ALV list (sort, filter, subtotals)
Authorization objects
- I_SWERKVehicle and measurement document authorization by maintenance plant
- F_BKPF_BUKAccounting posting authorization by company code
- F_BKPF_KOAPosting authorization for vendor and expense account types
- P_ORGINAuthorization to read the driver's organizational assignment
Frequently asked questions
Can statements from different fuel card companies be read?
Yes. Each provider's column layout is defined as a separate mapping during installation; the same program reads statements from several providers and combines the results in the same vehicle list.
Where do the daily allowance amounts come from?
The amounts are kept in a table defined during installation, split into domestic and international, and updated by HR or finance. Regulation-dependent values such as tax-exempt limits are not published here; they are checked against current rules during installation.
We use the travel expense module; can the allowance go there instead?
Yes. Instead of posting directly to accounting, the allowance can be created as a trip for the driver, so approval and payment continue through the existing travel process.
Related reports
Maintenance Cost and Downtime by Equipment Report
A custom ALV report that splits the actual cost of maintenance orders per equipment in a period into labor, material, external services and other, and …
Measuring Point Limit Breaches Without Follow-Up Notification Report
A custom ALV report that compares measurement documents with the lower and upper limits of the measuring point and lists readings that crossed a …
On-Time In-Full (OTIF) Delivery Performance Report by Customer
A custom ALV report that compares every sales order item with the customer's requested delivery date and ordered quantity, and works out whether the …
Let us build this program for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.