Skip to Content
avatar image
Former Member

PriceList Name on Item Master Screen

Dear all,

SELECT T0.ItemCode, T1.PriceList, T2.ListName, T1.Price


INNER JOIN ITM1 T1 ON T0.ItemCode = T1.ItemCode

INNER JOIN OPLN T2 ON T1.PriceList = T2.ListNum

this query i get say eg ABC Item all the 10 price lists Names. But if you see in item master, Item ABC, you will see only one price list name displayed. How to get that name in the query for that particular item ABC. Since that is the default pricelist name displayed on Item master screen. How to get that name.



Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 02, 2008 at 07:12 AM

    use this query

    SELECT T1.[ItemCode],T1.[PriceList], T2.[ListName],  T1.[Price], 
    T1.[Currency], T1.[Ovrwritten], T1.[Factor] FROM [dbo].[ITM1]  T1
     INNER JOIN  OPLN T2 ON T1.PriceList = T2.ListNum

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I think you are misunderstanding the way price lists work for the items. There is no default price list for an item. There is only a default price list for a business partner. An item can have as many different prices as you wish. You may want to designate one price list as the "default" or primary price for all items, or - as others have suggested - create a UDF to specify a default price list for each individual item. But the way the price lists are displayed on the Item Master screen does not indicate anything. Usually the price list you see is just the first one in the alphabetical list. If you select a different price list, the display will stay with that price list as you scroll through the items. Close the window and re-open it, and the original price list is displayed.

      This behavior would be easier to understand if SAP displayed the price list prices for each item in a grid instead of a drop-down field. Usually a drop-down indicates that you need to choose one option. But in this case, all options are available at the same time, and you just select the one you want to see as you view or change the different prices.

      I hope this helps.