COPA Report data for Incoterms

[Former Member]

Dear All,

We had KE30 copa report which have incoterms as one of the characteristic. Data for incoterms already defined in customer master data. So when we want to create sales order, the incoterms will automatically exist refer from the customer master data. After that we can continue to post outbound delivery then create billing until the profitability analysis document created. Based on that normal transaction, we can got incoterms data in copa report correctly.

Now the problem is, if we changed the data for incoterms when we create outbound delivery then we create billing refer from that outbound delivery number, so the copa report can not read the changes. I guess the KE30 copa report only read actual data that triggered from sales order or billing transaction.

I already tried to make characteristic derivation for incoterms from billing transaction that looked up from VBRK table with KAUFN (Sales Order Number) as source fields, but the problem still do not solved.

Is possible for KE30 copa report can read the changes of incoterms when create the delivery order?? Because not relevan in our case to change the incoterms data from sales order. Can anyone help me to solve my problem?

Thanks a lot

Regards,

Maradona

[ajaycwa1981 · Accepted solution]

Hi Maradona

Deriving chars from billing docs is not easy

You need to add an entry in the Table TKEZU in SM30 as below

Char = WWXXX you created for Inco Terms

BTran = KEDR

Table = KOMK or KOMP (Try with KOMK first)

Field name = INCO1 or INCO2

Br, Ajay M

[Former Member · Accepted solution]

Dear Ajay,

Thanks for your answer..

I tried to maintain V_TKEZU table in SM30 with the parameter above. But I think the table do not work properly, because of the copa report still cannot derive from billing documents.

How if i try to use exit COPA0005?

Do you have other solutions?

Br,

Maradona

[ajaycwa1981 · Accepted solution]

Hi Maradona

After you maintained TKEZU (Maintain for both KOMK and KOMP), create a billing document and check,

For the docs already posted, this TEKZU setting wont impact them

Exit COPA0005 is also an option, but TKEZU should work...

br. Ajay M

[Former Member · Accepted solution]

Dear Ajay,

I already add an entry in table V_TKEZU as follows:

• Char: WWXXX
• BTran: KEDR
• Table Name: KOMK
• Field Name: INCO1

Then I recreated 1 new sales order, then post good issue outbound delivery, then create a billing docs.

The results is: Incoterms in billing documents already updated refer from changes in outbound delivery, but not works for the incoterms characteristic. The incoterms characteristic still derive from sales order

1. If I change the table name from KOMK to KOMP, I found an 'abap error' when creating the sales order. So I restore the settings as above.
2. If I add one more line for entry the table name KOMP, the characteristic WWXXX cannot assign with the same field name.

Please help me.. and what can I do next for solving the problems??

Thank you very much

BR,

Maradona

[ajaycwa1981 · Accepted solution]

Hi Maradona

You can try with exit COPA0005 then. that will work for sure

Meanwhile, lets hear from experts

  - Would you know why TKEZU does not work here?

Br. Ajay M

[waman_shirwaicar · Accepted solution]

Hi Ajay and Maradona,

      The TKEZU entries are called during the creation of the PA segment. I believe in this case the PA segment gets created during VA01. This PA segment will be carried forward to the billing document.

    Now when Maradona says that the incoterms have changed after VA01 the question is where have they changed ? Have they changed in the customer master ? If so then in your derivation rule attributes you need to have "overwrite with new value if new value found" so that the values get changed when the COPA document is created during billing. This would be easy.

  If they have changed on the billing document then its tricky because TKEZU may be the only way. But for TKEZU to work you may need to redetermine the PA segment during billing using OKC9.

regards

Waman

[ajaycwa1981 · Accepted solution]

Hi

Thats a nice info from you.. I have 2 questions

1. I remember, in one of your replies, you mentioned that during Billing KOMP structure is available.. And now i learned from you that TKEZU is called up during creation of PA segment.. So that means, unless and until your PSG is determined during Billing, TKEZU is of no use.. Is this understanding correct?

2. How to redetermine the PSG using OKC9? Can it not be done using some exit in Billing itself (RV60AF**) ??

Br. Ajay M

[Former Member · Accepted solution]

Dear Waman and Ajay,

I changed the incoterms in outbound delivery (VL02N), because we are not allowed to change from customer master data.

So for this case, should we try activating subtitution for solving my problems?

Thank you

BR,

Maradona

[waman_shirwaicar · Accepted solution]

Hi Maradona and Ajay,

    Please confirm that the PA segment in your case gets created during VA01.

TKEZU is only useful when the PA segment gets created. If that happens during VA01 then TKEZU would not be useful in your case unless you redetermine the PA segment during billing.

For this there are 2 options:

Option 1:

You could try to implement the workaround mentioned in note 70231 as this note redetermines the profitability segment at the billing document.

Option 2:

Substitution of the segment number with transaction OKC9.

The OKC9 substitution could cause a redetermination of the PAOBJNR field (under suitable conditions) at time of creation of the accounting documents for the billing document so that the new segment number contains the updated char values and provides the changed char values for the

accounting documents. Just have a look at note 425725 that describes the  implementation of an OKC9 substitution in a different case  (with business transaction COBL-VORGN = 'KOAQ' that must be changed to fit your case). I believe that COBL-VORGN = 'SD00' in this case but please verify this.

regards

Waman

[ajaycwa1981 · Accepted solution]

Hi Waman

I am convinced woth your answer

Let us see if the owner of this thread finds it useful

Br. Ajay M

[Former Member · Accepted solution]

Dear Ajay and Waman,

After I tried solving this case with some options, which includes: maintain table V_TKEZU or define substitution, the way above assuming didn't work.

So that I decided to implement exit COPA0005 which is helped by abap. Finally the result is: The copa chars incoterms succeed to derive from billing docs.

But on the other hand before I used the exit, the copa chars can redetermine value deriving from billing docs using KE4S. I called the billing docs then reversal the line item, then redetermine prof segment with new value from billing docs. This option may used if table V_TKEZU was already maintained.

Finally for this case, I prefer using exit COPA0005. Because the copa chars has automatically derived from billing without executed more transactions.

Thanks a lot

Br,

Maradona