Decimal Transform . to ,

Previous  Home  Next

SAP landscape may vary depending on different languages in different countries.

For example a decimal point is “.” in English whereas the same is represented as “,” in German.

So, 112.24 in English = 112,24 in German

To provide for this transformation, this DF is useful.

Suppose we have an excel data as below & we require to change . to ,

DF2

In Mapper, select the respective DF for that field.

DF3

Below is the actual value that will go into SAP.

DF4

 

Next:

Transform Excel date to DD.MM.YYYY | Transform YYYYMMDD to DD.MM.YYYY

Split & Append Long Text Line(s) | Custom Formula