rajesh.lch
16th March 2016, 19:36
Hi Gurus's,

Thanks in Advance. Upgrading LN to New Version, in this process we are planning to replace form fields with Udf fields. Please give a quick suggestion to find which form fields exactly we need to convert. and simple way to search those.At present we compared Vrc's and listed out form fields.


Regards,

Raj

NPRao
17th March 2016, 01:45
If you are using Oracle db, you can use the following query (use the appropriate schema/db-owner name) -

select t$cpac, t$cmod, t$cfrm, t$fldn
from ERPLN.tttadv301000
where t$cpac = 'tc' and t$cust = 'cust'
minus
select t$cpac, t$cmod, t$cfrm, t$fldn
from ERPLN.tttadv301000
where t$cpac = 'tc' and t$cust = 'stnd'