Skip to Content

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

Formatted search - price/pricelist


I have the followin query:

SELECT T2.[Price] 
FROM [dbo].[OPLN]  T1 INNER JOIN ITM1 T2 ON T1.ListNum = T2.PriceList 
WHERE T2.[ItemCode] = 'A99' 
and  T1.[ListName] = $[OPLN.ListName]

This gives me an error when running it as a formatted search on the item master data. My intention is to filter the price by both item code and by the current price list name in the item master data.

Regards, Runar.

Former Member

What is the purpose of this UDF as the price is already available on the Unit Price field

Try using

SELECT $\[$-34.0.NUMBER]

0 View this answer in context

Helpful Answer

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