I would like to get some assistance in writing a query for the following scenario,
I have created a couple of UDF's in the BP master and linked them to U_Class table. This U_Class table is a OITM table.
Each BP master data has a vaue in the UDF.
ie U_Class_1 = 01
U_Class_2 = 02
When generating a SO I would like to run a FS in the Item code field validating the BP master UDF field's to the Item Master U_Class field and populate only the items that belong to that particular UDF's.
I would really appreciate if you could help me to write the query