Technical 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.
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.
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.
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.
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.
You can perform technical reports as follows:
To open a query, in the Windows start menu choose , and then open the required query.
The following lists are available:
To run a database list, in the process view of the consolidation workbench, choose 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.
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 ), you can make a multiple selection for the consolidation area.
For more details about using this function, see SAP Note 1817997
.
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 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