amount multiplied by 100 after loading from BW Infoprov

[a_khanevich]

Hello!

I'm loading transactional data from BW to BPC by standard DM Package (/CPMB/LOAD_INFOPROV_UI).

I have the following direct assignment in the transformation file:

*MAPPING

SIGNEDDATA=ZFS_SUMRU

"ZFS_SUMRU" is a BW keyfigure with fixed currency.

After loading there is "1000" amount in BPC if it is "10" amount in BW-infocube.

What is the problem?

[bishwajit_das · Accepted solution]

Hi,

Please find the following notes :-

2080482 - Conversions of currencies are not applied when data are loaded to BPC through the data package "Load Transaction Data from BW InfoProvider UI"

1804424 - Transaction data loaded from ECC to BPC multiplied by 1000.

I think the simplest way is to maintain the BPC conversion file for Currency as -

EXTERNAL     INTERNAL     FORMULA

JPN                    JPN               VALUE*0.01

Regards,

Bishwajit