IndoTech
26th September 2017, 12:04
Hi All

How to compare CDF fields of table and get other fields data?
e.g
select tisfc010.pdno, tisfc010.opno
from tisfc010
where tisfc010.cdf_orno = :r.po.no
and tisfc010.cdf_pono = :r.po.pos
selectdo
r.prod.ord = tisfc010.pdno
r.prod.pos = tisfc010.opno
endselect

for me it shows compile error - column not found tisfc010.cdf_orno

Regards
Kedar

JaapJD
26th September 2017, 14:06
Ensure your script VRC is integrated with the package combination for which you defined the CDFs.