TRM: Joining several identical flows within a period into one flow

[grigoriy_babitskiy]

Let’s take a look at Nominal interests flow. When you use other capital changes possibilities, for example, credit repayment (flow 1110 “Decrease”), Nominal interest flow is doubled.



When an interest rate of a credit changes, Nominal interest flow also doubles.

This is how it looks

And from accounting standpoint it means that we need to clear both open items for each Nominal interest flow with one position in bank statement.

So recently I’ve got a requirement from accounting department. They need only one accounting document for Nominal interests flows per reporting period.

So let’s start.

1. SPRO → Financial Supply Chain Management → Treasury and Risk Management → Transaction Manager → Money Market → Transaction Management → Flow Types → Define Flow Types:

Let’s define flow 1299 “Nominal interest (total)” with all parameters depicted on the screenshot. Critical is parameter “Relevant to posting ” - set it.

For standard flow 1200 “Nominal interest” clear “Relevant to posting”

2. SPRO → Financial Supply Chain Management → Treasury and Risk Management → Transaction Manager → Money Market → Transaction Management → Flow Types → Assign Flow Types to Transaction Types

Assign flow types to product type and transaction types.

3. SPRO → Financial Supply Chain Management → Treasury and Risk Management → Transaction Manager → Money Market → Transaction Management → Flow Types → Derived Flows → Define Derivation Procedures and Rules

Let’s define “KREDI” derivation procedure. And then go to “Derivation Rule”.

Let’s create a rule. Original flow is inflow of 1200 “Nominal interest”. Derived flow will be inflow of 1299 “Nominal interest (total). Choose “Sum of incoming flows” in “Calculation by” and 100 in “Percentage rate” - all our 1200 flows will be 100% summed up into 1299 flow. The rest of parameters is up to your need.

Repeat the same for outflow direction.

The result will look like this.

4. SPRO → Financial Supply Chain Management → Treasury and Risk Management → Transaction Manager → Money Market → Transaction Management → Update Types → Define Update Types and Assign Usage

Create update Types for our flow 1299.

And assign usage.

5. SPRO → Financial Supply Chain Management → Treasury and Risk Management → Transaction Manager → Money Market → Transaction Management → Update Types → Assign Flow Types to Update Types

Don't forget to enter update types into a view: tr. SM30 => TRACV_DFT_REL. And then set it as relevant for posting.

Assign Flow Types to Update Types

6. SPRO → Financial Supply Chain Management → Treasury and Risk Management → Transaction Manager → General Settings → Accounting → Link to Other Accounting Components

Adjust posting schemes to new Update Types.

7. SAP Menu → Accounting → Financial Supply Chain Management → Treasury and Risk Management → Business Partners → Special Functions → Standing Instructions → Derived Flows (tr. TBI7)

Assign derivation procedure to business partner to product type credit, transaction type - borrowing.

 

Results:

Create a new deal or resave the active deal.

As the result we have several 1200 flows which is not relevant to postings.

And only one flow 1299 with amount of all percents per period relevant to posting.

The task is done. Accounting department is happy.

 

[Gustavo_Vazquez]

Nice solution !!!!

This is a typical situation when you change conditions of transaction.

Kind Regards

[grigoriy_babitskiy]

Thank you, Gustavo.

[former_member198450]

 

Out of box solution. Thanks for sharing!

[former_member236523]

Excellent blog, nice narration even for the beginners like me

[former_member236523]

One quick question, i have tried all the steps, however while posting using TBB1, the new flow 1299 is not being picked up, when i check the status of the flow its " fixed( not relevant for posting)" however at the flow level i have marked it as "Relevant for posting", what did miss, please suggest.

[grigoriy_babitskiy]

Thank you!

[grigoriy_babitskiy]

Also check this view: tr. SM30 => TRACV_DFT_REL for update type for you flow type 1299. If absent - then enter it and set as relevant for posting.

[grigoriy_babitskiy]

Thank you, Jain!

[former_member236523]

Hi Grigoriy,

You are spot on it worked, actually you explained this in the blog, i missed it.

Thanks,

kranthi.

[grigoriy_babitskiy]

oh no, you asked your question and then i realized i need to add it to the article. So thank you for your question!

[former_member621594]

Hi can any one explain what does the line in a SAP Book means - A flow type does not have to be  assigned to a condition type    if     no cash flows     that are to be calculated,    are mapped using the flow type.        can anyone explain it with a very small example.           Is it possible to have a cash flow but we do not have any flow type linked to it or for it.

[former_member732658]

But, I think this should be in standard SAP, why should someone use derived flows to club the identical flows as it's a common business scenario, where multiple entries are not required for the same flow due on the particular date. Any idea if anyone like to share.

[cbonfrisco]

Hi Gregory:

Nice post! but i am facing the following issue

If flow type 1200 flag "Relevant for posting" is not selected, than TBB1 do not fix them and remains on status "0- Flow not relevant for posting" when the tbb1 is carried out.

Later as flow type1299 depends on it, it shows "Previous post does not permit posting" and its post is also not carried out by TBB1.

Show you some imgaes, in my example 1200=1277 and 1299=1297.

Only if I put flow 1200 as "Relevant for posting" and MM1200- deselected as update type relevant for posting it works...

thanks in advance

CB

 

[adho77]

Is this possible for a Interest Rate Swap? the thing there is that are two 1200 flows but in different direcctions (+ , -), i have done what you explained here but SAP is doing the sum of both flow without having the direcction into consideration. 

Regards,