Drilldown List and Defining Percentage Shares

Defining a drilldown list for online display

Once you have defined a form, you can define how the drilldown list should be displayed online. To do so, choose Extras ® Drilldown display ® Select rows/columns.

Then select all the rows and columns which you want the system to display in the standard drilldown list. Once you have made your selections, choose the function Save selections (the green check mark in the red box), and the system will display the chosen layout for you to check. The system will save the drilldown list finally when it saves the entire form. This layout defines the formal structure of the reports which are based on that form.

Defining a drilldown list for printout

It may sometimes be useful to define a different drilldown list for printouts than for online display. For example, this might be the case if you want to limit the online display of a wide report to the most important columns, in order to make it easier to read, but still want to use the horizontal format to display additional columns in the drilldown list for the printout.

You define the drilldown list for the printout under Extras ® Drilldown printout the same way you defined the drilldown list for online display.

Before you save the form, you should execute the function Form ® Check. If you defined anything incorrectly or left anything undefined, the system displays a message informing you of this. Then you can make the necessary changes and thus be certain that the form is correct before you use it in a report.

Percentage columns and rows

You can define rows or columns of a form to contain percentages of sums by using the elements Share of grand total (Syntax: %T(ABC), where ABC is the "grand total") and Share of sub-total (Syntax: %S (XYZ), where XYZ is the "sub-total") in the formula editor. The total here refers to the total for the highest drilldown characteristic, whereas the sub-total refers to the total for each characteristic (at each level) of the drilldown hierarchy.

For more information, see the online system Help (F1).

For an example of these functions, see the standard report 0-SAP05 for costing-based Profitability Analysis in operating concern S001.