Show TOC

 Entering Initial Fuel Level

Use

To be able to settle fuel costs using service charge settlement, you have to record fuel levels and costs, and determine the amount of fuel consumption . For this process, you first have to enter the initial fuel levels.

Prerequisites

You made the Customizing settings described in Calculation of Fuel Consumption .

Procedure

There are two ways of entering the initial fuel level, either:

Individually by entering the data on the settlement unit

Mass processing by uploading data from a Microsoft Excel file in CSV format

Enter initial fuel level on settlement unit, master settlement unit, or cost object settlement unit:

In the RE Navigator, select the settlement unit, for which you want manage fuel, and for which you defined a service charge key in Customizing.

Choose the Fuel Level tab page.

Choose the Create pushbutton.

Select the Initial Level indicator on the Selection dialog box.

You can now process the initial level for this fuel type.

Enter all required data, such as:

Asset value date and posting date

Name of fuel

Fuel quantity

Amount for fuel quantity

Gross Y/N

If the Gross indicator is set, the system assumes that the initial value entered contains value-added tax. The systems converts the initial level to net when you save, and shows the gross value in the text. The Gross indicator corresponds to the indicator X in the Excel file. In this way, the posting is taken into account using standard opting, and is settled with regard to the tax authorities.

Upload initial level from Excel (mass processing):

The Microsoft Excel document containing the data for mass upload into the SAP system must be in CSV format and have the following structure:

Excel Column

Field/Description

Sample Entry

A

Company code

1000

B

Business entity

2000

C

Service charge key

3100

D

Settlement unit

1

E

Asset value date (in YYYYMMDD format)

19980713

F

Posting date (in YYYYMMDD format)

19980713

G

Fuel quantity ( without unit and without decimals)

2000

H

Unit of measure (must agree with Customizing settings for given business entity)

L (for liters)

I

Fuel value (including value-added tax in local currency; for opting real estate objects including due input tax backlog)

1000

J

Local currency

CHF

K

Value-added tax (X for value-added tax and blank (apostrophe in Excel file) for no value-added tax) In that case the entered fuel value must be the gross value (including value-added tax).

X or blank

The tax group used through the indicator for the conversion of the gross amount into the net amount is the same as the tax group that you entered in Customizing for fuel management in the country-specific settings for Switzerland.

On the SAP Easy Access screen, choose AccountingFlexible Real Estate ManagementCountry SpecificsSwitzerlandFuel ManagementMass Processing of Initial Level

You can also access this transaction when processing the settlement unit. On the Fuel Level tab page, choose Upload Initial Level.

When you choose this function, you leave processing of the settlement unit, and it is not possible to return to it simply by choosing Back (F3)

In the Import group box, enter the document in CSV format, from which you want to load data to the SAP system.

Run the program.

Result

You entered the initial level for one or more fuels on settlement units. The system posts the initial level to a balance sheet account in the Financial Accounting (FI) component. In addition, the system posts the initial level to the expense account for the service charge settlement, with additional account assignment to the settlement unit. These two postings are made with or without value-added tax, depending on your Customizing settings.

You can then post additions and removals, as well as enter the ending fuel level (see Managing Fuel Levels ).