Main menu

ERPCorp SAP FICO Blog

Fundamentals of MM-FI Account Determination

AshishSeveral colleagues have asked questions about integration between Materials Management (MM) and Financial Accounting (FI) module:

- How do postings from MM flow into FI?

- How do we find out what occurs behind-the-scenes?

- How do we identify which movement types are pointing to a specific GL Account?

- Is there a way by which we can change the posting to a different General Ledger (GL) Account?

- How does one create a new movement type and assign it to a specific GL Account?

Many SAP practitioners – IT and business alike – are in similar situation and do not know where to start on MM-FI data flow and reconciliation. This blog is an attempt to clarify the fundamentals of MM-FI account determination.

Configuration transaction OBYC forms the core of SAP’s integration between the MM, FI, and Controlling (CO) modules in a traditional SAP ERP system

Transaction keys (1)  are used to determine general ledger accounts used by the system. Account modifier is used to differentiate account determinations, depending on the procedure. [Transaction and account modifiers can be seen as a logical grouping similar types of transactions]. The transaction-account modifier, along with the valuation class, drives the accounting entries. Transaction keys are predefined in the SAP system and cannot be changed.

AshishBlog1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 



Figure 1: OBYC setup for BSX – Inventory posting

Many of you may have seen an accounting entry at the time of the purchase of raw material as a debit to inventory and credit GR/IR. The configuration setup of transaction BSX (inventory posting) is responsible for the inventory posting (see Figure 1), and WRX (GR/IR clearing account) is responsible for GR/IR posting. When movement type 101 is used to record the goods receipt of raw material (valuation class 3000) for a purchase order, the system looks up the GL Account for transaction BSX and WRX for valuation class 3000 and records it in the accounting document.

AshishBlog2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure 2: OBYC setup for GBB-VBR – Consumption to Order

Similarly, when raw material is consumed using movement type 261, the system looks up transaction GBB (offsetting entry for inventory posting) for account modifier VBR (consumption for internal goods issues), and that reflects the GL Account in the accounting document (see Figure 2)

Figure 3 provides a summary of few important movement types and accounting entries. Business process is listed in the column furthest to the left, with movement type in the next column, and the debit and credit posting in the subsequent columns.

There is a column for transaction and account modifiers; as we noted earlier, these are SAP’s terms for logically grouping similar types of transactions. The transaction account modifier, along with the valuation class, drives the accounting entries.

The OBYC MM-FI account determination configuration is set up at the time of original implementation, and once set up, these accounts are derived behind the scenes. You’ll want to test the setup before going live to ensure that the correct accounts are being hit for the respective transactions. You can change this configuration after go-live, but the revised setup needs to be thoroughly tested. Otherwise, we may run the risk of impacting regular operations.

AshishBlog3
Figure 3: Summary of select movement types and accounting entries

Key take-aways:

  • Transaction-account modifier and valuation class drive the accounting entries
  • Transaction key: determines general ledger accounts for posting
  • Account modifier: differentiates account determination based on procedure
  • OBYC MM-FI Account determination setup is stored in underlying table T030
  • OMJJ Movement Type setup is stored in underlying table T156X
  • Combine these two tables (via SQ00 query, or simply on Excel)
  • The account modifier links the Movement Type to the Accounting entries

I hope this write-up was useful and explained the fundamentals to the readers.

(1) - The transaction key in MM-FI account determination is not the same as transaction code. A transaction code is an alphanumeric code that represents a particular task in SAP. It allows users to access tasks directly without having to use menu paths.

Copyright acknowledgement: This blog was created based on information that was originally published by Espresso Tutorials GmbH as one of many tips in Expert tips to Unleash the Full Potential of SAP Controlling, authored by Ashish Sampat

About the Author
Ashish Sampat is an SAP FI/CO Consultant who has provided solutions in SAP Controlling including product costing, material ledger, and cost center accounting to global clients in consumer packed goods, life sciences, and industrial sectors.  Ashish is based in Chicago region, where he works as an independent SAP FI/CO consultant. Ashish is the author of First Steps in SAP Controlling (CO) and Expert tips to Unleash the Full Potential of SAP Controlling.

save 400 button
Fundamentals of MM-FI Account Determination
Activity Type Post Blog Series Final Recap
 

Comments 10

Guest - Mike P on Wednesday, 23 August 2017 02:01

Great article & simple to understand.

Great article & simple to understand.
Guest - Wolfgang on Sunday, 10 September 2017 12:47

Thanks for this nice overview of the MM account determination!
I am surprised to see in my project work, how often the FICO colleagues let the SD or MM guys take care for the account determination. Because IMHO even it can be found in the IMG in SD and MM etc. too, it's 100% the responsibility of the finance team. As a finance consultant, I have the strong "desire" to take care for this, this must be my baby :-)

Thanks for this nice overview of the MM account determination! I am surprised to see in my project work, how often the FICO colleagues let the SD or MM guys take care for the account determination. Because IMHO even it can be found in the IMG in SD and MM etc. too, it's 100% the responsibility of the finance team. As a finance consultant, I have the strong "desire" to take care for this, this must be my baby :-)
Guest - Lee Geok kim on Friday, 26 April 2019 00:18

Great article for new learner

Great article for new learner
Guest - Arun on Wednesday, 21 August 2019 07:47

Excellent

Excellent
Guest - Ganesh on Sunday, 17 November 2019 16:57

Thanks a lot for excellent article, it help us to recollect our memories

Thanks a lot for excellent article, it help us to recollect our memories ;)
Guest - cookie amber on Thursday, 19 December 2019 10:28

What a miracle to have my ex back  and i need to share this great testimony… I just want to say thanks Dr ojoka for taking time to help me cast the spell that {now my husband},who suddenly lost interest in me after six month of engagement,but today we are married and we are more happier than never before, I am really short of words and joyful, and i don’t know how much to my appreciation to you doctor ojoka you are a God sent to restore broken relationship.he deeply enjoy helping people achieve their desires, find true love,getting their ex lovers back,stop abusive relationships,find success,attract happiness,find soul mates and more,contact him today. and let him show you the wonders and amazement of his Love Spell System. He deliver results at his best in real spell casting,email him for help on dr.ojokaspelltemple@gmail. com  or whats app him on +2348144172934

What a miracle to have my ex back  and i need to share this great testimony… I just want to say thanks Dr ojoka for taking time to help me cast the spell that {now my husband},who suddenly lost interest in me after six month of engagement,but today we are married and we are more happier than never before, I am really short of words and joyful, and i don’t know how much to my appreciation to you doctor ojoka you are a God sent to restore broken relationship.he deeply enjoy helping people achieve their desires, find true love,getting their ex lovers back,stop abusive relationships,find success,attract happiness,find soul mates and more,contact him today. and let him show you the wonders and amazement of his Love Spell System. He deliver results at his best in real spell casting,email him for help on dr.ojokaspelltemple@gmail. com  or whats app him on +2348144172934
Guest - ERIC BRUNT on Sunday, 22 December 2019 20:20

i am ERIC BRUNT by name. Greetings to every one that is reading this testimony. I have been rejected by my wife after three(3) years of marriage just because another Man had a spell on her and she left me and the kid to suffer. one day when i was reading through the web, i saw a post on how this spell caster on this address AKHERETEMPLE@gmail.com have help a woman to get back her husband and i gave him a reply to his address and he told me that a man had a spell on my wife and he told me that he will help me and after 3 days that i will have my wife back. i believed him and today i am glad to let you all know that this spell caster have the power to bring lovers back. because i am now happy with my wife. Thanks for helping me Dr Akhere contact him on email: AKHERETEMPLE@gmail.com
or
call/whatsapp:+2349057261346
..

i am ERIC BRUNT by name. Greetings to every one that is reading this testimony. I have been rejected by my wife after three(3) years of marriage just because another Man had a spell on her and she left me and the kid to suffer. one day when i was reading through the web, i saw a post on how this spell caster on this address AKHERETEMPLE@gmail.com have help a woman to get back her husband and i gave him a reply to his address and he told me that a man had a spell on my wife and he told me that he will help me and after 3 days that i will have my wife back. i believed him and today i am glad to let you all know that this spell caster have the power to bring lovers back. because i am now happy with my wife. Thanks for helping me Dr Akhere contact him on email: AKHERETEMPLE@gmail.com or call/whatsapp:+2349057261346 ..
Guest - gary lesley on Saturday, 18 January 2020 07:36

Hi everybody. I recently saw a testimony about chief dr lucky in a blog I visit for relationship and dating counseling problems because i had been having serious issues with my boyfriend and we had been dating for six months, he just suddenly changed, he wasn't returning my calls,he started cheating,he was hurting me in many ways i never thought possible and I just thought I should try it*maybe out of desperation of some sort*..and I contacted chief dr lucky ..At first everything felt dreamy and unbelievable, his consultations and solution was a little bit easy and strange and I was scared a little cause I heard read and heard lots of stories to of fake spell casters,scams and i never really believed in magic..I played along with a little hope and and faith and I sent some few stuffs after everything and it worked like a miracle,everything went to a while new direction,it was and is amazing...I guess it was all good faith that made me read That particular post that faithful day..I hope he could help other people too like he did me...I did a little and I got everything I wanted and wished for*my husband,my family and my life back. E-mail: Cheifdrlucky@gmail.com or contact him on whats App him +2348132777335 Website :http://chiefdrluckysolutionhome.website2.me/  

Hi everybody. I recently saw a testimony about chief dr lucky in a blog I visit for relationship and dating counseling problems because i had been having serious issues with my boyfriend and we had been dating for six months, he just suddenly changed, he wasn't returning my calls,he started cheating,he was hurting me in many ways i never thought possible and I just thought I should try it*maybe out of desperation of some sort*..and I contacted chief dr lucky ..At first everything felt dreamy and unbelievable, his consultations and solution was a little bit easy and strange and I was scared a little cause I heard read and heard lots of stories to of fake spell casters,scams and i never really believed in magic..I played along with a little hope and and faith and I sent some few stuffs after everything and it worked like a miracle,everything went to a while new direction,it was and is amazing...I guess it was all good faith that made me read That particular post that faithful day..I hope he could help other people too like he did me...I did a little and I got everything I wanted and wished for*my husband,my family and my life back. E-mail: Cheifdrlucky@gmail.com or contact him on whats App him +2348132777335 Website :http://chiefdrluckysolutionhome.website2.me/  
Guest - Linda Mark on Monday, 20 January 2020 23:18

HOW I GOT MY LOAN FROM THIS GREAT COMPANY

Hello my dear people, I am Linda McDonald, currently living in Austin Texas, USA. I am a widow at the moment with three kids and i was stuck in a financial situation in April 2018 and i needed to refinance and pay my bills. I tried seeking loans from various loan firms both private and corporate but never with success, and most banks declined my credit ,do not full prey to those hoodlums at there that call them self-money lender they are all scam , all they want is your money and you well not hear from them again they have done it to me twice before I met Mr. David Wilson the most interesting part of it is that my loan was transfer to me within 74hours so I will advise you to contact Mr. David if you are interested in getting loan and you are sure you can pay him back on time you can contact him via email……… (davidwilsonloancompany4@gmail.com) No credit check, no cosigner with just 2% interest rate and better repayment plans and schedule if you must contact any firm with reference to securing a loan without collateral then contact Mr. David Wilson today for your loan

They offer all kind of categories of loan they

Short term loan (5_10years)
Long term loan (20_40)
Media term loan (10_20)
They offer loan like
Home loan............., Business loan........ Debt loan.......
Student loan.........., Business startup loan
Business loan......., Company loan.............. etc
Email..........( davidwilsonloancompany4@gmail.com)
When it comes to financial crisis and loan then David Wilson loan financial is the place to go please just tell him I Mrs. Linda McDonald direct you Good Luck.......................

HOW I GOT MY LOAN FROM THIS GREAT COMPANY Hello my dear people, I am Linda McDonald, currently living in Austin Texas, USA. I am a widow at the moment with three kids and i was stuck in a financial situation in April 2018 and i needed to refinance and pay my bills. I tried seeking loans from various loan firms both private and corporate but never with success, and most banks declined my credit ,do not full prey to those hoodlums at there that call them self-money lender they are all scam , all they want is your money and you well not hear from them again they have done it to me twice before I met Mr. David Wilson the most interesting part of it is that my loan was transfer to me within 74hours so I will advise you to contact Mr. David if you are interested in getting loan and you are sure you can pay him back on time you can contact him via email……… (davidwilsonloancompany4@gmail.com) No credit check, no cosigner with just 2% interest rate and better repayment plans and schedule if you must contact any firm with reference to securing a loan without collateral then contact Mr. David Wilson today for your loan They offer all kind of categories of loan they Short term loan (5_10years) Long term loan (20_40) Media term loan (10_20) They offer loan like Home loan............., Business loan........ Debt loan....... Student loan.........., Business startup loan Business loan......., Company loan.............. etc Email..........( davidwilsonloancompany4@gmail.com) When it comes to financial crisis and loan then David Wilson loan financial is the place to go please just tell him I Mrs. Linda McDonald direct you Good Luck.......................
Guest - gary lesley on Tuesday, 21 January 2020 10:11

Hi everybody. I recently saw a testimony about chief dr lucky in a blog I visit for relationship and dating counseling problems because i had been having serious issues with my boyfriend and we had been dating for six months, he just suddenly changed, he wasn't returning my calls,he started cheating,he was hurting me in many ways i never thought possible and I just thought I should try it*maybe out of desperation of some sort*..and I contacted chief dr lucky ..At first everything felt dreamy and unbelievable, his consultations and solution was a little bit easy and strange and I was scared a little cause I heard read and heard lots of stories to of fake spell casters,scams and i never really believed in magic..I played along with a little hope and and faith and I sent some few stuffs after everything and it worked like a miracle,everything went to a while new direction,it was and is amazing...I guess it was all good faith that made me read That particular post that faithful day..I hope he could help other people too like he did me...I did a little and I got everything I wanted and wished for*my husband,my family and my life back. E-mail: Cheifdrlucky@gmail.com or contact him on whats App him +2348132777335 Website :http://chiefdrluckysolutionhome.website2.me/  

Hi everybody. I recently saw a testimony about chief dr lucky in a blog I visit for relationship and dating counseling problems because i had been having serious issues with my boyfriend and we had been dating for six months, he just suddenly changed, he wasn't returning my calls,he started cheating,he was hurting me in many ways i never thought possible and I just thought I should try it*maybe out of desperation of some sort*..and I contacted chief dr lucky ..At first everything felt dreamy and unbelievable, his consultations and solution was a little bit easy and strange and I was scared a little cause I heard read and heard lots of stories to of fake spell casters,scams and i never really believed in magic..I played along with a little hope and and faith and I sent some few stuffs after everything and it worked like a miracle,everything went to a while new direction,it was and is amazing...I guess it was all good faith that made me read That particular post that faithful day..I hope he could help other people too like he did me...I did a little and I got everything I wanted and wished for*my husband,my family and my life back. E-mail: Cheifdrlucky@gmail.com or contact him on whats App him +2348132777335 Website :http://chiefdrluckysolutionhome.website2.me/  
Already Registered? Login Here
Guest
Thursday, 23 January 2020