SLT: Error while replicating data with CURR data-type

larissamdealmeida — Thu, 13 Apr 2023 16:55:36 GMT

Hello!

I've tried replicating data through SLT with the data-type CURR (NET_AMOUNT, 28.6) which refers to a different column with the data type CUKY (DOC_CURRENCY, 5). While in the source system I get the correct values (e.g. 1402), the replicated data follows the pattern of dividing the original value by 1000 and rounding up to 2 decimal houses (e.g. 0,14). I've tried altering the data type in LTRS to CHAR (34), DEC (28.6), and DF34_DEC without success.

How can I fix this issue?

Thanks in advance!

Re: SLT: Error while replicating data with CURR data-type

fedaros — Wed, 19 Apr 2023 15:25:39 GMT

Hi larissamdealmeida,

This is not an SLT error but how things works on application server, not everything you see on transaction is found exactly same on database table.

Application has convertion exits, to format something from database to what users need to see. Example: dates on database are always yyyymmdd, but is formated properly according to user settings, for me appears dd/mm/yyyy, for US mm-dd-yyyy.

In your case, seems to be the same. Go to SE16, on table with has the NET_AMOUNT and you probably see it as 1402. Now go to Settings -> User Parameters and disable flag Format -> Respect conversion exit and you probably will see 0,14 that is probably the value found on database.

See more info on SAP Note 137626 - FAQ: Decimal Places for Currency Codes.

Now, for modeling on HANA you have to follow this:

https://help.sap.com/docs/SAP_HANA_PLATFORM/fc5ace7a367c434190a8047881f92ed8/d59c5f2cbb571014818fa6600fac57c4.html

https://help.sap.com/docs/SAP_HANA_PLATFORM/e8e6c8142e60469bb401de5fdb6f7c00/bd40ede94a694665a2c9d14268c37703.html?version=2.0.02

Or, depending of your user case you may found a different strategy of transformation inside SLT or on your view.

Regards, Fernando Da Rós

Question Re: SLT: Error while replicating data with CURR data-type in Technology Q&A

SLT: Error while replicating data with CURR data-type

Re: SLT: Error while replicating data with CURR data-type