COPA Value field in FI Manual entry

[former_member413582]

Here is our requirement

We have a COPA value field - Commercial Value.(Commercial value is a statistical information to calculate commission). We can update the information in COPA value field Commercial value through condition type in SD billing document.

But now the requirement if we are doing FI manual entry for commission value, there is no specific field to enter the commercial value.

Do we need to create customized filed in BSEG and use exit for the derivation or is there any way to update the value in COPA value field in a standard way.

Please suggest.

Thanks

Suri

[malay_vakil]

Hi Suri,

You need to use exit COPA0005 with function module EXIT_SAPLKEII_002. In this function module having all information related to Accounting document line item in internal table T_ACCIT.

You can transfer T_ACCIT field values to copa internal table T_ITEM. for example you pass commission in FI document as Text (BSEG-

SGTXT) to copa value field of Commission.

Regards,
Malay

[malay_vakil]

Hi Suri,

COPA value field of FI entry derived through PA transfer structure "FI". If you have separate GL code for commission then you can link that GL account to required value field. Derivation (KEDR) rule only works to derive characteristics not value fields.

In case if you want to derive value field then require to use exit "COPA0005"

Regards,

Malay

[former_member413582]

Hi Vakil,

Understand. Commission value can be entered through GL account. But we want to update the commercial value which is a statistical information. Is there any BSEG field (like Reference key 1/2/3) that we can utilize to enter the commercial value?

I think for the derivation we have to use exit.

Thanks

Suri

[former_member413582]

Hi KK Lam,

Thanks for your reply.

you mean XREF1, XREF2 & XREF3 in BSEG table right?

Can you explain me how to write derivation rule for commercial value in KEDR?

Thanks in advance.

Suri

[former_member513101]

Hi Suri,

If your commission value is an amount or quantity. Then you need to update it in copa value field instead of characteristic. You can use user exit COPA0005 to map the XREF1 or XREF2, or XREF3 to your commission value field. These reference keys fields exist in structure ACCIT. You need abaper to write the code.

Thanks.

[former_member513101]

Hi Suri,

You can consider to use reference key 1, 2 or 3 for the commission value and use KEDR derivation to derive this value to copa value field when you post it via FI.

Thanks.