Skip to Content

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.



To report this post you need to login first.

56 Comments

You must be Logged on to comment or reply to a post.

  1. yuvaraj v

    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 🙂

    (0) 
  2. 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

    (0) 
  3. 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

    (0) 
    1. Sowmya Tiwary 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

      (0) 
      1. 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

        (0) 
  4. 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)

    (0) 
  5. 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

    (0) 
  6. atul kumbhani

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

    Regards,

    -Atul 🙂

    (0) 
  7. Kranthi Manchu

    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.

    (0) 
  8. nas riz

    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

    (0) 
  9. laxman kolli

    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

    (0) 

Leave a Reply