Process documentation Execution of Validations Locate the document in its SAP Library structure

Purpose

You use this process to initially make the customizing settings for validation, and then to execute the validation task.

Prerequisites

Prerequisites for executing validations

Depending on what type of data you want to validate, you need to have executed the following tasks:

Process Flow

A. Customizing

Either use the standard customizing settings for validation, or create your own validation methods and tasks, which is described as follows.

Define method

Method with check expressions

  1. To define a validation method, go to the process view of the workbench and choose Consolidation Functions ® Validation ® Method.
  2. Select the entry Method and choose Display in the context menu.
  3. In the lower left screen area, choose Create from the context menu.
  4. Create a method This graphic is explained in the accompanying text and give it a technical name and description.
  5. Beneath the method, create one or more expressions This graphic is explained in the accompanying text .
  6. Under the nodes for a true expression This graphic is explained in the accompanying text and/or false expression This graphic is explained in the accompanying text you can create:

Selection condition

  1. Create a selection condition as follows:
    1. Choose New in the area for operators in the work area of the workbench.
    2. Assign a name to the selection.
    3. To select characteristics for the selection, choose Insert Row This graphic is explained in the accompanying text.
    4. Select one or more characteristic values for the selection.

Repeat the same procedure for further selections.

  1. To tell the system which selections to use in the formula editor, choose List This graphic is explained in the accompanying text, select Use in Formula Editor for each selection, and confirm your entries.
  2. The system displays the selections in the work area.

  3. Save your changes.

Formula

To assemble a formula for the check expression, proceed as follows:

  1. Place the cursor in the formula editor.
  2. Assemble the formula by choosing the functions, selections, and operators. You insert operators by (single-) clicking the buttons; and you insert selections and functions by double-clicking at the end of the formula or at the position where you placed the cursor beforehand.
  3. Run the syntax check by choosing Check This graphic is explained in the accompanying text in the toolbar above the formula editor.
  4. Save your changes.

Note

For detailed documentation on the formula editor, choose This graphic is explained in the accompanying text in the toolbar above the formula editor.

Message

Go to Message Maintenance (transaction SE91) and create a message class and two messages:

Then return to the workbench and proceed as follows:

  1. To create the message for the true expression, select the true node This graphic is explained in the accompanying text and choose Create Message in the context menu.
  2. The system creates a node for the message.

  3. In the work area, specify the message class, the message number, and the message type (for example, "Success" (S)). Enter the message text.
  4. Save the message.
  5. Proceed in the same manner for the false expression.

Define Task

  1. To define a validation task, go to the process view of the workbench and choose Consolidation Functions ® Validation ® Task.
  2. Select the entry Task and choose Display in the context menu.
  3. In the lower left screen area, choose Create from the context menu.
  4. Specify a technical name, a short text, and a medium text for the task.
  5. Choose which data is to be validated (reported , standardized , or consolidated financial data).
  6. Determine whether you are validating values in local or group currency.
  7. Select the period category.
  8. Specify whether the method is to be dependent on the organizational unit.
  9. Assign the method (you previously created) to the task.
  10. Save the task.

B. Execution of the Validation

Execute the validation task in the consolidation monitor.

  1. Place the cursor at the intersection between (a) the task for validating reported financial data and (b) the consolidation unit or consolidation group.
  2. Choose Update Run.

Result

The result of the validation task is displayed in a log.