Skip to Content

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):

1.JPG

2. Run SE38 and input for program RKEDELE1

Remove the “test run” and execute

2.JPG

3.JPG 

3. For confirmation check the billing docs in CE1xxxx table again: on execution we should get a msg like

5.JPG

4. Now we need to post the billing docs to COPA again without any check. For this we will run KE4S

6.JPG

7.JPG

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.

8.JPG                                  

Run program RKEREO31:

9.JPG

We see the result in test mode:

10.JPG

As test result is successful we will run the program in real mode :

11.JPG

Now both CE1xxxx and CE3xxxx tables are updated. All changes we wanted to carry out will be reflected in COPA report.

===============================================================

Regards

Indranil

To report this post you need to login first.

13 Comments

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

    1. indranil sen Post author

      Thanks Srikanth , the blog would have been better if I could paste the screenshots , step by step . I tried but failed .

      Regards

      Indranil

      (0) 
  1. Muhammad Usman Raza

    Dear Indranil sen

    i have done these steps, but my reports get too much slow, as MAXDB is used over here,

    Data in CE1**** = 776,375

    Data in CE4*** = 809,835

    our company requirement full fill through Line item reporting (KE91). (Day Wise Sales Reporting)

    while executing report system takes upto 25 min Min each report either execute on 1 day or a year.

    Please give any solution. Thanks!!

    (0) 
  2. Abhisek Patnaik

    Dear Indranil,

    Thanks for sharing this detailed document. We from SAP don’t recommend this report to all customers.

    You can add a word of caution while using or recommending this report to users. The report should only be used in case there really exists a inconsistency  between CE1 and CE3.

    Regards,

    Abhisek

    (0) 

Leave a Reply