PriceList Name on Item Master Screen
SELECT T0.ItemCode, T1.PriceList, T2.ListName, T1.Price
FROM OITM T0
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.
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.