Skip to Content
Product Information
Author's profile photo CA Zunaid Hingora

FI – SD Integration – VKOA – Understanding Flow – SAP ECC

FI-SD Integration

FI-SD integration is very important topic for FICO consultants. This is the one of most asked interview question and lack of knowledge/concept could result in rejection.  This concept could be understood in totality to avoid any confusion. FI-SD integration knowledge for FICO consultant is must in Implementation/Support/Roll Out projects.

For videos of all my blogs, please click on below link.

https://www.youtube.com/channel/UCx5F7mhmIYye8ETY3cM5zQQ

Disclaimer

  • This is a simple document for FI SD integration.
  • This document is for Finance consultants to understand the FI-SD concept at Macro Level.
  • This document will help you to understand basics of FI SD integration and not the complete process.
  • This document is created based on the knowledge I have. There might be much more than what is covered in this document.
  • This document is different from other documents available on portal as other document focuses on SD concepts, Accounting entries, while this document focus on ‘Simplified approach’ to help understand FI-SD concept.
  • Please share your inputs in Comment section, if you feel anything is missed out or to be added.
  • This document is created with the purpose to share the knowledge and help the community.

Scope

  • Purpose
  • VKOA – Assign GL Accounts
  • Cust Account Assignment Group (AAGC – Column 5)
  • AcctAssmtGrpmat (AAGM – Column 6)
  • Account Key
  • Pointers
  • Journal Entries
  • Exercise
  • Conclusion

Purpose

Purpose of this document is mentioned below:

  • Not to understand SD concept, but to understand what is exactly required to understand by Finance team from SD Module.
  • This will help to understand the SD concepts as well.
  • I have adopted reverse engineering process rather than understanding through SD.
  • We will proceed through VKOA to SD to understand this concept, instead of directly understanding the SD concept.

VKOA – Assign GL Accounts.

VKOA is the transaction code for FI-SD integration. If you access this tcode, below screen will appear. This is FI-SD integration point. There are 5 table for this integration. At first look, finance consultant will be nervous and lost. If you understand first table, rest are repetitive. Double click on Table 001.

Below screen will appear. In total there are 9 columns out of which first 4 are simple to understand.

  1. Application – Its should be V. V is sales and distribution. Very straight forward. For more option, press F4 and check.
  2. Condition Type – This isn’t an SD condition type. This is condition type for Usage and Application. Don’t get confused this with SD condition type. Only 2 options will come as below. There might be more and I am not aware.
  • KOFI – Accnt Determination
  • KOFK – Acct Determ.with CO
  1. Chart of Account – This is Chart of account. Very simple to understand.
  2. Sales organisation – This is nothing but our company code.

So, first 4 items are clear an pretty simple.

Next 3 columns are important. 5th 6th and 7th. This are SD values. Let’s see where its coming from Billing document. If you relate this with Billing document, it will be easy to understand the concept.

Cust Account Assignment Group (AAGC – Column 5).

Column AAGC. Cust Account assignment group. Where does it comes from billing document? See below screenshot.

Go to VF03. Give the billing document and press enter. Click on header data. If you see there are 5 tabs. It means its header.  Entry is highlighted. This goes to column 5. Here Text is given and in VKOA numbers are given

AcctAssmtGrpmat (AAGM – Column 6)

Column 6 AcctAssmtGrpmat comes from below highlighted field. This comes from Line item. Here Text is given and in VKOA numbers are given.

Account Key (Actky Column 7)

Account key is the 7th column. Where is it coming from? In Condition tab below, Click on analysis button.

Below screen will appear. Condition type is highlighted in yellow.

Go to V/08. Select above pricing procedure and click on control.

Below entries will be displayed. If you see column Acc., there are entries for ERL. This will come in column 7.

In column 8 and 9 there are gl accounts. This gl accounts are provided by Finance team.

For column 8, gl is picked up and documents are posted. But for 9 its accrual and I am not aware of that.

Pointers

Journal Entries

How Journal entries are posted for SD flow? There are 2 types of Journal entries in SD flow.

  • Cost of good sold Entries
  • Sales order flow entry (This is already explained in above section).

Cost of good sold entries GL Determination.

Cost of good sold entries is as below :

– Cost of good sold account debit

-Inventory/Finished goods account Credit.

Now the question is from where does this GL and Its amount is picked from? It is very important to understand this flow.

GL for Cost of good sold is picked up from OBYC. This is from FI-MM integration. Key is BSX. From here inventory GL account is picked up.

GL for COGS is picked up from GBB Transaction key as shown below. General Modifier will be VAX

COGS Amount determination

Standard Price of Material is used to calculate the Amount.  Unit/Quantity will be multiplied by Standard Price and Amount is arrived.  From where does this Standard Price is derived? See below screenshot.

Note: I am not sure if there is another price which is considered for COGS. If you have any information, do share in comment section below.

Exercise

  • Identify few Billing documents with Accounting document posted
  • Begin the search from Billing document to VKOA.
  • Try few documents and your Basic FI-SD integration concept will be Clear.
  • Other table in VKOA are similar or with lesser value option.

Conclusion

Once you go through this blog, you will be able to understand the VKOA entries, SD flow and Finance flow. Post this, you will be able to drill down to accounting entries posted through this integration.

I hope you liked the document, and this is helpful to you.

Regards

CA Zunaid Hingora

Other Blogs

LTMC Process LTMC Process SAP S/4HANA – Simple Steps | SAP Blogs
Why choosing SAP Profile as a career could be best decision for anyone? https://blogs.sap.com/2021/08/18/why-choosing-sap-profile-as-a-career-could-be-best-decision-for-anyone/
Fiori App List /blogs.sap.com/2021/11/25/fiori-app-list-s-4hana/
FI – SD Integration – VKOA – Understanding Flow – SAP ECC https://blogs.sap.com/2020/11/12/fi-sd-integration-understanding-concept-sap-ecc/
IDOC Management – Mass Change – WLF_IDOC, Foreground Processing and other IDOC Activities. https://blogs.sap.com/2020/08/04/idoc-mass-change-mass-processing-wlf_idoc/
SAP ‘ Z Process Re-Engineering’ – Enhance the productivity of the implemented solution https://blogs.sap.com/2020/08/03/enhance-the-productivity-of-the-implemented-solution-sap-process-re-engineering./
S/4 Hana – House Bank, Bank Account and Account ID Overview https://blogs.sap.com/2019/10/18/s4-hana-house-bank-bank-account-and-account-id-overview./
AUC Automatic Creation from WBS – S/4 HANA https://blogs.sap.com/2019/09/27/auc-automatic-creation-from-wbs-s4-hana/
S/4HANA Finance – New vs Old transaction code https://blogs.sap.com/2019/09/23/sap-hana-new-vs-old-transaction-code./
Profit Center – Assignment/Removal of Company code and Activation https://blogs.sap.com/2019/07/17/profit-center-assignmentremoval-of-company-code-and-activation/
AS91 – Asset Master Upload https://blogs.sap.com/2019/03/25/as91-asset-master-upload./
Asset Reconciliation Account Posting ABF1L- No OAMK, OASV https://blogs.sap.com/2019/03/13/asset-reconciliation-account-posting/
Mass Upload Functionality – SAP https://blogs.sap.com/2019/03/12/mass-upload-functionality-sap/
Data Migration Learning https://blogs.sap.com/2021/12/29/data-migration-learnings/
SAP Interface Development Process – Detailed Guide https://blogs.sap.com/2022/01/13/sap-interface-development/
Fiori Apps Learning https://blogs.sap.com/2022/02/22/fiori-apps-learning/
Screen Recordings Screen Recordings, Video Export, GIF, Save as Show using PowerPoint Presentation – SAP Business Scenarios, Training Documents, End user Videos etc. | SAP Blogs
SAP S/4HANA Finance – New Additions, Features and Functionality https://blogs.sap.com/2019/03/26/sap-s4-hana-features/
Automatic Idoc Generation while Creating Purchase Order, Nace Config – Material Management Automatic Idoc Generation while Creating Purchase Order, Nace Config – Material Management | SAP Blogs
Transport of Copies – SAP Transport of Copies – SAP | SAP Blogs
Fiori vs LTMC vs ACDOCA – Benefits, Value addition Comparision Fiori vs LTMC vs ACDOCA – Benefits, Value addition Comparision | SAP Blogs
Terms of Payment for Installment – SAP Finance Terms of Payment for Installment – SAP Finance | SAP Blogs
SAP Project Knowledge Transfer Guide/Checklist (KT) SAP Project Knowledge Transfer Guide/Checklist (KT) | SAP Blogs
Vendor Ageing Report Vendor Ageing Report – S_ALR_87012085 SAP FICO
SAP Important Tcodes SAP Important Tcodes – FICO MM SD PM BODS
LSMW Recording for Transaction Data – FB01 LSMW Recording for Transaction Data – FB01
SAP FICO Data Migration – Global Execution, Planning and Approach SAP FICO Data Migration – Global Execution, Planning and Approach

Assigned Tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Matthieu Fontayne
      Matthieu Fontayne

      Very nice blog Zunaid, thank you for these explanations.

      Author's profile photo CA Zunaid Hingora
      CA Zunaid Hingora
      Blog Post Author

      Welcome. My Pleasure.

      Author's profile photo Saufilbadli Ya'cob
      Saufilbadli Ya'cob

      Thanks for sharing, this is good knowledge for me.

      Author's profile photo CA Zunaid Hingora
      CA Zunaid Hingora
      Blog Post Author

      My pleasure.

      Author's profile photo Marcos França
      Marcos França

      Really nice blog and well explained! thanks for sharing!

      Author's profile photo CA Zunaid Hingora
      CA Zunaid Hingora
      Blog Post Author

      Thank you so much.

      Author's profile photo Jagadishwar kattaji
      Jagadishwar kattaji

      Good explanation & thanks for sharing knowledge....

      Author's profile photo CA Zunaid Hingora
      CA Zunaid Hingora
      Blog Post Author

      Thank you.