Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Find ItemCode by using search code

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

Former Member
Not what you were looking for? View more on this topic or Ask a question