SAP Information System Reporting Variables

SAP Information System Reporting Variables allow you greater flexibility when you define forms and reports. These are parameters that you do not need to specify until you define or even execute the report. You can use variables in a variety of different ways. You can define either a global or a local variable, depending on how you want to use it.If you want to use a variable in only one form or report, define a local variable. Local variables are only valid in the form or report where you created them. Once you have defined a local variable in a form, though, it is valid in all the reports that are based on that form.If you want to be able to use the variable in a number of forms and reports, define a global variable. Global variables are valid in any form or report. You define global variables in Customizing. To use a global variable in a form or report, simply choose it from the Possible entries list. If you change a global variable that is already being used in forms or reports, this affects every form and every report that uses that variable.

Variables in Forms

You use a variable for a characteristic value if you want to leave the value undefined in the report or form definition and specify it when you execute the report. You can use variables for characteristic values in both forms and reports. If you use the variable in a form, you can specify a characteristic value either when you define or when you execute a report that uses that form. Variables used in the report definition are replaced upon report execution. Certain variables for characteristic values, such as “Current fiscal period”, are contained in the standard R/3 System. To see which other standard variables are available, see Customizing.If you want to use a variable for the row or column texts in a form, you need to define a text variable.For example, if you use a variable for the value of characteristic “Country”, the text to be used in the column is not yet known when you define the form. Here you can define a text variable.

Text variables can only be used in form reports and are always defined directly in the form. They are replaced automatically by the text of the characteristic value you specify when you execute the report. In the above example, you can specify a country (characteristic value) when you execute the report. The system then automatically enters the name of that country (text) in the column header.

Certain variables for texts are contained in the standard R/3 System. To see which other standard variables are available, see Customizing.

Account-based Profitability Analysis

The information system has some special features for account-based Profitability Analysis:

This type of Profitability Analysis is supported by separate forms, reports and authorization objects for combinations of characteristics. Apart from these authorization objects, account-based CO-PA uses the same ones as costing-based Profitability Analysis.You can represent a hierarchy based on the characteristic "Cost element" by specifying a set in Customizing. The following display forms are available:

Compact display
ŸLine display
ŸAsterisk display

You can display different currencies in the same report:

ŸControlling area currency
ŸCompany code currency
ŸTransaction currency

You can display line item lists in account-based Profitability Analysis as well. You can also format the lists as you wish by using your own line item layouts. If you do not specify a layout, the system uses the standard line item layout.

ABC- Analysis

With the help of various analysis functions you can classify and rank your CO-PA data. There are three analysis functions available:

Cumulative curve
ŸABC analysis

Ranking Report Data

An exception is a rule that determines whether a profitability segment's performance differs significantly from what had been expected. You can define exceptions for any key figure in a cell or an entire column of a report.An exception consists of two threshold values that determine the range of tolerance within which the value might move. If the value exceeds the upper threshold or falls below the lower threshold, the system displays it in the color that was defined for that threshold (green or red).

There are two basic types of exceptions: You can define an exception for a single cell (intersection between one row and one column) or for an entire column.You can only define an exception on a drilldown list. Once you have done so, the exception is also applied to the corresponding detail list and can be changed from there. Relative key figures, such as percentage variances, can generally be compared at different levels of a drilldown report. It therefore makes sense to define column exceptions for these.

Executing Reports

When you execute a drilldown report online, the system displays a selection screen where you specify what data you want to see. You can define selection variants to simplify this process. A selection variant contains a set of selection parameters and other settings for a report. You can also use selection variants to execute reports in the background. You do this by first defining a variant group and entering a number of selection variants for different reports in that group. Then you can schedule the entire variant group for background processing.

Thus a variant group lets you combine separate tasks into one step:
Schedule different combinations of variables for one report
ŸSchedule variants for different reports

You can schedule a job once you have defined the variant group and selected the desired reports. This job can also be scheduled for execution in regular intervals. For more information, see the documentation BC Computing Center Management System.

Related Posts

No comments :

Post a Comment