Skip to Content

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

PriceList Name on Item Master Screen

Dear all,

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.

Regards,

Murtaza

Former Member
Former Member replied

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.

Marcia

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