Skip to Content
Author's profile photo Grigoriy Babitskiy

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

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”

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

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

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

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

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

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

 

Assigned Tags

      13 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Gustavo Vazquez
      Gustavo Vazquez

      Nice solution !!!!

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

      Kind Regards

      Author's profile photo Grigoriy Babitskiy
      Grigoriy Babitskiy
      Blog Post Author

      Thank you, Gustavo.

      Author's profile photo Jain varghese
      Jain varghese

       

      Out of box solution. Thanks for sharing!

      Author's profile photo Grigoriy Babitskiy
      Grigoriy Babitskiy
      Blog Post Author

      Thank you, Jain!

      Author's profile photo Former Member
      Former Member

      Excellent blog, nice narration even for the beginners like me

      Author's profile photo Grigoriy Babitskiy
      Grigoriy Babitskiy
      Blog Post Author

      Thank you!

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Grigoriy Babitskiy
      Grigoriy Babitskiy
      Blog Post Author

      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.

      Author's profile photo Former Member
      Former Member

      Hi Grigoriy,

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

      Thanks,

      kranthi.

      Author's profile photo Grigoriy Babitskiy
      Grigoriy Babitskiy
      Blog Post Author

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

      Author's profile photo Claudio Bonfrisco
      Claudio Bonfrisco

      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

       

      Author's profile photo IBM AMS Team
      IBM AMS Team

      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.

      Author's profile photo ANIL KUMAR SAHU
      ANIL KUMAR SAHU

      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.