topic Re: need help in decimal notation ?? in Application Development and Automation Discussions

need help in decimal notation ??

Former Member — Wed, 03 Jul 2013 19:04:16 GMT

Hi All,

I have prob with decimal notation, when ever i'm submitting QTY to sap its converting into different format like 1 to 1000,0

I tried with different solutions and i checked that SU01 default settings by changing the format and i did'nt find any solution.

Please suggest me ..

Regards,

Lokesh.

Re: need help in decimal notation ??

FredericGirod — Wed, 03 Jul 2013 19:09:24 GMT

Hi,

the internal format of SAP for decimal is xxxx.yyy (for quantity) and xxxx.yy (for value)

you can't change it

regards

Fred

Re: need help in decimal notation ??

Former Member — Wed, 03 Jul 2013 19:44:18 GMT

I dont think i need any help in decimal notation. Anyway, thanks for offering to help.

BTW, your question is not so clear. Post any code segment that you are using and where you are seeing it is stored in a different format, is it in a database table?

Regards,

Karthik

Re: need help in decimal notation ??

Former Member — Wed, 03 Jul 2013 20:41:02 GMT

Hi ,

Thanks for ur reply ..

Here my prob is im trying to store QTY in custom table with field name meinh( base Qty) = 6 ex..

Upto Submitting code its showing as correct value like 6 only after submitting its showing as 9000

regards,

Lokesh

Re: need help in decimal notation ??

arindam_m — Wed, 03 Jul 2013 22:30:51 GMT

Hi.

First MEINH is Unit for the Quantity field. Then check the actual field that has the Quantity value something like this:

Also the value of 6 getting converted to 6000 could due to done by a conversion exit of the domain you have used in the your case.

Cheers,

Arindam

Re: need help in decimal notation ??

Former Member — Thu, 04 Jul 2013 01:57:42 GMT

hi Reddy,

you are saying that in the program value is '6' and in the table its showing as 6000. Please check if your program is not making any changes in this field and check if there is a conversion exit that is working in the table.

Please check and revert.

Regards,

DN.

Re: need help in decimal notation ??

Former Member — Thu, 04 Jul 2013 02:09:45 GMT

Hi,

Please post code snippet.

BR.

Re: need help in decimal notation ??

Former Member — Thu, 04 Jul 2013 05:29:14 GMT

Hi Lokeswar,

Use the function module CONVERT_FIELD_TO_INTERN_FORMAT.

Regards,

Karthik

Re: need help in decimal notation ??

Former Member — Thu, 04 Jul 2013 06:06:54 GMT

Hi lokesh,

is this field in PRICING CONDITION table of SO or PO or some Z table field ?

Can you give the data element / domain also so a more precise reply could be given.

Regrds

Re: need help in decimal notation ??

Former Member — Thu, 04 Jul 2013 06:20:01 GMT

Hi mohammed,

the fields are z fields and the please find the attachment...

Tqs and Regards,

Lokesh.

Re: need help in decimal notation ??

Former Member — Thu, 04 Jul 2013 06:40:34 GMT

Please create the UoM meins field also in the ZTABLE only and assign the same to your quantity Field.

Don't use the generic one of T006 meshi

Re: need help in decimal notation ??

RaymondGiuseppi — Thu, 04 Jul 2013 06:52:25 GMT

Could you post the full field definition, With decimal and UNIT field name, the dynpro definition and the move or other statements used to move the data ?

Usual field names are MENGE for quantity (QUAN) and MEINH for unit of measure (UNIT)

Did you use a customer domain or one of the already defined standard ?

(Ref : Quantity Fields)

Regards,

Raymond

Re: need help in decimal notation ??

Former Member — Sun, 14 Jul 2013 14:58:03 GMT

Hi All,

Still Im facing the decimal problem...., storing as 81,0000 instead of 81.0000

Scenario : I'm running my BDC Report from SAP UI5 Application from Google chrome Application..while creating Its Storing as 81,0000

I followed the below link

https://scn.sap.com/thread/1449990

I have checked all the login user's decimal format and it is configured as X 1,234,567.89...

Please help any other solutions ,

Regards,

Lokesh.

Re: need help in decimal notation ??

Former Member — Sun, 14 Jul 2013 17:16:04 GMT

Hi Lokesh,

This is based on the country specific standards that SAP may enforcing. Please look into configuration level.

Re: need help in decimal notation ??

Saha_Arpan — Sun, 14 Jul 2013 18:21:38 GMT

Hello Lokesh,

I believe that the problem you are facing is due to the decimal format in BDC. What you can do is instead of changing anything, use a char field, and replace the ',' with a '.'.

It is like:

data copy type char9.

move <your variable> to copy.

replace all occurences of ',' with '.'.

This should be done after you have received the values from the screen.

Further more, if you also have a thousand separator, split it into two strings and then join them with the decimal separator to have the complete value. Trust me, it works!!!!!

Also, I don't want to advise on this note, but I hope you have checked for a BADI for doing the entire operation......

Arpan.

Re: need help in decimal notation ??

arindam_m — Sun, 14 Jul 2013 22:47:42 GMT

Hi,

Check at 3 levels:

1. User settings as per the profile that is executing

2. Regional setting of the UI5

3.Also the browser regional settings

Cheers,

Arindam

Re: need help in decimal notation ??

Nawanandana — Mon, 15 Jul 2013 01:09:14 GMT

hi,

kindly maintain decimal setting using bellow T-code

OY01 - and change the decimal settings

Regard,

Nawa

Re: need help in decimal notation ??

Former Member — Mon, 15 Jul 2013 12:11:19 GMT

Hi ,

Solved, tqs for all valuable suggestions ..,

its funny i didn't check RFC FM default User id ..,

It's done

Rgds ,

Lokesh