Google+ Using Variables in SAP Business Warehousing - SAP ABAP

Using Variables in SAP Business Warehousing

Variables in SAP Business Warehousing are used at the planning level.

Planning Level A variable may be selected against a given characteristic available in the level. Instead of entering a characteristic value click on the variable icon. Then the list of variables for that characteristic is presented in a pop-up. One may now be selected and it will be transferred to the "from" field of the selection. No "to" value may be entered. If you wish to no longer use the variable in the selection click on the icon once again and it will blank the "from" field leaving the selections available to be used for characteristic values.

Note that this is only possible within the planning level – not within the planning package. If you were to have flagged the "selection in package" box for a given characteristic and then go to create or change a package you will see that the variable icon is greyed out.

Manual Planning Layouts: Where a given characteristic is selected in the first screen of the manual planning layout wizard to appear in the Data columns a variable may be selected. When in the configuration of data columns click on the variable icon. Then a pop-up appears allowing the selection of a variable and (in the case of time characteristics only) an offset. 

The usage of so-called "dynamic" columns and how variables may be employed there is explained in the unit of this course concerning advanced manual planning.

Planning Levels : In the selection tab where you make restrictions when configuring the level

You can choose to select a variable instead of characteristic value(s)
Manual Planning Layouts
When creating or changing a layout using the manual planning layout wizard (in the data columns and/or lead columns tab within the second screen)

You can choose to select a variable instead of a characteristic value
You can also use the variable value in the column/row heading

Parameter Groups of Planning Functions (not Formulas):

Conditions - Instead of entering a characteristic value click on the variable icon. Then the list of variables for that characteristic is presented in a pop-up. One may now be selected and it will be transferred to the "from" field of the selection. No "to" value may be entered. If you wish to no longer use the variable in the selection place the cursor in a field for the "from" value, click on the icon once again and it will blank the "from" field leaving the selections available to be used for characteristic values.

Fields to be Changed - Instead of entering a characteristic value click on the variable icon. Then the list of variables for that characteristic is presented in a pop-up. One may now be selected and it will be transferred to the "from" field of the selection. Depending on the function type there may be a "to" field so you can enter a range of values. A variable may likewise be selected here. If you wish to no longer use the variable in the selection place the cursor in the respective field, click on the icon once again and it will blank the field leaving the selection available to be used for characteristic values.

Parameter Groups of Planning Functions (not Formulas)

In the entry conditions make restrictions when configuring the conditions

You can choose to select a variable instead of characteristic value(s) Likewise for the values of the fields to be changed

You can choose to select a variable instead of a characteristic value

Parameter Groups (Formula Editor) of Formula Planning Functions Within the formula editor using the simple programming language to set up a formula to manipulate transaction data

You may use an expression employing the function "VARV" to work with a variable value rather than a fixed value. If the variable contains more than one value, you can use the "VARI" and "VARC" functions Formulas also use variables known as "local" or "auxiliary" variables. The variables which we set up in the planning area are known as "global" variables to distinguish them.

Variables in Planning Folders

Planning Folders: You may hide the display of variables using the "Close Variables" push button (or "Hide Variable Values" icon). You may show them again using the "Display Variables" push button (or "Show Variable Values" icon).

At any point during the execution of the folder you may change the variable value to work with and press "Refresh" to apply the change. You do not need to include variables in layouts or functions, which you do not want to change, into a planning folder.

Since the system does not display layout header areas in planning folders with output layout and since it is not possible to use the "Change header combination" for this mass type, you can create a similar function with variables. In this case, however, you have to consider that variables influence the characteristic selection of a package, but the system only displays a part of the package with the "Change header combination" function (for folders without output area). This may effect the performance and the planning functions on the same level. Caution: in layouts where the header area is not completely restricted to single values, the system always uses the "first" header characteristics for which there is data available. No other characteristic combinations are accessible in the "with separate output area" folders.

Therefore, restrict the header area of such folders in a unique manner.In most cases, it is useful to activate the "Restriction of values required" flag in variables which you want to use in planning folders. Then you can be sure that functions and layouts in the planning workbench.  





Adding Variables to Planning Folder

When editing the planning folder the variables to be used are simply included by dragging and dropping the required variables into the work area. To ensure that all those variables that are used in the layouts of the folder are contained in the folder, choose Go to → Global Settings. The system then lets you add missing variables to the folder. It also advises you if there are "surplus variables" which you can then choose to remove.




Related Posts

No comments :

Post a Comment