Creating Functions in SQL server

[#1]

HI

i creating functions for specific purpose in the test database...

is it against SAP Support policy?

suggest me...

[Former Member]

Hi,

You can do so only in test database. However, in production db, you can not create such function or SP.

If the fields have the same type, you do not need to change anything. "," in the numeric field is only by a display format. It is not physically there.

Thanks,

Gordon

[Former Member]

HI Gordon & Manvendra

In database also,The udf is storing with ","...

is it possible to assign FMS to UDF which has Type "numeric"?

I tried but it not displaying FMS?

and also i am not able to convert UDF datatype "nvarchar" to "numeric or decimal" ...

I used "cast" function for the conversion which works at backend but at front end its showing the error as

[Microsoft][SQL Server Native Client 10.0][SQL Server]Error converting data type nvarchar to numeric. (CINF)

Please suggest me to solve that...

[Former Member]

Hello,

Make a new UDF with same name and make it Numeric and remove last one.

$[ORDR.DocTotal.Number]

if we write number in sentex then by default FMS pick only number.

Thanks

Manvendra Singh Niranjan

Edited by: Manvendra Singh Niranjan on Jun 29, 2011 7:32 AM

[Former Member]

HI Manvendra

I tried that but unfortunately the FMS is not working when i create in the UDF type "numeric"?

I am not able to see the thet FMS icon when i set automatic FMS...

Edited by: kambadasan on Jun 29, 2011 7:35 AM

[Former Member]

GOTO View >Picker Display select all option

And

GOTO View >Indicator Display

Thanks

Manvendra Singh NIranjan

[Former Member]

HI Manvendra

After defining the UDF as type "Numeric" and applied the below FMS

SELECT T0.[Price]   from itm1 T0  WHERE T0.[PriceList] =1 and  T0.[ItemCode] =$[POR1.ItemCode.0]

It showing the error as "Invalid Numeric value"

[Former Member]

Thanks