Hi All ,
Reconciliation between SD & COPA and thereafter COPA & FI is a time consuming and hectic job in every organization . Before starting this , we need to ensure the correctness of COPA . I tried to explain how COPA data and report can be corrected without interfering into SD module .
COPA correction of selected billing docs (record type “F”)
When costing based COPA is active, billing docs from SD flows directly to COPA. For this every condition type in SD is mapped to a value field in COPA. But sometimes one or more condition types are found missing in COPA, which result in SD-FI-COPA mismatch. Again on some occassions the condition type is found to have flown to some other value field for which it’s not customized. The main reasons behind this missing value fields are:
Ø the customization , mapping SD condition type to value field, is changed during a period
Ø change in the condition type in SD itself
Ø Multiple condition type mapping to single value field.
SAP recommends the reversing of billing doc and releasing of the same to FI/COPA again; in certain circumstances it’s not possible in SD.
In such cases, in COPA the reposting option is available without affecting SD or FI. The related program is RKERV002 and t code is KE4S. The inherent problem is it creates 2 more docs, viz. the reversed doc and the reposted correct doc. So it ends up with 3 docs in the COPA tables. After that we can delete the original and reversed doc through t code KE4S00. As physical deletion from database is not possible, cancellation of these 2 docs again create two more cancelled docs. At the end we are left with five COPA docs against one billing document.
To overcome the multiple doc scenarios we need to delete the faulty COPA doc from database and post the same billing doc to COPA without any check. This involves 3 activities viz. deletion, posting, reconstructing.
The procedure is as follows:
1. Open the CE1xxxx table and check the billing docs finally before deletion (xxxx=operating concern):
2. Run SE38 and input for program RKEDELE1
Remove the “test run” and execute
3. For confirmation check the billing docs in CE1xxxx table again: on execution we should get a msg like
4. Now we need to post the billing docs to COPA again without any check. For this we will run KE4S
5. Now the deletion and posting is completed, but this only updates the CE1xxxx table. We need to update the main profitability segment table which is CE3xxxx; otherwise the COPA report will not reflect the changes. This is known as reconstruction of CE3xxxx table.
Before doing this we need to create a blank file viz. “ABC.txt” on the desktop. SAP stores the intermediate data in this file during the phase of reconstruction.
Run program RKEREO31:
We see the result in test mode:
As test result is successful we will run the program in real mode :
Now both CE1xxxx and CE3xxxx tables are updated. All changes we wanted to carry out will be reflected in COPA report.