Skip to Content
Former Member
Nov 23, 2009 at 06:53 PM

SO Item code field query


Dear Friends,

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