Skip to Content

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

Formatted search - price

Hi all experts.

Can someone please provide me with a formatted search that fetches the price from the price field on item master data and selects it into a UDF on OITM.



Former Member
Former Member replied

Create a UDF in the Item Master and assign the following 'Formatted Search Query' to the UDF:

SELECT T1.[PriceList], T2.[ListName],  
T1.[Currency], T1.[Price] FROM [dbo].[ITM1]  T1
 INNER JOIN  OPLN T2 ON T1.PriceList = T2.ListNum 
where T1.itemcode=$[oitm.itemcode]

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