SD-FI-COPA reconciliation: Part-2

[vinod_vemuru2]

This blog is a continuation to the earlier blog "SD-FI-COPA reconciliation: Part-1"

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

This blog talks about how characteristic and value field flow is integrated between SD and COPA and if something went wrong in COPA document how to regenerate correct values without impacting respective SD and FI postings.

T-code KE4S can be used to simulate the characteristic and value field flow from SD to COPA or reverse and re-post COPA document alone. Alternatively,

T-code KE4ST can be used only for simulation purpose. Let us see how this can be used to understand the integration between SD and COPA without running through configurations.

Important fields in selection screen (KE4S):

Test Run:

No document is created (Even in posting run). Only values are simulated.

Create Log:

If we select this, Characteristic and value flow log is created for further analysis.

Redetermine profitability segment:

This option should be used cautiously. If this is selected, profitability segment values are redetermined as per the current system config. This can be used in scenarios like, incorrect values posted in profitability segment due to incorrect derivation rules/incorrect logic in user exit.

Check for existing records:

This performs a pre-check before transferring the data. Only documents which have not been flown to COPA are considered for posting.

Reversal of line items:

This option reverses already transferred documents and re-post all (Both transferred and non-transferred).

Posting without check:

This option should be used cautiously. This option re-post everything. If there are documents already posted, system posts duplicate document.

Please go through F1 documentation of each field for more details.

Go to T-code KE4S, enter a billing document which was transferred to COPA and execute.

Below is the output of report.

We can see two lines are created here because, one is for reversal and other is for re-post. There are different status ICONs in ALV tool bar indicating number of documents in respective status. This helps particularly when we process huge number of documents.

Now let us see how characteristic and value flow analysis is done.

Characteristic flow analysis:

Select the row and click on "characteristics".

Below screen shows the characteristic values that are derived in COPA document.

Click on "Display derivation analysis".

In this step, we can find how each characteristic was modified in each step of derivation with respective old and new values. If any characteristic is changed in a particular derivation, that row is highlighted in yellow. Node "Values before/After" just displays old and new values during derivation process.

Derivation customization can be configured in t-code KEDR.

Value flow analysis:

Select the row and click on value flow.

Below result shows, source of each value field. As I mentioned in my previous blog, COPA value fields are linked to sales pricing conditions.

So, below output analysis shows how each sales condition is transferred to the respective COPA value field.

You can see for some rows, there is no G/L account assigned. It is because, these conditions are configured as "Statistical" and hence, no FI posting.

Since there is no FI posting, no G/L determined here too. We can find the statistical tick in the pricing conditions of the original billing document. Such kind of config is required when we want to see some figures only in reporting/for analysis purpose but not part of financial booking.

In first row, Currency type B0 indicates values in "Operating concern currency" and 10 stands for values in "Company code currency".

Valuation:

COPA valuation is used for automatic calculation of values in costing based COPA (Both planned and Actual). There are different valuation strategies provided by SAP.

1. Valuation using material costing,
2. Valuation using conditions and a costing sheet,
3. Valuation by means of a user-defined program exit,
4. Valuation with transfer prices

Please check below IMG documentation for more details.

Select the row and click on valuation.

Each valuation strategy step can have different logic to change value fields.

Click on the Analysis button which show if the value field has been changed in respective user exit.

Click on "Result of Valuation". This shows the entire list of value fields before and after valuation.

Hope this blog helps to give better understanding of SD-COPA integration and how characteristics and value fields are determined.

Your valuable feed back on this blog is most welcome :smile:

Thanks,

Vinod.