3 Decimal places for Data Migration in S4 Public cloud

[Dineshkumar]

Hi ALL,

Currently, we are implementing Country Oman - facing an issue with the Data Migration open item as templates allow only 2 decimal places. 

How to change default decimal places in the migration cockpit, I tried with modeler but cannot edit the standard structure. 

[FrankFinkbohner]

Hello Dineshkumar,

for which objects do have this problem? Only for Open items AP or also for AR and G/L open items?

BR Frank

[Ash4]

Hello @FrankFinkbohner , Thank you for the clarification. 

[Dineshkumar]

Hi @FrankFinkbohner , 

The issue is coming for Finance templates - AR/AP/Fixed asset and GL.

However, to update further, yesterday, we checked a few other templates, like Open Purchase orders and Sales orders; we faced the same issue in the amount field. 

Regards,

Dinesh 

[Ash4]

Hello @Dineshkumar ,

Please check if the below SAP KBA helps:

3517123 - Migration cockpit template only allows zero or two but no three decimal places for currenc...

Thanks and regards,

Aswathy

[Ash4]

Hello, Please check if the below note helps: 3517123 - Migration cockpit template only allows zero or two but no three decimal places for currency amounts - SAP for Me Thanks and regards, Aswathy

[FrankFinkbohner]

Hello @Ash4, the provided KBA is only for Private Cloud and On-Premise. @Dineshkumar is asking for Public Cloud. Within Public Cloud, you cannot make changes on sender structure or copy the object into a user-defined objects as proposed by the KBA.

[HenrikeGrtecke]

Hello,

Thank you very much for your question.

Here's the information you're looking for:

Additional Information About XML Template Files:

https://help.sap.com/docs/SAP_S4HANA_CLOUD/d5699934e7004d048c4801b552f3b013/ca2e848ff03e478db96d7dfa...

"Number

• Enter numbers with decimals in the relevant country-specific format, for example 12.34 (United States) or 12,34 (Germany). For fields with decimal places, the length includes the number of decimal places (if required), for example if the information for the column states Length: 8, Decimals: 3, then a number such as 12345.678 is permitted. Note that decimal places are not mandatory. In is this example, you can specify a whole number up to length 8 without decimal places, for example ‘1’. This number would be set to ‘1.000’ internally. For negative numbers, ensure that a minus sign (‘-‘) directly precedes the number, for example ‘-100’.

  Note that the maximum field length supported by Microsoft Excel is 15 digits (including decimals). If you have longer numbers, use the option for transferring data to S/4HANA using staging tables. For more information, see SAP Knowledge Base Article 2718516"

  Kind regards,

  Henrike

  .

[Dineshkumar]

Hi, i made some changes in XML template and able to bring to stagging table. However while simulating and migration, still document posted with 2 decimal places. May be could be due to structure S_BSIK - Amount field having only 2 decimal places and cannot be edited using modeler also.

[HenrikeGrtecke]

The question has been forwarded to the experts.

[FrankFinkbohner]

.