Using Drilldown Reporting 

  1. Call up the transaction as follows:
  2. Menu Path

    Accounting ® Enterprise Controlling ® Consolidation ® Information system ® Consolidation reports ® Drilldown reports ® Standard reports ® Current year with percentage balance sheet

    Transaction Code

    S_ALR_87011791

  3. Enter the following data:
  4. Field

    Data

    Description

    Dimension

    01

    Companies

    Totals cons group

    CG1

    Legal dimension worldwide

    Version

    100

    Actual version

    Fiscal year

    1998

     

    Period

    012

     

    Consolidated chart of accounts

    01

    COGS – Appr in B/S (US)

  5. Choose .
  6. Expand the item hierarchy up to FS item 01/190000 P P & E, net.
  7. Select this item by clicking on the blue diamond. Select Subitem in the Navigation frame.
  8. The transaction types for this item appear.

  9. Choose , to call up the report.
  10. In the dialog box select Changes: local valuation > consol. data.
  11. Choose .
  12. This is another drilldown report that displays the changes to the item values starting with the reported vales, further through first consolidation, and all the way to the consolidated value. A standardizing entry in the amount of 5,000 was posted for item 191500 under Property, Plant and Equipment.

  13. Expand up to item 191500 and choose .
  14. The journal entry report is now started, and shows that document type 15 was used in a standardizing entry for the amount of 5,000.

  15. Choose , until you return to the Execute Current yr with structure % : B/S: Detail screen.
  16. Call up item 130000 IU Receivables by double-clicking on it.
  17. The system displays a breakdown by consolidation unit, without hierarchy.

  18. Choose .
  19. You see the values defined for the hierarchy from input help. Select consolidation group CG1 and choose .

    The consolidation units are displayed in the hierarchy for item 130000.

  20. Choose .
  21. Call up the transaction as follows:
  22. Menu Path

    Accounting ® Enterprise Controlling ® Consolidation ® Information system ® Consolidation reports ® Drilldown reports ® Standard reports ® Current year with percentage balance sheet

    Transaction Code

    S_ALR_87011791

  23. Enter the following data:
  24. Field

    Data

    Description

    Dimension

    01

    Companies

    Totals cons group

    CG4

    Legal dimension worldwide

    Version

    100

    Actual version

    Fiscal year

    1998

     

    Period

    012

     

    Consolidated chart of accounts

    01

    COGS – Appr in B/S (US)

  25. Choose .
  26. Choose .
  27. In the dialog box, choose .
  28. The consolidation units for the hierarchy are now displayed within CG4.

  29. Choose until the overview tree appears.
  30. In the dialog box, choose Yes.