PSQUERY: Query results include Unused field(s), so not all marked fields included in SQL
Hi All,
Tried creating a PSQUERY using view CS_DOC_PURCF_SV in FSCM.
Selected all fields for display and the view sql tab not showing all the fields and when trying to save getting following message. View has 29 fields and selected all them but viewsql missing some of the fields.
Query results include Unused field(s) PRODUCTCLASS_FLDBUDGET_REFCHARTFIELD2CHARTFIELD3, so not all marked fields included in SQL. (139,585)
Any help appreciated.
Giri