Entering Reported Financial Data Online (SAP Library

Entering Reported Financial Data Online

Procedure

In the Consolidation menu, choose Data collection ® Monitor.
Check the global parameters by choosing Environment ® Global parameters.
Put the cursor on the consolidation unit for which you want to enter data and the task for data entry, and choose Update run.

Select a data entry layout and choose Enter.

If you have entered variables instead of fixed values or a range of values in your definition of the subassignments, you are required to enter values for the variables in the following screen. Enter these values and choose Goto ® Reported data.

Note

Further procedures are dependent on whether you have activated Integrated Excel in Customizing, step Define Data Entry Groups.

Further Procedures for Data Entry without Integrated Excel

The data entry layout appears. This contains header data, lead columns and value columns. To reduce the amount of information on the screen, you can hide the header data if you do not need it for reference.

Enter the financial data in the value columns. You enter values for items and subitems without a debit/credit sign. The system automatically determines the sign from the item master data.

Note

Your financial statement items show any breakdowns that are specified both in the layout and in the breakdown category for the individual items.

If an item has a breakdown, its identifier and text are displayed in the first row only (for the first breakdown), and you only see the breakdown information. This feature makes it easier for you to locate individual items in the input area. However, you can show the item information in all rows again by choosing Settings ® All key values on/off.

The system automatically inserts 0.00 in any lines where you cannot enter values (for example, a totals item).

Totals items are displayed if you specifically specify this by choosing Settings ® Lead columns. However, this is only possible if you specified a set generated for item hierarchies as the characteristic value for the item in the layout definition.

If you want to make an additional entry with a subassignment value, for a financial statement item in your layout, which will not be displayed as the default value, then use the empty lines at the end of the layout.

To move the new entry to the correct position, choose Refresh. The new entry will only be displayed if you entered a value other than zero.

Save your entries.

To print out the layout with the data you entered, choose Reported data ® Print reported data.

Further Procedures for Data Entry with Integrated Excel

If in Customizing, you have only set the indicator for the use of Integrated Excel and have not designed any spreadsheet templates, then the system presents the data in the data entry layout, without formatting, in the upper left corner of the new spreadsheet.

If you have designed a spreadsheet template in Customizing, then the system opens it.

Enter your financial data. Note the following:

Avoid the following Excel functions:

Delete
Insert
Sort

When you use these Excel functions, then the system cannot import the data correctly into the database.

If you want to delete the values entered, then choose Edit ® Delete, in the SAP menu.
The ready for input status of individual cells corresponds to how they were defined in the data entry layout, provided that the Excel spreadsheet is protected.
The SAP system only imports data from the first spreadsheet of an Excel folder. Therefore you can execute additional calculations or insert diagrams in the second spreadsheet.
If you enter Excel formulas in the SAP data area, these are overwritten when posting with the result of the formula, and the formula itself is lost.
When you want to save, no cells can processed in Excel at that point. You can control this by showing the formula bar in Excel (View ® Formula bar in Excel).

Note

The following functions, which the system offers when you enter financial data with data entry layouts, are not supported when using Integrated Excel:

FS item hierarchy display
The following functions under the menu option Settings:

Number format
All key values on/off
Header presentation on/off

If you want to make an additional entry with a subassignment value, for a financial statement item in your layout, which will not be displayed as the default value, then use the empty lines at the end of the layout.

To move the new entry to the correct position, choose Refresh. The new entry will only be displayed if you entered a value other than zero.

Save the data.