Maintaining Asset Master Data

Objective

After completing this lesson, you will be able to maintain fixed asset master data

Asset Accounting Master Data Maintenance

The 3D printer was now put into action. Before Kevin can process the asset in accounting, he must create the master record - but it seems that he made a mistake.

Kevin assigned the wrong asset class. How can he now fix his mistake. Do you know the answer?

Decide on one of the options below, before joining Kevin's conversation with Lisette to learn the correct answer.

  1. Overwrite the selected asset class to continue with the transaction.
  2. Delete the saved asset and restart the transaction by selecting the correct asset class.
  3. Leave selection as is and restart the transaction by selecting the correct asset class.

In case you opted for the second option, you were on the right track. Well done!

Fields to be Maintained

Lisette shows Kevin the fields that need to be maintained when creating an asset master record.

The figure outlines the process of creating asset master data. It categorizes the data into two main types: General/Inventory data and Asset value data. General/Inventory data includes fields such as Description, Inventory, Last inventory on, Time-dependent data, Cost center, Plant/Location, Origin, Supplier, Ledger, and Capitalized on. Asset value data encompasses Depreciation keys, Useful life, Expired useful life, and Depreciation start date. Key fields Description, Cost center, Depreciation keys, Useful life are marked with an asterisk (*). The process emphasizes the importance of accurately capturing these data fields to create proper asset master record.

Mandatory Fields

An asterisk* indicates the mandatory fields that must be filled out when entering master data.

Other Fields

Some fields are optional. For example, you can propose the capitalization date. This is considered when the asset is capitalized.

Time-dependent data

Time-dependent data in the asset master record allows the system to do the following:

  • Display the correct account assignments for a given time frame.
  • Use the correct account assignments for posting and reporting purposes.
  • Store the changes to the account assignments, maintaining detail history.

Create the Main Asset Master Data

To see his newly acquired knowledge in a practical context, Kevin now looks at the process in the system.

Now test your acquired knowledge and help Kevin create the master record for the 3D printer.

Maintenance of Similar Asset Accounting Master Data

Kevin is already facing the next challenge. Let's see what this one is about, by starting the video below.

Putting Theory into Practice

Below you can see an example of how the maintenance of multiple similar assets would look like in practice.

The figure illustrates the process of creating multiple fixed assets for a company that orders computers. First, the company orders the computers. Since the assets only differ in their descriptions, they are created simultaneously. The process involves specifying the company code and asset class, determining the number of similar assets (e.g., 3), creating similar main assets, changing the asset descriptions, and then finalizing the creation. As a result, multiple assets are created at once, each with a unique identifier and description, such as Personal Computer 1, Personal Computer 2, and Personal Computer 3.

Kevin can either create a single asset, or several similar assets at the same time. This is possible for main asset numbers as well as for asset sub-numbers. This function is used, for example, if the assets needed only differ in their description.

The bike company buys equipment such as mobile phones, office furniture or office computers in large quantities.

All these assets must be registered by an office accountant in the SAP S/4HANA system before they are distributed to the employees. To track these items, each asset is assigned a specific ID, such as a serial or inventory number, during processing. This task is quite time-consuming. For each asset, an employee must manually assign such an identifier and update the master data manually.

Kevin asks Lisette: Is there another way?

You can replace this manual effort by using automation and having a bot do the work. Once the automation is set up, multiple assets can be entered into the input Excel file. With just one click, the bot automatically updates the asset master data in the SAP S for HANA Cloud system.

Let's see what that looks like in action.

Asset Master Record Creation with Sub-Numbers

In the Bike Company, often times very large multi-part assets are purchased. This is also the case for the newly acquired 3D printer with a protective enclosure. Kevin wonders how he can best manage complex assets like these.

Your Turn

Would you know how? Take a moment to decide between the two answer options below, before you continue with listening to Lisette's answer.

  1. I guess I would need to create a main asset and then manage the components by using different sub-numbers.
  2. I guess I would need to create and maintain several assets in the system.

Did you take your time to think about what option makes more sense to you? Let's see what Lisette tells Kevin.

If a fixed asset is made up of many component assets, you can manage these component assets as separate sub-numbers. Doing so may be useful for technical and accounting reasons. You may divide assets by sub-numbers for the following reasons:

  • You want to separately manage the values for subsequent acquisitions (buildings, for example) in the following years.
  • You want to separately manage the values for individual parts of assets.
  • You want to split the asset according to various technical aspects.
The figure depicts a hierarchical structure of a 3D printer and its components. At the top, there is an image of a 3D printer labeled 3D-printer main number 20000001-0. Below it, two components are listed: Component 1 with the sub number 20000001-1 and Component 2 with the sub number 20000001-2. The structure illustrates the relationship between the 3D printer and its individual components.

Let's take a closer look at multi-part assets like the 3D printer.

Main Asset

-0 always indicates the main asset. The 3D printer can only reference the main number. This means that the invoices for complementary components of the welding machine are posted to this main number. The system then displays the acquisition costs of the entire asset in total.

Sub Assets

Additional components are managed separately. However, the assets are linked using the same asset number (20000001). If the asset is to be completely removed from the asset portfolio, for example, by retirement, you can select the asset and its sub-numbers.

Create an Asset Master Record as Sub-Number

Kevin is now ready to create asset sub-numbers. Follow him along the process by starting the video below.

Kevin creates a sub-number for the protective enclosure of the 3D printer.

Log in to track your progress & complete quizzes