Skip to Content
author's profile photo
Former Member

BPS - Table for Conversion

I have a manual planning input screen that we are keying data in for some Measures that have been set up. One of our needs is to do a currency conversion outside the SAP delivered currency conversion. What we need is a separate table, or something, to pull from for each measure.

Example:

We are entering for both US & Mexico. The Mexico values will need to be converted from Peso to USD. They can't use the regular conversion tables because the estimates we are doing need differnt conversion rates.

So lets say we have two measures.

In this conversion table I am talking about I want the user to be able to enter a conversion factor (each week it will be different).

Then, when the values for the Measures are entered into the entry screen, we want to be able to hit the function update key (much like the standard conversion function) and have it calculate the new amount based on this other table.

Thanks, Keith Johnson

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Posted on Jan 27, 2005 at 04:16 PM

    Hi Keith,

    Here we go again...;-)

    You have two options:

    1. Hold the non standard conversion rates in an InfoCube (the same as the other data or even better a separate InfoCube). The users can use BPS to enter the conversion rates. In order to calculate you can use a fox formulas (in a multi area).

    2. Use a database table to hold the conversion rates. Create your own data base table for the conversion rates and let the users enter the rates via se16 or a simple ABAP transaction. In order to calculate the data you need a planning function type exit so you can reed the data base table.

    I guess the first option is easier to customize.

    Best regards,

    Gerd Schoeffl

    Add comment
    10|10000 characters needed characters exceeded