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
- 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.
Good resource for all...Many Thanks.
Thank you Naresh:)
Thank you sowmya for the useful document.
Thank you Murali 🙂
Useful document. Thanks for sharing the valuable knowledge...
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 a lot Yuvaraj 🙂
Thanks a lot.. 🙂 nicely documented.
Thank you Rahul 🙂
Very nicely documented.
Hope we could see more from you.
Thanks for taking time to share your knowledge.
Thanks Suresh 🙂
Very helping document...!!
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
I would definitely do that at the earliest as soon as I get some time 🙂
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
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.
Sure, will do. 🙂
Thank you : Karthikeya
Good one asusual and nicely explained also.
Expecting more from your end in future.
Thanks & Regards,
Thanks Lakshmi 🙂
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???
Thanks Phanikumar. I am an FI consultant 🙂
Documentation of FI-SD integration is Very nice n very helpful to consultants n expecting more contribution.
Thank you 🙂
Good document. Thanks for sharing.
Thank u 🙂
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,
Thanks Narin 🙂 You can like or rate the documents as well 🙂
Informative document...... 🙂 🙂
Thank you 🙂
Thank you Sanil
Good resource for all...Many Thanks 🙂
Impressive work. Keep posting such a detailed documents. Sharing your knowledge will only make you brighter and smarter.
Thanks Atul 🙂
Thanks for the document. Could you also write where SD and FI integrate in a sales order.
Thank you Raj Vellore
Excellent...!! 🙂 explained in detail
Thank you so much Sowmya, for your valuable knowledge sharing
Thank you Bose for the valuable comments 🙂
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.
Gud effort keep doing like this thanks to share your knowledge.
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 a lot.. 🙂 for sharing a wonderful documented....
Thanks for the effort
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
very detailed and amazing article, Sowmya!!
Excellent document; thanks and congratulations .
Very helpful and easy to understand..!!
Very easy to understand!
Thanks for sharing.
Very easy to understand
Thanks for sharing your great knowledge.