Creating Formula Variables

  1. On the Create Formula Variable: Basic Data screen, enter the following data:

  2. – Description of the variable

    The name of the field used for the variable is defaulted as the variable description. You can change this description as required.

    – A formula for the variable in the Formula field.

    This field appears if the field name for which you are defining the formula variable is a numeric field. The formula determines the default value for the variable. See the table in Formulas for the operators that you can use in a variable formula.

    You create a formula variable called YEAR (current year), which uses the user exit S001 to determine the current year. You enter this user exit as ‘#S001’ in the Formula field. You then refer to this formula in another formula variable called PR-YEAR (previous year). You enter this formula as:

    ‘&YEAR’ - 1

    The system determines the current year using the value determined by formula variable YEAR, and then subtracts one year for the value of the formula variable PR-YEAR.

    – An SAP standard or user-defined exit for the formula variable in the Formula exit field.

    This field appears if the field name for which you are defining the formula variable is a non-numeric field. If you enter a user-defined exit, this user exit must be defined in a user exit form pool. You can specify the name of this form pool in Customizing for Special Purpose Ledger by choosing Basic Settings → User Exits → Maintain Client-Independent User Exits . Example user exits are defined in form pool RGSVU000.

    The dimension Account (field name RACCT) is a non-numeric field. You cannot enter a formula; you must enter a formula exit name.

    – Indicator that determines if the variable is an internal variable.

    If you set this indicator, the default value of the variable cannot be changed when a report is run that uses the variable. If you do not set this indicator, the default value of the variable is displayed, and you can change it when a report is run that uses the variable.

    – Authorization group for the variable, if required

  3. You can use the following additional functions on this screen.

  4. Additional Processing Functions - Create Formula Variable: Basic Data Screen

    Choose

    To

    Edit → Type change: Value

    Change the variable type from a formula variable to a value variable.

    Extras → Formula exits...

    Display a list of existing user exits defined for formulas.

    Utilities → Variable directory

    Display a directory of variables.

    Utilities → Non-used variables

    Display a directory of variables that are not used in the system. You can then delete these variables if required.

    Utilities → Transport → Export

    Export variables to an external file.

    Utilities → Transport → Import

    Import variables from an external file.

    Utilities → Transport → Copy from client

    Copy variables from client 000 (or another client) to the client in which you are working.

    Utilities → Transport → Transport request

    Include a variable in a Customizing transport request and transport the variable. For more information, see the Transport Sets/Variables activity in the Implementation Guide (IMG) for Special Purpose Ledger (FI-SL).

  5. To save the variable, choose Variable → Save .