Question Re: data type xsd:decimal in Technology Q&A

data type xsd:decimal

Former Member — Wed, 08 Jul 2009 04:26:59 GMT

Hi,

If you declare a field type as "xsd:decimal" and activate proxy, it makes the ABAP technical type as "String" of type xsd:decimal.

similarly if u make that variable with a entry in total no of digits then it gets activated with xsd:decimal and ABAP type DECIMAL.

I tested on 7.1 and 7.0 SP13. same problem.

I dont see this problem with integer. has any one noticed this?

is this a bug or has SAP has some reason before making this functionality?

Has any one faced the similar problem earlier?

Venkat.

Edited by: Venkat A on Jul 8, 2009 12:54 AM.

Re: data type xsd:decimal

prasannakrishna_mynam — Wed, 08 Jul 2009 06:37:52 GMT

Hello Venkat,

While converting xsd:decimal to ABAP's DECIMAL type, the source decimal has condition like Decimal with fractionDigits<=14, totalDigits<=31, It has specified in sap help. If the source xsd:decimal is with in this limits then only it'll convert into ABAP's DECIMAL type. For xsd:int there is so such conditions or limits to convert, that is the reason why xsd:int to ABAP INT conversion works fine in your case. For xsd:decimal other than the specifid range it might convert into String, perhaps that was what hapnning in your case,it's not bug.

Regards,

Prasanna

Re: data type xsd:decimal

Former Member — Thu, 09 Jul 2009 21:54:10 GMT

any specific reason for this condition?

If I want to have a range higher or lesser than this?

There is no point declaring decimal for which SAP transforms and sends string .

Can you please provide me the exact link?

Many thanks,

Venkat.

Re: data type xsd:decimal

prasannakrishna_mynam — Fri, 10 Jul 2009 05:13:22 GMT

Hi Venkat,

The reason behind this, i don't have idea, you can refer the below link where the conversion range has specified.

http://help.sap.com/saphelp_nw70/helpdata/en/de/705c3c3806af06e10000000a11402f/content.htm

Regads,

Prasanna

Re: data type xsd:decimal

Former Member — Fri, 10 Jul 2009 12:01:59 GMT

thanks Prasanna.

hello experts, does any one know why string value is declared as ABAP type for decimal value lying outside the specified range?

Thanks,

Venkat.

Re: data type xsd:decimal

Former Member — Fri, 10 Jul 2009 12:18:55 GMT

Hi venkat ,

31 Digits of decimal with 14 decimal digits would give you the possibility of handling a number as big as

9999999999999999.99999999999999

In real life scenarios, i do not think anyone would be dealing with such astronomically large values, unless you are dealing with the weight of earth or the distance between stars ..:) and 14 decimals of precision is also very rare, unless you want to measure the diameter of an atom or something...

I know my answer is based on the premise of common sense, I would wait along with you for a more technical answer.

Regards,

Ravi Kanth Talagana

Re: data type xsd:decimal

Former Member — Fri, 10 Jul 2009 13:47:47 GMT

here in my scenario, it would be sufficient to deal human weight only... Hence, i dont need such a huge numbers

I wasnt aware of this fact about pi decimal to abap string and declared the field as "decimal"only without any range for which ABAP type was string which is not processing if we send decimal values.

Venkat

Re: data type xsd:decimal

Former Member — Fri, 10 Jul 2009 14:01:34 GMT

Hi venkat,

When you say "Not processing" what exactly is happening?

By the way, this a server proxy correct?

So, when you send a decimal value from XI to the Proxy, then it is treated as a string and what happens next?

Regards,

Ravi

Re: data type xsd:decimal

Former Member — Fri, 10 Jul 2009 16:49:30 GMT

MONI, RWB Mesg monitor - shows succesful.

The CC shows :

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException

Scenario 1:

with XI - Decimal ABAP - String - Error message as above

Scenario 2:

with XI - Decimal ABAP - String - on PI for decimal fields I did a UDF with parseFloat.

Result : working

Scenario 3:

With PI- Decimal ( with total digits and fractions ) , ABAP - DEC .

without above UDF in PI

Result : Same error message

Scenario 4:

With PI- Decimal ( with total digits and fractions ) , ABAP - DEC .

with above UDF in PI

Result : Same error message

Only scenario 2 is working now.

I am confused to trade the exact problem.

Re: data type xsd:decimal

Former Member — Wed, 27 Jan 2010 14:31:50 GMT

Standard definition of xs:decimal is unlimited number of digits. So to properly convert xs:decimal type for all cases, you would need to use String type, because ABAP decimal type has limitations.