Skip to Content
Author's profile photo Vinod Vemuru

SD-FI-COPA reconciliation: Part-1

Reader note:

Assumption is, reader is aware of basic integration concepts of different modules in SAP.

As different SAP modules are closely integrated, reconciliation is one of the most important and critical period end activity in Financial reporting.

Usually, reconciliation is done as part of the month end closure process.


In this blog, I would explain how to do SD-FI-COPA reconciliation and find without running through configurations.

SD-COPA and SD-FI are tightly integrated in SAP. As you all know, below is the integration of SD-FI-COPA.

SD is integrated to COPA via linking of SD pricing conditions to COPA value fields

FI/MM is integrated to COPA via PA transfer structure (Via linking of cost elements/cost element group to COPA value field)

SPRO path:

Capture.PNG

In an usual production scenario, amount/quantity fields updated in SD/FI/MM are immediately flown to COPA as well. Sometimes, users face the issues due to mismatch of the figures shown between SD-COPA and SD-FI. The reports used here might be standalone reports of respective module.

As the number of documents posted in a live production system is quite high and one value field might receive the data from multiple sources from SD/FI/MM, It is really tough to dig back to particular document which is causing the mismatch.

But, SAP folks are well thought of this critical activity at earlier stages of the design and t-code KEAT was delivered for this 🙂 .

I would like to share the little knowledge I have on this topic with our community.

Let us see how to find if there are any reconciliation differences exist and if exist, which documents are causing such difference.

Below is the selection screen of KEAT. Enter the maximum selection screen fields that are known to us and execute the report. Currency type 10 can be used which is company code currency.

Capture.PNG

Below is the sample output of the report

Capture.PNG

Output show the values recorded in SD, FI, PCA and COPA for each value field and respective delta values between the modules.

Capture.PNG

Even though SD-FI-COPA integration happens on real time basis, sometimes it is possible that minor differences arises due to various reasons.

One common reason is due to different currencies of company code and controlling area. Minor exchange rate/rounding differences occurs between

SD-FI-COPA. Some times, values in SD itself may not flow to FI/COPA.

Clicking on the delta value in red shows the list of documents which are causing this difference.

I don’t want to put too much information in one blog. Too much information at one go is not a good idea 😛

People lose concentration at certain threshold 😉


Here is part 2 😎

http://scn.sap.com/community/erp/financials/blog/2013/10/30/sd-fi-copa-reconciliation-part-2

Thanks for reading this blog and feed back.

Thanks,

Vinod Vemuru

Assigned Tags

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

      Nice  one....Good Job

      Author's profile photo Vinod Vemuru
      Vinod Vemuru
      Blog Post Author

      Thanks Shiva 🙂

      Author's profile photo CH Raman
      CH Raman

      Really useful one. Thanks for sharing Vinod.

      Author's profile photo Srinivas Salpala
      Srinivas Salpala

      Integration is always important...... Keep up the good work 🙂

      BR, Srinivas Salpala

      Author's profile photo Vinod Vemuru
      Vinod Vemuru
      Blog Post Author

      Thanks Rama, Srinivas 🙂

      Working on part 2 as well.

      Author's profile photo Diwa p
      Diwa p

      good vinod can you please  send me copa configuration document if you have.

      Regards

      Diwa

      Author's profile photo Vinod Vemuru
      Vinod Vemuru
      Blog Post Author

      Thanks Diwa.

      Don't have any document for COPA config. But, definitely I will share what ever little knowledge I have in COPA.

      Regards,

      Vinod,

      Author's profile photo Former Member
      Former Member

      Useful one...Thanks for the share.

      Best Regards,

      Naresh K.

      Author's profile photo Vinod Vemuru
      Vinod Vemuru
      Blog Post Author

      Thanks Naresh 🙂

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

      Thanks for Sharing....

      keep sharing...

      🙂

      Author's profile photo Vinod Vemuru
      Vinod Vemuru
      Blog Post Author

      Thanks Sudhir 🙂

      Many more documents on the way... 😉

      Author's profile photo Lakshmi Sama
      Lakshmi Sama

      Hello Vinod,

      Good job and it is really useful doc. Thanks for sharing this.

      Regards,

      Lakshmi S

      Author's profile photo Former Member
      Former Member

      Hi vinod...

      Nice post...

      Query : Please publish the post on reconciliation between Bank transactions and Payments made through f-53 and Fch5....

      Best wishes

      Author's profile photo Former Member
      Former Member

      Hi Vinod,

      Very nice document thanks for sharing.

      BR

      Aakash G

      Author's profile photo Vinod Vemuru
      Vinod Vemuru
      Blog Post Author

      Thanks Lakshmi, Thiyagarajan, Aakash 🙂

      I will try to work on bank recon as well.

      Thanks,

      Vinod.

      Author's profile photo Former Member
      Former Member

      Hi Vinod

      Thanks for sharing very nice information..

      Regards,

      Praveen

      Author's profile photo Vinod Vemuru
      Vinod Vemuru
      Blog Post Author

      Thanks Praveen 🙂

      Author's profile photo Narasimhulu Konnipati
      Narasimhulu Konnipati

      Very Nice presentation Vinod.

      Appreciate your effort and thanks for sharing.

      Keep up the good work

      Thanks,

      NSK

      Author's profile photo Vinod Vemuru
      Vinod Vemuru
      Blog Post Author

      Thanks a lot Narasimhulu 🙂

      Author's profile photo Sampat Kumkar
      Sampat Kumkar

      Hi Vinod

      Thanks for sharing nice documents.

      Regards

      Sampat

      Author's profile photo Vinod Vemuru
      Vinod Vemuru
      Blog Post Author

      Thanks Sampat. Happy to see this content is helping many people here 🙂

      Thanks,

      Vinod.

      Author's profile photo Sampat Kumkar
      Sampat Kumkar

      Hi Vinod... absolutely right.... always be happier 🙂

      sampat

      Author's profile photo Former Member
      Former Member

      Great document! Thanks for sharing with us!

      Daniel

      Author's profile photo Vinod Vemuru
      Vinod Vemuru
      Blog Post Author

      Thanks Daniel 🙂

      Regards,

      Vinod

      Author's profile photo Dawood Khalid
      Dawood Khalid

      Great!!!

      Author's profile photo Vinod Vemuru
      Vinod Vemuru
      Blog Post Author

      Thanks Khalid 🙂

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Good job.  Thanks for sharing 🙂

      Author's profile photo Vinod Vemuru
      Vinod Vemuru
      Blog Post Author

      Thanks Krishna 🙂

      Author's profile photo Former Member
      Former Member

      Good document. Thanks for sharing.

      Priya

      Author's profile photo Vinod Vemuru
      Vinod Vemuru
      Blog Post Author

      Thanks a lot Priya 🙂

      Author's profile photo Former Member
      Former Member

      Very nice blog vinod.

      Thanks,

      Ankur

      Author's profile photo Vinod Vemuru
      Vinod Vemuru
      Blog Post Author

      Thanks Ankur 🙂

      Author's profile photo Siva Ram D
      Siva Ram D

      Thanks Vinod for sharing your knowledge.

      I have one doubt please clarify.

      Normally sales order is created as a cost object scenario qty, revenue,cogs and other values will flow to copa at the time of sales order settlement and this values updated in record type 'C'. In this case reconciliation is possible? I don't have that much knowledge in reconciliation please give me a clarification.

      Best regards

      Siva ram

      Author's profile photo Vinod Vemuru
      Vinod Vemuru
      Blog Post Author

      Hello Siva,

      I couldn't test this in my system as we don't have sales order as cost object. But, you can try t-code KEAI.  Sales order can be entered in selection screen and select record type as C. Please let me know if this serves the purpose 🙂

      Thanks,

      V V

      Author's profile photo Mariks .
      Mariks .

      Good document...Thanks for sharing the knowledge....

      Author's profile photo Vinod Vemuru
      Vinod Vemuru
      Blog Post Author

      Thanks Mariks 🙂

      Author's profile photo Arvind Pereira
      Arvind Pereira

      Buddy.

      Thanks for sharing, useful one.

      Regards,

      Arvind Leo Pereira

      Author's profile photo Vinod Vemuru
      Vinod Vemuru
      Blog Post Author

      Thanks Arvind 🙂

      Author's profile photo Former Member
      Former Member

      Hi

         Vinod

      Integration is always important...... Keep up the good work


      This is very inspiring. thank you for taking the time to describe and make it available to us all. 🙂

      Author's profile photo Vinod Vemuru
      Vinod Vemuru
      Blog Post Author

      Thanks Srinivas 🙂

      Author's profile photo Abdullah Galal
      Abdullah Galal

      Thank you for sharing, you have a great writing style and I'm sure I'll check all your blogs

      Author's profile photo Sathyaraj Rajagopal
      Sathyaraj Rajagopal

      Very Well Explained.

      Regards

      Sathyaraj R