Skip to Content

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

Formatted search - price/pricelist

Hi.

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
replied

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

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