Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Column ID of a UDF

Does anyone know how to reference a column id of a UDF in a formatted search?

Say you have a UDF called "netprice" on the marketing document line level. You could reference this new field as 'rdr1.u_netprice' in a formatted search on a sales order no problem. However, this implies having multiple queries for the same formatted search if you want to use it on Quotes and Deliveries, etc.

Is there any way you can reference the screen column of a udf, like in '$38.1.0', where the latter is the itemcode? I have tried with '$38.u_netprice.0' but that doesn't work. What is the correct syntax?

Is there any other ways of doing this?

PS I have omitted the dollar square brackets above because they translate into http:// on this forum

Thanks

Steven

Edited by: Steven Delombaerde on Sep 4, 2008 2:43 PM

Former Member replied

Hi Steven,

Where do you get those netprice for these UDF?

It your U_netprice is on the item master, then it will be very easy. You can use something like:

where itemcode = $[$38.1.0] 

from oitm table.

Otherwise, you may have to refer to different tables by different FMS.

Thanks,

Gordon

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question