Please Share your Product Ideas with us!

All ideas are welcome. Just because the Idea doesn't make it into the product immediately does not make it a bad idea.

S4 HANA extration with CURR datatype fields

Hi,

In ADMM, when we extract data from S4 HANA (ODBC) for tables with field datatype as CURR. The SQL table is created with the field datatype as "money" and the replication job fails.


Instead, if I maintain a datatype setup as CURR = DECIMAL(15,2).

Then build &refresh replication. The table is created correctly and the replication job works fine.


Can we add this CURR to translate as DECIMAL(15,2) by default?

  • Guest
  • May 17 2023
Replicate
  • Jan 18, 2024

    Admin response

    Thanks for the idea. I've passed this on to our Migrate team as they are the ones that create the target table. You can make this change in the configuration area of Migrate today under the administer menu item but we'll look to change the default setting

  • Attach files
  • Admin
    Jon Green commented
    18 Jan 12:37

    @John Munkberg seems like a simple change to the default field datatype for CURR fields in Migrate when creating the tables?

    ×

    Attachments Open full size

Related ideas