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:

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.

Below is the sample output of the report

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

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