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
Scope
Purpose
Purpose of this document is mentioned below:
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.
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 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
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
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.
- Application – Its should be V. V is sales and distribution. Very straight forward. For more option, press F4 and check.
- 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
- Chart of Account – This is Chart of account. Very simple to understand.
- 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
- SAP Managed Tags:
9 Comments
