Skip to Content
avatar image
Former Member

COPA Value field in FI Manual entry

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Oct 31, 2017 at 02:59 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 31, 2017 at 04:33 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Oct 31, 2017 at 03:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • Oct 31, 2017 at 11:54 AM

    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

    Add comment
    10|10000 characters needed characters exceeded