Process documentation Example: Execution of Validation of Reported Financial Data Locate the document in its SAP Library structure

Initial Situation

You have collected the reported financial data and want to check the data before posting standardizing entries.

In doing this, you want to make sure that the assets side equals the liabilities side in the balance sheets of all consolidation units.

You consolidate once per year.

Process Flow

A. Customizing

Define method

Method with check expression

  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 with:
  1. Below the method, create the check expression This graphic is explained in the accompanying text : Total Assets = Total Liabilities.

Selection condition

  1. Create a selection condition as follows:
    1. Choose New in the work area of the workbench in the selection area.
    2. For the first selection, assign the title Total Assets.
    3. To select the characteristic Item, choose Insert Row This graphic is explained in the accompanying text.
    4. Select the total assets item from the consolidation chart of accounts.

Proceed in the same manner for total liabilities:

The system displays the selections in the work area.
  1. Save your changes.

Formula

You create the formula VAL_PER( total assets ) + VAL_PER( total liabilities ) = 0. (Total liabilities are added to total assets because the system stores liability items with a negative sign.) Proceed as follows:

  1. Place the cursor in the formula editor.
  2. In the function list, double-click the function VAL_PER.
  3. If necessary, place the cursor inside the bracket, and double-click the selection Total Assets in the list of selections.
  4. Select the operator "+".
  5. In the function list, double-click the function VAL_PER.
  6. If necessary, place the cursor inside the second bracket, and double-click the selection Total Liabilities in the list of selections.
  7. Select the operator "=".
  8. Choose Number and enter "0" (zero).
  9. Save your changes.

Message

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

Now 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.

  2. In the work area, specify the message number, the message class, and the message type (in this case, "Success" (S)).
  3. Save the message.
  4. Proceed in the same manner for the false expression. In this case, use the message type "Error" (E).

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. In the group field Values, choose all of the following options:
  1. Select the period category the represents annual consolidation.
  2. Do not select the indicator that states that the method is dependent on the organizational unit. This way, the method applies equally to all organizational units.
  3. Assign the method (you previously created) to the task.
  4. Save the task.

B. Execution of the Validation

Prerequisite: The task is assigned in a task hierarchy.

Execute the validation task in the consolidation monitor.

  1. Place the cursor at the intersection between the task for validating reported financial data and the top consolidation group.
  2. Choose Update Run.

Result

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