Skip to main content

Celonis Product Documentation

FAQ - Open Purchase Requisition App

Why should I convert the columns to a single currency in the data jobs, and then convert back in PQL to all other currencies?

The currency conversion is set up this way because the SAP system does not store the mappings between all possible currencies in the system. For example, there might not be a mapping between Indian Rupees (INR) and Swedish Krona (SEK), simply because the local currencies never need to switch to those currencies. By not storing this mapping, the SAP system can operate with less data used for currency conversion mappings.

Because these mappings often do not exist between all local currencies, the PR connector first converts all currencies to a common currency that is mapped (eg. EUR, USD, GBP), and then allows you to convert back to other local currencies within the application. Essentially like a join n:1:n, OR local currency 1: common currency: local currency 2.