Formatted Search query

[Former Member]

Hi all,

We have the following formatted search defined in OITM under Item Desc (foreign language):

-

---

SELECT T1.DocNum AS 'Doc No', T1.CardCode AS 'BP Code', T1.CardName, T2.ItemCode, T2.OpenQty AS 'Open Qty', T2.WhsCode

FROM [dbo].[ORDR] T1 INNER JOIN [dbo].[RDR1] T2 ON T1.DocEntry = T2.DocEntry INNER JOIN OITM T3 ON T2.ItemCode = T3.ItemCode

WHERE T2.ItemCode = $[OITM.ItemCode] AND T2.OpenQty > 0

-

---

When run, we get a pop-up window with the relevant information. My question is, is there a way to make the T1.DocNum something which can be drilled down on?

Thanks alot!!

Rajiv Agarwalla

G.Mckenzie & Co

[Former Member · Accepted solution]

Hello Rajiv,

I think only the Choose From List pop-menu is available in SAP. For me, the Choose From List is a user-friendly feature because you can find or search through codes.