/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)

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

      1. 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

        (0) 

Leave a Reply