Checking the Data Collection 

Use

A number of basic options are available to collect data in the EC-CS component, including realtime update from transaction applications in the same system, transfer from other systems using rollup, offline data entry using MS Access or MS Excel, flexible upload of files, or manual online data entry directly in EC-CS. Our model uses the flexible upload, which has already been performed using upload method UPL01 (or UPL02). The uploaded data can be verified in the data monitor.

Procedure

  1. Call up the transaction as follows:
    2.

    Menu Path

    Accounting ® Enterprise Controlling ® Consolidation ® Data collection ® Monitor

    Transaction Code

    CXCD

  2. In the next dialog box, enter the following data:
    3.

    Field

    Data

    Dimension

    01

    Version

    100

    Fiscal year

    1998

    Period

    012

    Consolidated chart of accounts

    01

    Ledger

    CS

    On the Data Monitor screen, you initially see the overall status of all the consolidation tasks that have been assigned to the monitor.

    A red light means that errors have occurred during the execution of the tasks. A yellow light indicates the incomplete execution of the tasks. A green light means that the consolidation tasks have been completed error-free.

  3. Choose to expand the hierarchy completely.

    4. This allows you to see the overall status for any consolidation units or groups at a glance. Note that the status is inherited from bottom to top. This means if the status of a consolidation unit is incomplete, all the consolidation groups containing that unit will also be incomplete.

  4. If required, choose Layout ® Show tasks, to see the tasks that have been assigned to the respective monitor.

    5. If there is not enough space on the screen, you can remove the hierarchy description with Layout ® Hide CG/CU names.

  5. Choose , to display a symbol and color key of the tasks and overall status.

    6. The status of the individual tasks is more differentiated than the overall status, and is represented by different icons.

    A gray "x" shows that a task has not been started yet; a red minus sign means that the task is irrelevant for a consolidation unit (for example currency translation for a unit, whose local currency is identical to the group currency); a lightening bolt indicates errors; a red "x" indicates that a task is incomplete and a green checkmark means that the task is error-free; a closed lock means that a task is blocked and an open lock means that it is unblocked.

  6. Choose .

    7. It is possible to reduce the display scope in the data monitor. To only display consolidation group CG1 in the data monitor, choose Environment ® Global parameters. In the dialog box, enter consolidation unit C1000.

    To return to the display of hierarchies, choose Environment ® Global parameters, and delete the consolidation group and the consolidation unit.

  7. To present the status display in text form, choose Layout ® Icons <-> Texts.
  8. Select the combination Entry and C1000 and choose Test run.
  9. Select the Data entry layout 01-3000: Income Statement.

    10. You then see all the values that have been entered for the respective FS items in local currency. In this case, the layout was defined so that no further breakdown of the FS items is supported. As certain FS items require a breakdown, additional layouts were defined that provide this additional information.

  10. Choose .
  11. Select Data entry layout 01-32000: Cost Functional Area.
  12. Choose Position... and enter the FS item 312400 in the dialog box.
  13. Choose .

    14. You then see a breakdown of the values by functional areas.

  14. Choose to return to the Display Data screen.

    15. The Additional financial data screen area provides an option for entering additional information, which is required for the consolidation of investments.

  15. Choose Changes in Investments under Additional financial data.
  16. If necessary, expand the hierarchy with "+" to display details for unit C1000.

    17. Information is displayed about units C2000 and C2200, which are assigned below C1000 in the hierarchy. By double-clicking on C2000 you get information about the amount of investments by C1000 in C2000 and the value of these investments in C1000’s balance sheet. In addition, you can see which equity items appear in C2000’s balance sheet and in which amount.

  17. Choose , until the Data Monitor screen appears.

    18. Once a task has been performed successfully, you can block it using . This means this task (and its upstream tasks) cannot be performed again. This is only possible using .

  18. To start a series of tasks, which are then automatically processed one after the other, first select the appropriate consolidation unit or group and choose Run successive tasks.

    19. Automatic processing continues until a task that has been defined as a milestone in Customizing is reached. You meet this definition whenever the option of manual intervention is required for a certain task.

  19. Choose until the overview tree appears.