Skip to Content
Author's profile photo Former Member

FI-SD Integration III

This series of documents for FI-SD integration is divided into 4 parts. This document is the last part of the series. Adding links for other parts before I start with the content.

Even though the document title says FI-SD Integration – III, it is the fourth part because part I was the pre-requisites required for the integration.

Part-I : Pre-requisites for FI-SD Integration

Part-II : FI-SD Integration – I

Part-III : FI-SD Integration – II

Assign G/L Accounts



The last step is assigning G/L accounts. This is done in t-code VKOA or the menu path SPRO -> IMG -> Sales and Distribution -> Basic Functions -> Account Assignment/Costing -> Revenue Account Determination -> Assign G/L Accounts



Only those tables will be displayed in VKOA which are linked to access sequences for which the account determination types are already assigned to account determination procedures. To make assignment of G/L accounts, double click on the required condition table entry. For illustration purposes, the condition table 1 has been chosen.


New rows can be added to the table using the New entries button. As seen from the screen shot above, G/L accounts assignment in this table is based on

  • Application
  • Condition type
  • Chart of accounts
  • Sales Organization
  • Customer account assignment group
  • Material account assignment group
  • Account Key


The provision account column is used in case the account key is an accrual key as explained in section 3.3. The G/L account column for such an account key has the P&L account and the provision account column is filled with the Balance Sheet account number


For instance, for application = v, condition type = KOFI, chart of accounts = A999, sales org = MMMM, customer group = D1, material group = J1, if the account key is ERL, the posting is done to G/L account 51010201 and for account key ERS, the posting is done to G/L account 51010101. Thus, we differentiate the G/L account based on the transaction type through the account key. Similarly, for application = v, condition type = KOFI, chart of accounts = A999, sales org = MMMM, customer group = D1, account key = ERL, if the material group is J1, the posting is done to G/L account 51010201 and for material group J2, the posting is done to G/L account 51010101. Thus, we differentiate the G/L account based on the material group of the material.


Similarly, the G/L accounts are assigned to all the condition tables. For instance, if we would have chosen table 2 instead on 1 for assignment of G/L accounts, the screen would have been as shown below.


As seen, the difference between tables 1 and 2 is that in condition table 2, there is no material account assignment group criterion for determination of G/L account. So, for instance, if an access sequence lists the table 1 as the first one to be checked and table 2 as the second one, and the material group is missing from the billing document, then the G/L account to be posted to would be traced from table 2.


From the condition table displayed for G/L account assignment, rows that satisfy particular criteria can be identified. Use Menu tab Selection -> By Contents


The fields that can be used for selection are displayed. Here, for instance, we choose account key and G/L account by clicking on these fields and press enter.


We want to display rows with Account key = ERS and G/L Account = 51010101. Enter the field values and select the choose button. The list is displayed as shown below. The number of entries selected will also be shown at the bottom of the page as highlighted.


This selection can also be used for easy assignment of G/L accounts. For example, for table 2, choose chart of accounts = CABE, sales org = XCSH and account key = ERL in the selection. When the list of entries is displayed, the same account number can be easily entered in the G/L account column.


Displaying Account Determination Analysis

The screen shot below shows an accounting document in FI. The t-code used is FB03 or follow the menu path SAP Easy Access Manu -> Accounting -> Financial Accounting -> General Ledger -> Document -> Display


As highlighted in the screen, the G/L account 800000 has been chosen for posting of the sales. The corresponding billing document can be seen using menu tab Environment -> Document Environment -> Original Document.


To see the account determination analysis, from the billing document screen, use the menu tab Environment -> Account Determination Analysis -> Revenue Accounts


As seen from the screen above, the G/L account entry was not found in condition table condition type/account key. The account 800000 was determined from the table Acct Key.



Assigned Tags

      59 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good resource for all...Many Thanks.

      Best Regards,

      Naresh K.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Naresh:)

      Author's profile photo Murali Babu Nallamothu
      Murali Babu Nallamothu

      Thank you sowmya for the useful document.

      Rgds

      MBN

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Murali 🙂

      Author's profile photo Mariks .
      Mariks .

      Useful document. Thanks for sharing the valuable knowledge...

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Mariks

      Author's profile photo Former Member
      Former Member

      Hi, Sowmya

      Thank you so much for sharing your knowledge.

      i had revised  my knowledge SD & FI Integration part  by going through this document.and it would really helpful  for the guys who start their carrier as SD Consultant, u had clearly given what are all the areas SD has  integration with FI,

      Thanks

      Yuvaraj 🙂

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks a lot Yuvaraj 🙂

      Author's profile photo Former Member
      Former Member

      Thanks a lot.. 🙂 nicely documented.

      Rahul.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Rahul 🙂

      Author's profile photo Former Member
      Former Member

      Very nicely documented.

      Nirav

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Nirav

      Author's profile photo Former Member
      Former Member

      Nicely explained.

      Hope we could see more from you.

      Thanks for taking time to share your knowledge.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Suresh 🙂

      Author's profile photo Former Member
      Former Member

      Very helping document...!!

      Author's profile photo Piratla Siva Surya Karthikeya
      Piratla Siva Surya Karthikeya

      Hi Sowmya,

      Good Evening !!!

      Could you kindly assist me in finding a configuration document or pre-requisites to carry out FI-MM integration.

      I have searched to the possible extent, but could only find few which were incomplete. It would be a great help for us to understand the configuration and mapping of FI-MM parameters for P2P cycle.

      Many Thanks : Karthikeya

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Kathikeya

      I would definitely do that at the earliest as soon as I get some time 🙂

      Regards

      Sowmya

      Author's profile photo Piratla Siva Surya Karthikeya
      Piratla Siva Surya Karthikeya

      Hi Sowmya,

      So kind of your assurance and also my humble regards for the time and support. Mean-while i am actually working(practice) on few documents, which's sort of patching process, ideally i try to go through and do another cycle and try posting the MM if it's successfully done.

      Generally as a sr consultant could you kindly advice/assist or insist, what's the set of example like i/we as a fresher/professional should take to follow the steps like copying the existing settings mostly, so that will help initially to understand how the flow is happening.

      Regards : Karthikeya

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Karthikeya

      I would definetely do that. But this space is for comments and so I would like to publish this as a document.So, please have patience 🙂 . If this is urgent, you can always start a discussion thread and people will answer you.

      Regards

      Sowmya

      Author's profile photo Piratla Siva Surya Karthikeya
      Piratla Siva Surya Karthikeya

      Sure, will do. 🙂  

      Thank you : Karthikeya

      Author's profile photo Lakshmi Sama
      Lakshmi Sama

      Hi Deepthi,

      Good one asusual and nicely explained also.

      Expecting more from your end in future.

      Thanks & Regards,

      Lakshmi S

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Lakshmi 🙂

      Author's profile photo Phanikumar Valiveti
      Phanikumar Valiveti

      Very nice documentation--in normal All FI guys are having some fear by looking into Condition technique concept which will be used most frequently in SD & MM.

      Very nice explanation with screen shots.

      By the way are you an FI consultant or SD consultant???

      Phanikumar

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Phanikumar. I am an FI consultant 🙂

      Author's profile photo Singaiah Pathuri
      Singaiah Pathuri

      Hi Sowmyadeepthi,

      Documentation of FI-SD integration is Very nice n very helpful to consultants n expecting more contribution.

      Regards,

      Singaiah Pathuri(singh)

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you 🙂

      Author's profile photo Hansraj Bansal
      Hansraj Bansal

      Excellent

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Hansraj

      Author's profile photo Ramagiri Srinivas Rao
      Ramagiri Srinivas Rao

      Good document. Thanks for sharing.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank u 🙂

      Author's profile photo narin kamuni
      narin kamuni

      I have read all the series of documents from pre-requisites to the final account assignment, very well explained. Thanks for all your efforts.

      Keep posting... 🙂

      Thanks and regards,

      Narin Kamuni

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Narin 🙂 You can like or rate the documents as well 🙂

      Author's profile photo Viswanatha Reddy
      Viswanatha Reddy

      Informative document...... 🙂 🙂

      Regardds,

      Viswa.S

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you 🙂

      Author's profile photo Sanil Bhandari
      Sanil Bhandari

      Very informative

      Regards

      Sanil

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Sanil

      Author's profile photo Muthukumareshan vijayan
      Muthukumareshan vijayan

      Good resource for all...Many Thanks 🙂

      Muthu

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks 🙂

      Author's profile photo Former Member
      Former Member

      Impressive work. Keep posting such a detailed documents. Sharing your knowledge will only make you brighter and smarter.

      Regards,

      -Atul 🙂

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Atul 🙂

      Author's profile photo Former Member
      Former Member

      Thanks for the document. Could you also write where SD and FI integrate in a sales order.

      Regards

      Varun

      Author's profile photo Former Member
      Former Member

      Sowmya,

      Excellent work!

      Thanks

      Raj Vellore

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Raj Vellore

      Author's profile photo Bose GN
      Bose GN

      Excellent...!! 🙂 explained in detail

      Thank you so much Sowmya, for your valuable knowledge sharing

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Bose for the valuable comments 🙂

      Author's profile photo Former Member
      Former Member

      Great article.

      I always had one doubt regarding the FI-SD integration. Excuse me if its a stupid question.

      I understood the process of how the revenue/freight/discount accounts gets determined. But how does SAP know which posting key should be used for the line items & if it should be a debit or credit.

      Author's profile photo Former Member
      Former Member

      Hi Sowmya,

      Gud effort keep doing like this thanks to share your knowledge.

      Thanks,

      Lakshmi

      Author's profile photo Former Member
      Former Member

      Hi Sowmya, ,

      Great effort and very nice and detail documents. Nice work wish you all the best.

      Please share as much knowledge as you can.

      Thanks,

      Nas

      Author's profile photo Former Member
      Former Member

      Thanks a lot.. 🙂 for sharing a wonderful  documented....

      Author's profile photo Vivek Maniyamma Gopalan
      Vivek Maniyamma Gopalan

      Hi

      Thanks for the effort

      Author's profile photo Former Member
      Former Member

      hi sowmya,

      this is really good doucument for begginers& i am expecting fi-mm integration process doucument like this.

      thanks for your best effort, providing this doucument

      Author's profile photo Sagar Reddy Kunta
      Sagar Reddy Kunta

      Simply super.

      Author's profile photo Former Member
      Former Member

      very detailed and amazing article, Sowmya!!

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Sanjeev

      Author's profile photo Former Member
      Former Member

      Excellent document; thanks and congratulations .

      Author's profile photo Former Member
      Former Member

      Very helpful and easy to understand..!!

      Author's profile photo Kamlesh Kumar Arya
      Kamlesh Kumar Arya

      Very easy to understand!

      Thanks for sharing.

      Author's profile photo P VENKAT
      P VENKAT

      Very easy to understand

       

      Author's profile photo Shagun Jain
      Shagun Jain

      Thanks for sharing your great knowledge.

       

      Shagun