Incorrect field populating in to CE1XXXX line item table

[Former Member]

Hi

We are creating a sales order and when I checked profitability segment at line items level I am seeing customer#1000 where as when the sales order is created and billing document is posted,COPA line item table CE1XXXX is populating with customer#2000 instead of 1000.Hence KE24 report is also showing incorrect correct customer number.

I checked derivation rules and no where we defined derivation rule to replace customer.Also I didn't find anything in substitution rules. Also there is no connection between customer#1000 and 2000 in partner profile functions.

Please help me in guiding

1)Where is the customer value 2000 is being picked up?

2)In what placed so I need to check the substitutions?

3)Is there any COPA user exists effecting this?If so how to check them?

regards

BJ

[Former Member]

Hi Thanks,

I found the reason now and it goes,when first settlement was done on sales order ship to customer was X .Then business went and changed the ship to customer on sales order to Y. Now business wants to see KE24 report under customer Y even for old entries posted under X in to CE1XXXX table. Is it possible to change the customer X to Y in CE1XXXX table?

If so is it advisable or very risky?

thanks

BJ

[former_member348872]

Hi

You can run KE4ST and see if you still get incorrect customer, if Yes, you may need to debug FM - KEDR_COPA_DERIVE. For User exit you can check SMOD - COPA0001

[coleti]

Dear Balaji,

The customer should be the same as the accounting document customer. Usually the payer of the Billing Document.

But sometimes you can have some derivation of characterisc in COPA which can change them. Check the Derivation of your COPA documents you can use the following transactions for that:

KECM - CO-PA: Customizing Monitor

KEDR - Maintain Derivation Strategy

Best regards,

Gabriel Coleti

[Former Member]

Hi Gabriel ,

Thanks for your reply.

I checked KEDR derivations and for sure we not deriving any customer number from here.Having said that I observed one more thing,that is we are not transferring any values to COPA during data entry i.e KEKF has blank space against our operating concern..This incorrect customer value is transferring during Sales order settlement.When I checked the posted records in to COPA they are always with only Record type "C" and "F". This means we are posting during sales order settlement.

Does this give any clue for you please?

regards

BJ

[coleti]

Dear Balaji,

By the source code in RKEVRK2S_FIX, the Sold-to party is the master data moved from SD to CO-PA document.

Your customer 2000 is the Sold-to party ? If you need some different rule from that I think you have to implement the derivation.

Best regards,

Gabriel Coleti