Skip to Content
Author's profile photo Grigoriy Babitskiy

TRM Derivation: Groupings

/wp-content/uploads/2014/10/7_582611.jpg

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)

0. gr.jpg

6. continents.jpg

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

1. derivation.jpg

Let’s create first derivation step – we assign country of Business partners to continents.

2. country per continent.jpg

If you need you can maintain conditions and attributes.

Then maintain values by pressing/wp-content/uploads/2014/10/8_582614.jpgbutton.

3. rules.jpg

Save derivation rule.

2 Derivation step. Account Assignment Reference per Countinent.

1. derivation.jpg

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

4. aaref.jpg

Then maintain values by pressing/wp-content/uploads/2014/10/8_582614.jpgbutton.

5. rules2.jpg

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)

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo ROHAN KAMAT
      ROHAN KAMAT

      Hi Friends,

      How are these groups linked to the GLs in Account Determination?

      I am not getting it.

      Regards,

      Rohan

      Author's profile photo Jain Varghese
      Jain Varghese

      Hi Rohan,

      We link AAR to product in derivation, same AAR we like to like to GL IN account determination.

      Regards,

      Jain

      Author's profile photo ROHAN KAMAT
      ROHAN KAMAT

      Hi Jain,

      I am aware of the link between Product >> AAR >> GL.

      But how to link the Groupings to GL? I saw it in one of my project and I am confused about its linkages.

      Regards,

      Rohan