topic Re: Changing decimal notation dynamically in Application Development and Automation Discussions

Changing decimal notation dynamically

Former Member — Fri, 22 Aug 2008 12:34:11 GMT

hi all,

I have a requirement to upload an excel file through BDC.

In that file I have a decimal field.

SAP environment can take it in two formats viz 12.23 or 12,00 which we can set manually in user profile in system option in toolbar.

System -> User Profile -> own data -> default -> decimal notation.

but if the decimal notation in SAP environment is opposite of what we are providing in excel file field,

then it will give an error viz Input must be in ___,____ or ____.____ format

So I want to change my data field in excel to the decimal notation as in SAP environment.

Please suggest. Its urgent.

Thanks in advance

Manish Gupta

Edited by: MANISH GUPTA on Aug 22, 2008 2:34 PM

Edited by: MANISH GUPTA on Aug 22, 2008 2:35 PM

Re: Changing decimal notation dynamically

former_member585060 — Fri, 22 Aug 2008 12:38:24 GMT

U Upload the Data from Excel sheet into an internal table of all fields character format, then map that to standard sap fields.

As in Data transfer we usually upload data into character field table, so that sap automatically converts the fields to its desired form if the incoming data is of character format.

Re: Changing decimal notation dynamically

Former Member — Fri, 22 Aug 2008 12:38:53 GMT

set the decimal places from user data and set accordingly x 123456789.000 like that.

and create ur data in file as decimal places 12.23

This will not throw error.

Re: Changing decimal notation dynamically

vinod_vemuru2 — Fri, 22 Aug 2008 12:39:11 GMT

Hi Manish,

Take one character variable of sufficient length usually 19 for currency and quantity fields.

Now use WRITE to statement to move data from ur work area to this variable and use this variable while populating the BDC.

It works fine.

What it does is it will write the data absed on user settings.

eg:

DATA: w_currency(19) TYPE c.

WRITE wa-currency TO w_currency.

CONDENSE w_currency.

Now use this variable while populating the BDCdata table.

U have to follow same for date and time fields as well.

Thanks,

Vinod.

Re: Changing decimal notation dynamically

former_member585060 — Fri, 22 Aug 2008 12:54:39 GMT

Check this BDC Sample by Renjith Kumar. P

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/309cb157-738d-2910-7691-b74c4ddba3c7

Re: Changing decimal notation dynamically

Former Member — Fri, 22 Aug 2008 12:59:02 GMT

Hi gupta,

Go to SU01 transaction and then change ur values

to your required format.

I hope this solve ur problem.

Regards,

Ranjith C.