COPA - New Characteristics derivation

[sachin_thombre]

Hello All, I am new to SAP-COPA, need your help please.

In the billing doc, line item data, we have a field "Your Reference", this field is updated with France store number Eg: FR1234 Now, when business users executes KE24 report, the requirement is to display this field as a new column: Store Number: which should update FR1234 in the line. As per the screen shot.

My Questions: I am assuming I have to create this as a new characteristics. Your Reference field is = Table Name (VBKD-IHREZ). Can you please let me know how to proceed further?

[lucy_gray2]

Hi Sachin,

You need to maintain a derivation rule for the newly created characteristic "Your Reference" in tcode KEDR.

Please refer to the below video tutorial.

SAP CO-PA: characteristic derivation

In the above video, table MARA is the table from which characteristic values are derived, but in your case, the origin table of table look up will be VBKD.

On a side note, creating a new characteristic while CO-PA is already in use, would be a huge task, because you will need to regenerate the Operating Concern. So if possible, please see if you can accommodate the value of "Your Reference" in some unused characteristic. If you find such an unused characteristic, you may change the label of that unused characteristic to "Your Reference" with the help of an ABAP developer.

Below link contains the steps to regenerate an Operating Concern, in case if you have to.

Regenerating an Operating Concern

All the best!

Lucy

[sachin_thombre]

Thank you so much Lucy.

Let me follow the steps as mentioned by you. I will get back if this works !!

Thanks.

[sachin_thombre]

Hi Lucy, When I read your reply, you mentioned "new created characteristic. I have not created any characteristic, its just the existing field in VBKD that I was referring to. Do I have to create this as characteristic?

Also, from KE24 output currently customer column is updated with "12345", is there a way to use derivation rule to update with "FR1234", [based on certain conditions], I think this will avoid the regenerating operating concern that you mentioned, as we want to avoid more changes and keep it simple.

Please revert.

Thank for your help

[sachin_thombre]

Can somebody please revert