Query including description of a UDF

[Former Member]

I have created the below formula, with a UDF U_Transpor. It is bringback the value number, but I require the description.

SELECT T0.DocNum, T1.CompnyName, T1.CompnyAddr, T0.CardName, T0.Address2, T0.U_PalDkt, T0.U_Transpor FROM OINV T0, OADM T1 WHERE T0.DocNum =[%0]

The table is UFD1 and the column required is descr.

How can i get this to integration into my formula?

[former_member583013]

Lisa,

Is the UDF U_Transpor in OIN linked to a UDT from where valid values are being selected or how is this UDF defined and what are the values.

Out of curiosity I would like to ask what is the relation between OADM and OINV in your query?

[Former Member]

Hi Lisa ,

This thread will solve your problem

There are two kinds of solution provided

Hope this helps

Bishal

[former_member186095]

Hi Lisa,

There are 2 possible solutions :

1. The UDF transpor field data type is alphanumeric and structure is text

2. Create a UDT that records the U_Transpor value and description. Using a certain UDF like U_transpor, you set linked table to the UDT in the field data of the UDF U_transpor.

Rgds,

[Former Member]

Hi Lisa,

What is the relationship between your UDF U_Transpor and UDT UFD1? Is the column descr related to U_Transpor? You must have map these two fields to bring the description back.

Thanks,

Gordon