What Are Substitutions?
Substitution rules are stored in the Rule Manager. When data is entered in the system, it is substituted by the Integration Manager. Substitution occurs before the data is added to the FI-SL summary tables.
In FI-SL substitution, the values entered into the SAP R/3 System are validated against a prerequisite defined by the user. When the prerequisite is met, the system replaces the values entered with substitute values, and the substitute values are transferred into the FI-SL application component.
The system first performs validation and then substitution. This gives you the opportunity of having the system validate values that are to be substituted.
A substitution process can contain up to 999 steps. Before posting, therefore, you can substitute the values using any number of Boolean statements.
A substitution step contains the following statements:
The prerequisite statement establishes which conditions must be fulfilled before the substitution can be performed. If the prerequisite statement is false, the transaction is continued without substitution. If the prerequisite statement is true, the transaction is continued with the substituted values.
The substitution value is a numerical value or a string of letters that replace the value entered. A single substitution process can replace more than one value.
You can specify that substitution is to be performed through a substitution exit. The substitution exit number directs the system to an ABAP program defined by the user. Substitution exits enable you to define more complex substitutions and replace more than one value in a substitution. For more information, see
When you define substitutions, you use the same syntax that you use with validations. The prerequisite statement used in a substitution can consist of a simple statement or a complex combination of statements composed of logical statements, rules, and sets.
The following table contains examples of user-defined substitutions:
Prerequisite statement |
Substitution |
If the cost center is 10, |
use the value 01 for the plant and the value 30 for the business area. |
If the account is 100000 and the business area is 20, |
use the value 100 for the cost center and the value 012 for the deadline. |
If the account is in set ACCT-23 and the cost center is in set CENTER-56, |
use the value "blank" for the product key. |
Substitution enables you to update the data transferred into the application component FI-SL in greater detail.
Suppose you create a substitution that replaces (adds) the value 10 in the dimension plant whenever the account entered is within the range 100000 to 200000 and the cost center is 200. When the entry values are posted in FI-SL, the system uses the value 10 for the dimension plant if the account entered is within the range 100000 to 200000 and the cost center is 200.
The following graphic illustrates how FI-SL substitution interacts with the values entered into the SAP R/3 System.
For each validation step:
Substitutions are part of the Integration Manager along with validation, ledger selection rules, and summation rules.
If the prerequisite statement is true, the substitution is performed. If the prerequisite statement is not true, no substitution takes place.
If you want to use data from other SAP applications as substitution values in the application component FI-SL, the dimension to be substituted must be defined for the Boolean class for which the data is to be substituted.
For more information on creating substitution statements, see
Creating Boolean Statements for the FI-SL System.For more information on creating substitutions, see
Creating a Substitution.Matrix Substitutions
You can also create matrix substitutions. Matrix substitutions allow you to execute a substitution for the complete document, including the document header and all document lines.
You can only use matrix substitutions together with callup point code 0003 within the Financial Accounting (FI) application area.