Data Entry Layout (SAP Library - Consolidation (EC-CS))

Data Entry Layout

Definition

Form for entering financial data reported by consolidation units and consolidation groups.

Use

Data entry layouts are used for entering reported financial data both online in the SAP System and offline on the basis of MS ACCESS. You can use various layouts, depending on the type of data to be entered and the level of detail involved.

Structure

You define the layouts that you require in Customizing, in the section Define Data Entry Layouts.

Each definition is valid for a particular consolidation chart of accounts. You can also restrict a layout to a particular fiscal year, period, version, dimension, consolidation unit and/or unit of measure.

When you define a data entry layout, you specify its structure. A layout consists of a header and an input area.

The header data specifies the fiscal year, period, chart of accounts, consolidation unit, and so on, for which you are entering data.

The input area is where you enter financial data. It consists of lead columns and value columns:

- Lead columns contain characteristics. Financial statement (FS) items, measure of unit and all subassignments (partner unit, subitem, transaction currency, year of acquisition, period of acquisition and all custom subassignments) are supported as characteristics.

The line structure of the data entry layout is a combination of characteristics and their corresponding values. This structure usually consists of FS items and their breakdown by subassignments.

- Value columns contain key figures. Group currency, local currency, transaction currency, and quantity are supported as key figures.

You enter reported financial data in the value columns. Depending on how you define your value columns, you enter data in one or more currencies, or as quantities.

Note

You can also define comparative value columns, for example to display the data from the prior year as a comparison. Comparisons are possible for the characteristics fiscal year, FS item and version.

In addition to that you can define the value columns with formulas, for example to display the difference between the current local currency values and the local currency values of the prior year.

You also have the possibility to use Microsoft Excel functions: The data entry layouts, which were already defined, can be reworked with Excel functions, for example formatting, and then entered in the financial data spreadsheet.

For further information, see the Implementation Guide (IMG) step Define Data Entry Layouts.