Example: Asset History Sheet (SAP Library - Business Consolidation (SEM-BCS))

Example: Asset History Sheet

Initial Situation

You want to create a data entry layout for an asset history sheet.

Prerequisites

You have finished customizing your financial statement items and subassignments.

If applicable, you have created a hierarchy for data entry groups and you have created a data entry group.

Preliminary Considerations

The asset history sheet should look like this:

This graphic is explained in the accompanying text

You need the following rows:

Fixed asset items
Transaction type for acquisition and production costs
Transaction type for accumulated depreciation
Transaction type for book value

You need the following columns:

Opening balance
Additions
Divestitures
Closing balance

You need the local currency as the key figure in these columns.

Thus, you can create a data entry layout with the following structure:

Object					Name
Asset history sheet [data entry layout]					Asset history sheet
	Asset history sheet [form]				Asset history sheet
		Row structure
			Data-driven		Item
			Predefined fixed
				Column/Row	Acq. Cost
				Column/Row	Acc. Dpr.
				Column/Row	Book Value
		Column structure
			Predefined fixed
				Column/Row	Open.
				Column/Row	Add.
				Column/Row	Divest.
				Column/Row	Close
			Predefined fixed
				Column/Row	LC

Explanations:

The row structure for the fixed asset items should be data-driven and be based on the master data of the items.
The remaining row and column structures are predefined and fixed.

Activities

If you already created a data entry group, now define a data entry layout for the asset history sheet.

Call up the customizing environment for manual data entry by going to the process view in the workbench and choosing Consolidation Functions ® Data Collection ® Manual Data Entry.

Create a data entry layout by selecting the data entry group and choosing Create in the context menu.

In the work area in the Name column, assign the name Asset History Sheet for the data entry layout.

Create a form for the data entry layout by selecting the data entry layout in the object tree of the work area, and choosing Create in the context menu.

The form can be reused in other layouts if you give it a name. Call this form Asset History Sheet, as well.

Create the row structures:

Create a data-driven row structure for the fixed asset items by selecting the Row Structure entry and choosing Data-driven Structure in the context menu.

If applicable, assign a name for the structure.

Define the structure on the Structure tab page.

Select the characteristic Item.
Define the range of values for fixed assets.
List the values according to the master data.
Do not select a hierarchy.
Do not display totals.
Display keys and long texts.
Do not select the indicator for "Display Only".
Sort by keys in ascending order.

Create a predefined fixed row structure by selecting the Row Structure entry and choosing Predefined Fixed Structure in the context menu.

Name the structure Transaction Type.

Define one row each for the acquisition cost, accumulated depreciation, and book value.

When doing this, select the entry Predefined Fixed and choose Create in the context menu.
Assign the suitable name for each row (Acq. Cost, Acm.Dpr., Book Value).
Do not select the indicator Display Only.

Select the characteristic Transaction Type.
Specify the range of values for each transaction type.

Create the column structures:

Create a predefined fixed structure.

In the structure, create one column each for the opening balance, additions, divestitures, and the closing balance. (Follow the same steps as for creating the predefined fixed row structures.)

Create another predefined fixed structure.

Select the characteristic Key Figure and select the single value Periodic Value in Local Currency.

Save your entries.

Result

To preview the results, go to the Preview tab.

This graphic is explained in the accompanying text

You can assign the data entry group that contains the data entry layout Asset History Sheet to a data collection method.

In turn, you can assign the data collection method to a data collection task.

You execute the task for each separate consolidation unit in the consolidation monitor.