Function documentationTechnical Reports

 

You run technical reports to clear up uncertainties about the data in the data basis. In contrast to business reports, technical reports are not intended to produce financial statement-type output, but rather to verify the completeness and consistency of the data in the data basis. Nevertheless, several technical reports prompt you to select business criteria, which is then used to restrict the volume of the report data.

Features

You can run technical reports in different ways and with different tools:

  • SAP NetWeaver Business Intelligence (BI) queries – either delivered by SAP or created by the customer – that are based on the InfoProviders in the Business Content for consolidation.

  • The analysis area of the consolidation workbench provides database lists that are structured according to business criteria.

  • Lists are available for numerous types of objects in the consolidation workbench. (For example, you can display a list of the items in the consolidation chart of accounts of a consolidation area.) The system automatically supplements many of these lists with additional useful information. For example, the list of period categories contains not only the properties of all period categories, but also a compilation of all period category groups to which a certain period category belongs.

Different Results in Business Reports and Technical Reports

Although the database lists in the consolidation workbench are structured according to business criteria, in certain situations these lists can display different figures than the corresponding business reports which use queries based on a virtual InfoProvider or a MultiProvider for consolidation.

The database lists always show all postings for the consolidation units that you selected on the selection screen. In contrast to the business reports with queries, the database lists do not check whether the consolidation units are indeed valid in the consolidation group you have selected. Hence, the comparability of the figures of database lists with the figures of business reports is limited. For more information on business reports, see Data Staging in the Virtual InfoProvider.

Restatement

In reporting mode Restatement, selecting by reference year and reference period is required. If you do not specify the reference year and reference period, the system determines these values as follows:

  • If you use the role Restatement, the system determines the values from the highest restatement value that you entered in the selection.

  • If you do not use the role Restatement, the system determines the values from the most recent fiscal year and latest posting period that you entered in the selection.

Reference

In reporting mode Reference, as is the case in reporting mode Restatement, you must specify the reference year and reference period.

You can use this reporting mode to expand the enterprise hierarchy for the reference period. The system only displays the data records that were posted in a period when a company belonged to the group according to the hierarchy of the reference period.

Activities

You can perform technical reports as follows:

Business Explorer Analyzer (BEx Analyzer)

To open a query, in the Windows start menu choose Start of the navigation path Programs Next navigation step Business Explorer Next navigation step Analyzer End of the navigation path, and then open the required query.

Consolidation Workbench
  1. The following lists are available:

    • To run a database list, in the process view of the consolidation workbench, choose Start of the navigation path Analysis Next navigation step List Data End of the navigation path and double-click to call the selection screen for the required report.

    • To display a list for one of the object types of the consolidation workbench, navigate to the desired object type and choose List Settings in the context menu of the object type.

  2. In the selection screen that appears, make any restrictions to the characteristic values and execute the report.

    On the selection screen of the Totals Data list (Consolidation Workbench Start of the navigation path Analysis Next navigation step List Data Next navigation step Totals Records End of the navigation path), you can make a multiple selection for the consolidation area.

    For more details about using this function, see SAP Note 1817997Information published on SAP site.

    If you have activate the Financials, Group Close, Check Digits (FIN_ACC_GC_CHKDGT) business function, the following enhancements are available for the selection screen:

    • You can configure that the system checks the values of all input fields on the selection screen. To do so, in the configuration menu for consolidation (transaction UC00), from the Environment node, select the Activate Value Check on Selection Screen activity. Create a new entry for Activate Value Check on Selection Screen and enter the Characteristic Value X.

      Without this setting, the system checks the values of only those input fields that represent a single value.

    • The selection screen for the Journal Entries list contains the Further Restrictions group box with the following indicators:

      • Do Not Display Reversal Document Pairs

      • Do Not Display Inversion Document Pairs

      If you set these indicators, the system excludes pairs of reversed and associated reversal documents or pairs of inverted and associated reversal documents that were posted in the specified period from the display.

      Note Note

      Note the following special features for the Do Not Display Inversion Document Pairs indicator:

      Since you cannot specify multiple selections but rather only a single value for the fiscal year on the selection screen, this indicator has no impact on the display for inverted or inverting documents that belong to an inversion document pair that spans fiscal years.

      If you set this indicator, the system ignores the entries for the following fields on the selection screen:

      • Fiscal year of the inverting document

      • Period of the inverting document

      • Fiscal year of the inverted document

      • Period of the inverted document

      End of the note.