FMS Query for Production Order from Item master Data

[former_member599281]

Hi Expert,

I created two UDF's one in Item Master Data header Level(i.e. Ref Code) and another one in Production Order Row level (i.e.Ref Code) .

In item master data If i'm selecting one Item from list and entering some value in Ref Code (UDF) suppose (abc) and adding this item,  after that i'm going to Production order  Row level if I'm selecting same Item here also then Ref Code(UDF) field should pick up same value (abc) .what is the FMS Query for this ....??

Thanks

[former_member184146 · Accepted solution]

select u_ref from oitm where itemcode=$[WOR1.itemcode]

--Manish

[former_member599281]

Thanks

Manish k