need help in decimal notation ??

[Former Member]

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.

[FredericGirod]

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

[Former Member]

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

[Former Member]

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

[arindam_m]

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

[Former Member]

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.

[Former Member]

Hi,

Please post code snippet.

BR.

[Former Member]

Hi Lokeswar,

Use the function module CONVERT_FIELD_TO_INTERN_FORMAT.

Regards,

Karthik

[Former Member]

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

[Former Member]

Hi mohammed,

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

Tqs and Regards,

Lokesh.

[Former Member]

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

[RaymondGiuseppi]

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

[Former Member]

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.

[Former Member]

Hi Lokesh,

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

[Saha_Arpan]

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.

[arindam_m]

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

[Nawanandana]

hi,

kindly maintain decimal setting using bellow T-code

OY01 - and change the decimal settings

Regard,

Nawa

[Former Member]

Hi ,

Solved, tqs for all valuable suggestions ..,

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

It's done

Rgds ,

Lokesh