Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Conversion formula is not working while loading the BW data

Hi,

We are trying to load the data from BW to BPC through the DPM. While doing the same the JPY currency sign data is getting multiplies with 100 and loading into BPC. If 1800 is the value in BW then it posts 180000 in BPC which is inflating the total amount.

I have tried to maintained formula in the conversion file as in the attached screen shot. But still the loads are multiplying with 100.

Please let me know if I have to modify some thing.

REgards,

Shilpa

Capture6.PNG (51591 B)
Capture5.PNG (43182 B)
Capture4.PNG (35588 B)
replied

Hi Shilpa,

I think there is a conversion taking place in BW, try value*0.0001 in your conversion file.

you can have a look at table TCURX in BW system.

also this doc for reference.

Exceptional Currency Handling in BW

Andy

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question