moveing data between two models

[Former Member]

Hi,

I have a requirement to do the following:

1. load data into model1 in LC and USD
2. copy the LC data into model2
3. run an fx conversion in model2 from LC to GBP
4. copy the GBP data back into model1

I know that at least in the MS version of BPC I can achive items 2 and 4 with the destination_app keyword in a script, so I essentially have a few questions:

1. Does destination_app work in BPC 10 NW as well?
2. Would copying the data with the destination_app keyword via script from model1 trigger the default.lgf in model2?
3. Can the whole chain be automated?

Thanks,

Arnold

[ashwin_kulkarni2 · Accepted solution]

Hi,

Destination_app does work well with BPC 10 NW version.

Destination_app does not start default logic info is available in the following link.

http://scn.sap.com/community/epm/planning-and-consolidation-for-netweaver/blog/2012/11/05/destinatio...

Hope it helps.

- Ashwin.

[Former Member]

Hi Arnold,

Destination script is available in NW version.

Can you not do the currency conversion in model1?

[Former Member]

Hi Nilanjan,

the client has the following requirement:

P&L data is converted from local to USD in the ERP system using daily spot rates. Hence we load LC and USD into BPC, my idea is to then use [AS_IS] for the conversion to keep the USD values as imported.

However, we also need to convert LC to other currencies, which ones varies by entity. This conversion should be done in BPC using the average rate for P&L accounts.

So, let's say we have an entity reporting in JPY as their local currency. We would load JPY and USD from the ERP system but we also need the JPY values converted to GBP for a sub group consolidation.

If I use the above idea of [AS_IS] for my P&L accounts to keep the USD values loaded from the ERP system (which is the requirement) the conversion to GBP would not calculate any values. On the other hand, if I use [AVG] for P&L accounts I would get GBP values from BPC but the imported USD values would be overwritten when I run a currency conversion.

So to get around this dilemma I thought I would import LC and USD into model1 and copy LC to model2. Model2 uses [AVG] for the P&L accounts, so BPC calculates the GBP values I need. I then copy these back to model1 which uses [AS_IS] for P&L accounts. In model1 I can then run conversions to USD and GBP and consolidations in both currencies without problem.

If you can think of another solution to this requirement please let me know.

[former_member186338]

Hi Arnold,

The task can be automated using combination of DESTINATION_APP statement and RUNLOGIC BADI to be able to launch scripts in the target model. For the initial data load you will need some custom chain to be able to run specific script after the data load.

B.R. Vadim