Udf column value is coming as blank when opened through Query

[Former Member]

Dear All

We have created an udf in SAP B1....and linked an UDT to that with code & name.

and the values are Entered in to it. But when we open the item master data though a  Query tis filed is coming blank.

In the udf its showing the name from the udt...but in the system information it is showing the code....

Further to that if we are using Query to fetch some data from those udf.it shows null where the data is actually present.

Regards

Shyam

[Former Member]

Dear Shyam,

Without your actual query posted, we may not be able to answer your question.

Thanks,

Gordon

[former_member218051]

Hello Shyam,

When u link a UDF to the UDT, you don't have to enter the value.

U can select the value from a drop down.

After assigning a value from the drop down the code goes into the field. If you want to have name associated to it then you have to frame a query and join the udt on code field.

Thanks

[kjetil_sandvik2]

Hi,

have you checked that the "Refresh Regulary" in the User-Defined Values Setup is not ticked? If this is set to yes the UDF will be updated with correct values based on the FMS, but this is not being saved unless you make some changes to the item in Item Master Data. That could be the reason why your query is showing no values in this field.

Kjetil

[Former Member]

Hello,

In a UDT two columns come by default (code and name).  The name of that column whose details you want to save in the item master should come first in the query. e.g. select name from @xyz ....  Also don't give any refresh option if you want to save the data to the item master.

Hope that helps,

Thanks,

Priya

[kothandaraman_nagarajan]

Hi,

Please post query here.

Thanks & Regards,

Nagarajan

[Former Member]

Hi

attached a sample Query for reference.Actually the particular data is present in the table but not visible in the Query.

Tried with empty spaces as well but no result.

Regards

Shyam

[kothandaraman_nagarajan]

Hi,

Add [dbo].[@Des_Name] and then try.

Regards,

Nagarajan