Skip to Content

Does anyone know the table where the field "Product Price" of bills of materials is stored?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 13, 2017 at 09:34 AM

    Hi Raúl,

    the price is stored in the Price List, defined in the bill of Material. In your case it's the price list "07 - Costes de..." (the full name is not visible on the screenshot). So, what you need, is:

    select Price from ITM1 where ItemCode = 'Z14A' and PriceList = (select ListNum from OPLN where ListName = '07 - Costes de...')

    Add comment
    10|10000 characters needed characters exceeded