HI
i creating functions for specific purpose in the test database...
is it against SAP Support policy?
suggest me...
This function remove "," from the value...
i.e if the value stored as "1,000.00" then it will remove the comma and show it as "1000.00"..
It is an UDF value in POR1 table
please suggest...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
this DDF have any calculation on line total or Doc Total and only reporting purpose ?
if only reporting purpose then you can update or having calculation then cant do same.
One thing more you should work on Test database and after update made same transaction means purchase cycle and sale cycle for testing purpose.
Thanks
Manvendra Singh Niranjan
Hi
I have created one SP which will compare the UDF price(from ITM 1 table through FMS) with the 'price' field in POR1.
If its not equal then the SP will fire...
The SP is firing even when both values are equal...
This is because the "price" field doesnt contain "," but the UDF field contains "," so the SP firing...
Then i used many string functions,cast functions to make it work but it results negative...
so i thought of removing the "," using the user defined functions....
if you are just going to start entries then you can .
But i have posted then Use replace function in SQL
-
SQL Syntax:
REPLACE( string1, string2, string3 )
Parameters:
string1
Any character string or binary expression that can contain the string from string2.
string2
Any character string or binary expression. This string is searching in string1.
string3
Any character string or binary expression. This string replace all occurrence of string2.
May it will work
But what string i use asl replace in place of ","....
Hello,
I think you should change data type of your udf in numeric to nvarchar .
try this
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.