Item Master Data - Unit Price

[Former Member]

Hi all,

In the window Item Master Data, I need the unit price for the selected item in a query.

Anybody know how to make it?

Oitm = Item Master Data

OPLN = Price list

[Former Member · Accepted solution]

+Chief wrote:

<<Hi all,

In the window Item Master Data, I need the unit price for the selected item in a query.

Anybody know how to make it?

Oitm = Item Master Data

OPLN = Price list>>+

Hello Chief,

The price are stored under ITM1.

SELECT

T0.ItemCode,

T1.ListName,

T0.Price,

T0.Currency

FROM

ITM1 T0

INNER JOIN

OPLN T1 ON

T0.PriceList = T1.ListNum

WHERE

T0.ItemCode = 'XX'

KR

Murielle

[former_member583013]

Could you be specific or give an example of what " unit price for the selected item in a query" means?

[Former Member]

Sorry for that, what i want is that the customer want to print the item with the following informations: itemcode, itemname, etc. from the table OITM and also the price.

But the price is from the pricelist, i don't know how to get the unit price...

Thanks in advance,

Chief.

[former_member583013]

By Unit Price are you referring to the Cost / the Price stored in any specific price list. If it is the pricelist, let me know the pricelist number.

You can actually use the Query from Murielle

Suda