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:

• Europe
• Australia
• Southern America
• Asia
• 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.

Then maintain values by pressingbutton.

Save derivation rule.

2 Derivation step. Account Assignment Reference per Countinent.

Create second derivation rule – we assign account assignement reference to continents.

Then maintain values by pressingbutton.

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)