Currency decimals from SAP extract

[Alev]

Dear all,

We have a problem, getting currency values from SAP. Usually a currency is interpreted with two decimals; in SAP standard tables, it is stored without decimal indicator as cent value.

100. E. 100 EUR saved on SAP database (in ASCII) as 00010000C. Shown in SAP and Qlik as positive 100.00 EUR. That is ok.

Problem: SAP has the customizing table TCURX (T-Code OY04) which allows setting deviating decimals for specific currencies. For example, Japanese Yen we have zero decimals.

Sample: 100 JPY saved on SAP database (in ASCII) as 00000100C. Shown in SAP as positive 100 JPY – ok (without decimals). But Qlik interprets 1.00 JPY which is of cause not the same.

We faced this when Japan we installed first Japanese location in our global SAP system.

Is there any standard work around or extension, which aligning these SAP behavior? Actually, we just multiply the JPY values for local currency fields by 100 if local currency code is JPY. However, need to be done in each and every load process – and have to adjust if we get a plant with other setting in SAP (e. g. Kuweiti Dinar KWD has three decimals :-().

thanks for every hint

Alev

[Mario_De_Felipe]

Reach out support. I'm not a SAP expert but seems the type field is not the same in the standard table and the custom table. 

[Alev]

Dear Mario,

thanks for your hint. To me it seems, we need two field types for same field. From SAP we get in same field values with and without decimals, depending on related currency key.

As mentioned, we get it without decimal or thousands indicator. In this example we receive
First line 267000 which means: 267000 JPY
Second line 4443 which means: 44,43 EUR
Is there some kind of "best practice" or a recomended general solution?
Kind regards for any answer
Alois