Executing the Key Figure Report with Constants  

You can execute a report at various points in the system:

  1. In the basic SAP R/3 menu, choose Information systems ® Accounting ® Financial Accounting ® General Ledger ® Select report or:
  2. Choose Periodic processing ® Info system ® Report selection in the General Ledger menu.

Prerequisites: Include Report in Reporting Tree

The first step after defining a new report is to include it in the report tree using the Create function. To do this, choose the step "Define report selection" in the General Ledger Accounting Implementation Guide.

Then proceed as follows:

  1. Choose Change tree and then expand the report tree at the "Info.system" node until you have reached the node at which you want to include the new report.
  2. Double-click on this node.
  3. In the first dialog box displayed choose Create and in the second Other type.
  4. Choose the report type "Drill-down reporting"
  5. Next enter the application class. The application class for Financial Accounting is "FBR".
  6. In the subsequent dialog box, enter the report type "Balance sheet ratios" and then use F4 to select a technical name for the report.

    7. The report is included in the node.

  7. Save the report tree.

For further information on the functions available in the report tree, see the documentation for the step "Report selection".

Enter Settings for Executing the Report

You can start the selected report with the Generate list function or with a double-click. Before actually executing the report use Change settings to specify those characteristic values and variables which you defined in your forms and reports.

You can enter values for your key figure report in the following characteristic value fields:

You can also enter a value for the following variable:

To valuate the variable which you used for the characteristic ‘Fiscal year’, enter 1995, for example, in the Year field. No further entries are required in the other fields.

The valuation of the variable then works as follows:

Say you used the variable &1FY for the first column of your report, the variable &1FY-1 for the second column and the variable &1FY-2 for the third column. If you now specify the fiscal year "1995" for the variable, the system inserts "1995" in the first column of the report, "1994" in the second column and "1993" in the third column. For further information see Valuating Variables.

The constant "Number of employees" does not have to be valuated at this point, since you have already entered a value for this within FI Customizing.

The settings for the balance sheet/P&L version are ignored in this instance as the balance sheet version has already been defined in the form.

You can also specify the type of currency for your reports (company code currency, group currency, hard currency, index-based currency and global company currency).

Once you have carried out all the necessary settings, save the report and then execute it for the organizational unit (company, company code, business area) you require. The saved values are retained should you want to execute the report again.