Skip to Content

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

To report this post you need to login first.

41 Comments

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

    1. Vinod Vemuru 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,

      (0) 
  1. Thiyagarajan V

    Hi vinod…

    Nice post…

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

    Best wishes

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

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

      (0) 
  3. srinivas kumar

    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. 🙂

    (0) 

Leave a Reply