Foreign currency revaluation and Profit Centers

[former_member193516]

Hi all,

We want to use F.05 to post exchange rate differences but are working with a system that uses also Business areas and a multitude of Profit Centres (in one company code).

We have One company code

> n business area for this one company code, and

> n profit centre per business area

SAPs standard solution for this issue is use transaction 3keh/ 3kei and send it to a specific profit centre (one per company code).

This does not help us. We would need to have the differences to be distributed at least on Business area level or at least on profit centre level.

Who can help? Any suggestion mostly welcomed! What would need to do to achieve this?

Thanks!

Hein

[Former Member · Accepted solution]

Hi

If you want to assign the differences to Business areas also other than profit centers.

You can force the assignment of the GL account to Business area, profit center, cost center with transaction OKB9. Or try out validations and substitutions.

Try it out it might be helpful.

Regards,

Suraj

[former_member671624]

I had similar but more straightforward requirement to simply copy the CC and PC from item being revalued. I did it in substitution BTE process 00001120 calling this method at the item level:

    CLASS-METHODS reval_ref_objects
      IMPORTING iv_sgtxt       TYPE bseg-sgtxt
                iv_bukrs       TYPE bukrs
      RETURNING VALUE(objects) TYPE ref_objects.
 
 METHOD reval_ref_objects.
    TYPES: BEGIN OF ref_type,
             bukrs TYPE bukrs,
             belnr TYPE belnr_d,
             gjahr TYPE gjahr,
             buzei TYPE buzei,
             kostl TYPE kostl,
             prctr TYPE prctr,
           END OF ref_type.
    STATICS ref_items TYPE SORTED TABLE OF ref_type WITH UNIQUE KEY bukrs belnr gjahr buzei.
    DATA: ref_temp TYPE STANDARD TABLE OF ref_type,
          bseg_key TYPE bseg_key.


    SPLIT iv_sgtxt AT space INTO DATA(junk) bseg_key-belnr bseg_key-buzei bseg_key-gjahr.
    bseg_key-buzei = |{ bseg_key-buzei ALPHA = IN }|.
    bseg_key-belnr = |{ bseg_key-belnr ALPHA = IN }|.
    IF NOT line_exists( ref_items[ bukrs = iv_bukrs belnr = bseg_key-belnr gjahr = bseg_key-gjahr ] ).
      SELECT bukrs,belnr,gjahr,buzei,kostl,prctr FROM bseg WHERE
      bukrs = @iv_bukrs AND
      belnr = @bseg_key-belnr AND
      gjahr = @bseg_key-gjahr
      INTO TABLE @ref_temp.
      INSERT LINES OF ref_temp INTO TABLE ref_items.
    ENDIF.


    TRY.
        DATA(item) = ref_items[ bukrs = iv_bukrs belnr = bseg_key-belnr gjahr = bseg_key-gjahr buzei = bseg_key-buzei ].
      CATCH cx_sy_itab_line_not_found INTO DATA(cx_not_found).
    ENDTRY.
    IF cx_not_found IS INITIAL.
      MOVE-CORRESPONDING item TO objects.
    ENDIF.


  ENDMETHOD.

[Former Member]

Hi

In GL account master record field status make egther profit center or Business area as required field and do the automatic assignments.

I hope this will work.

Regards

Muralidhar

To say thanks reward points if it is useful to you.

[former_member193516]

I have seen that I can use in 3kei the rules to add one including the Business area.

Now, what could I do to go the level down to have the profit centre used that was part of the original document?

Is there a user exit somewhere in this program where I could change the posting?

Thanks!