Skip to Content
0
Former Member
Apr 29, 2009 at 10:12 AM

Find ItemCode by using search code

172 Views

Hello,

As our ItemCodes are in general 15 characters, we want to use a short code to find the articles easier.

We have used the field Additional Identifier (OITM.SWW) in the Item Master Data for the short article code. Unfortunately this field you cannot select on row level (e.g. RDR1).

So when we are entering an order in our system we have created an UDF (U_Vartcode) on document row level where we can enter the short code and the Item Code appears automaticly.

We have added a Formatted Search in the Item Code field with the following query:

SELECT T0.ItemCode FROM dbo.OITM T0
WHERE T0.SWW = $[RDR1.U_Vartcode]

The query works fine, but the value we have entered disappears.

What would be the solution so that the value (short code - OITM.SWW) we have entered is still visible.

Best regards,

Tim