TRM Derivation: Groupings
8 grouping characteristics are used to create 8 different groups. You assign values to these groups when defining derivation rules in order to determine account assignment references. In a second rule you then determine the account assignment references using this group.
Example: You want to organize the assignment of account assignment references using the Country characteristic. However, you do not want to assign one account assignment reference per country but rather to a certain group of countries, for example per continent. For example in this IMG activity you can determine the following groups for grouping characteristic 8:
- Southern America
- Nothern America
- Other continents
You can also use for example country classification: BRICS, CIVETS, MINT, PIGS, etc. (http://www.ocoglobal.com)
Another example: to group product types into contract types: Securities, Money Market, Loans, Derivatives, Foreign Exchange.
Or Security product types – into Security groups: Shares, Investment Fund Unit, Bonds, Shareholdings/Warrants
In Define Account Assignment Reference Determination, define a derivation rule in which you fill the target field, COMMON DATA / GROUPING_1 /1st grouping characteristic for determining account assignment references, using the source field, BUSINESS PARTNER / COUNTRY_OF_ORIGIN / Country of origin. In a second derivation rule, the target field, COMMON DATA / AA_REF / Account assignment reference is filled from the source field COMMON DATA / GROUPING_1 / 1st grouping characteristic for determining account assignment references.
Let’s create all derivation steps.
IMG -> Financial Supply Chain Management -> Treasury and Risk Management -> Transaction Manager -> General Settings -> Accounting -> Link to Other Accounting Components -> Define Groupings (tr. SM30 -> TRACV_GROUP)
IMG -> Financial Supply Chain Management -> Treasury and Risk Management -> Transaction Manager -> General Settings -> Accounting -> Link to Other Accounting Components -> Define Account Assignment Reference Determination (OTC Transactions) (tr. TPM32)
1 Derivation step. Coutry per Continent
Let’s create first derivation step – we assign country of Business partners to continents.
If you need you can maintain conditions and attributes.
Save derivation rule.
2 Derivation step. Account Assignment Reference per Countinent.
Create second derivation rule – we assign account assignement reference to continents.
Save the rule.
Pay attention to Step “Standard” – Derivation type: Move -> Tip paragraph.
As soon as all derivation steps are entered in the system – always Test your derivations Derivation: Test your derivation steps.
For other topics reffer to TRM Derivation (index)