Entering content frame

Procedure documentation Working with Structures Locate the document in its SAP Library structure

Prerequisites

You want to process characteristics with structures. Structures are available in Interactive Excel for all the hierarchies and sets.

Procedure

In the Interactive Excel menu choose Consolidation ® Structures ® Update or ® Change/Combine/Detach. You have the following options:

Update structure

You can update the structure, in order to supply it with current data from the SAP System.

Change structure

Here you have the following options:

  • Only compile the area of definition: only the cells which belong to the area of definition of th e matrix, are processed/deleted
  • Compile matrix area: all cells can be processed/deleted, which either belong to the are of definition or t o the output area of the matrix
  • Compile complete rows/columns: complete rows or columns are always processed
  • You can also select a different hierarchy or a different set for the structure To do this, press Edit, select the structure to be changed and change it

With this option you can activate and/or deactivate the automatic update using This graphic is explained in the accompanying text

Combine structure

You can combine several structures for different characteristics The values of all combinations are multiplied through all levels.

For example, this applies to all breakdowns, to sets with consolidation units, transaction types, transaction currencies.

Detach structure

You can detach various combined structures.

Delete structure

You can delete structures, for example the structure of the consolidation units.

Result

By working with structures, you can make the dataset clearer and in particular easier to evaluate.

 Leaving content frame