Formatted Search query
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
Gilbert Ngo replied
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.