Substitution Rules FICO

What are FI substitution rules ?
A: Defined in configuration they are similar to the FI
validation rules above. Substitution rules allow field values
to be replaced when certain pre-requisites conditions are
met.



Defining Substitution Rules


Use

When you post a document, you do not have to enter the functional area. The system can determined the functional area using substitution rules. If you post the salary of a market researcher, this expense will appear under sales costs in the profit and loss statement. The reason for this is the configuration of a substitution rule that reads the cost element category and derived the functional area for this information.
Two substitution rules are defined in the IDES System: ID-COGS (for Europe) and NA-COGS (for North America).
The deriving of the functional area can be dependent on various parameters such as cost element category, order type, or project number.
You can find additional information about substitutions in the Substitutions process.

Procedure

1. Call up the transaction as follows:

Menu Path	Tools ® AcceleratedSAP ® Customizing ® Edit Project
Transaction Code	SPRO

2. Choose  SAP Reference IMG.
3. Choose Financial Accounting ® Financial Accounting ® Company Code ® Cost of Sales Accounting ® Set Up Substitution for Cost of Sales Accounting ® Activate Substitution.
The following substitutions are displayed: ID-COGS is assigned to company code 1000 (Europe) and NA-COGS to company code 3000 (North America). Both substitutions are active. This means that every accounting document that results from a business transaction is automatically read. The substitution rule assigned to the company code is then used to derive the functional area.
4. In the Change View "Substitution in Accounting Documents": Overview screen, select the following substitution with a double-click.

Field	Europe	North America
Substitution	ID-COGS	NA-COGS

5. In the Information dialog box, choose .
The Change Substitution: ID-COGS or NA-COGS (Header data) screen appears. You see information about the application area of the substitution (FI) and the callup point when the substitution is executed (cost of sales accounting).
6. Open the ID-COGS structure.
The system displays the steps of the substitution. Currently, the steps 01, 02, 03 and 04 are completely configured for substitution rule ID-COGS. Other steps are included for reserves and clearing accounts.
7. Select the first substitution step (001).
The system displays an overview of the substitution prerequisites. If you post a document, the system checks whether the prerequisites of the first step are met. If they are met, the functional area is derived. If the prerequisite is not met, the system reads the next substitution step.
8. Call up the following steps in order.
The substitution prerequisites for the European data of the IDES system appear as follows:

Step	Description	Prerequisite (Boolean statement)
001	Functional area 0100 Manufacturing	Functional area 0100 is derived if the following is true: · Cost center element 1 (manufacturing) or 2 (manufacturing services), the order number is statistical or not specified · The internal order is a manufacturing order. · The document is posted to account 893000 (WIP) or 239000 (WIP unrealized costs) · The expense is posted directly to a cost element or customer order (profitability segment)
002	Functional area 0300 Sales and Marketing	Functional area 0300 is derived if the following is true: · Cost center category is 3 (Sales), the order number is statistical or not specified. · The internal order is an internal order for sales
003	Functional area 0400 Administration	Functional area 0400 is derived if the following is true: · Cost center element 4 (administration) or 5 (management), the order number is statistical or not specified · The internal order is an internal order for administration or management
004	Functional area 0500 Research & Development	Functional area 0500 is derived if the following is true: · Cost center category is 6 (research and development), the order number is statistical or not specified. · The internal order is an internal order for research and development
005	Functional area 0600 reserves (only for Germany)	Functional area 0600 is derived if the following is true: The document is posted to an account contained in the interval 480000 to 489999

The following is an overview of the substitutions as defined for the North American data in the IDES System.

Step	Description	Prerequisite (Boolean statement)
006	Functional area 0100: Manufacturing	The G/L account is either 893000 or 239000
007	Functional area 0100: Manufacturing	The manufacturing category is 04, 05, 06, 10, 20, 30, 40, or 50
008	Functional area 0100: Manufacturing	Order type is 0200, 0300, 0801, 0850, or 0870
009	Functional area 0100: Manufacturing	The cost center category is 01 or 02 and the order field is empty or contains a statistical order
010	Functional area 0100: Manufacturing	The cost element field contains an entry
011	Functional area 0100: Manufacturing	The customer order field contains an entry
003	Functional area 0300: Sales and Marketing	The order type is 0400 or 0451
005	Functional area 0300: Sales and Marketing	The cost center category is 03 and the order field is empty or contains a statistical order
002	Functional area 0400 Administration	The cost center category is 04 or 05 and the order field is empty or contains a statistical order
013	Functional area 0400 Administration	Order type is 9A00
001	Functional area 0500: Research & Development	The cost center category is 06 and the order field is empty or contains a statistical order
004	Functional area 0500: Research & Development	The order type is 0101 or 0151
012	Various functional areas are derived from WBS elements	This step uses user exit U901 in ABAP program ZGGBS800 to determine which functional area is derived from the WBS elements

9. Choose  until the overview tree appears.

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk