Skip to Content

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

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

Former Member
Former Member 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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question