Skip to Content

How to get price used on issue for production in SAP B1?.

Hi all,

I want to do a query of production process where I will select quantity and price used on issue for production, I want to know how to get that price because I do know if it has table where it is saved or if it is calculations.

How can I do that in SAP B1?

Please anyone can help me.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Feb 02, 2017 at 10:59 AM

    Hi

    you can use stockprice or inmprice fields.

    Kind regards

    Agustín

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 02, 2017 at 09:04 AM

    Hi

    the table is IGE1, and you have to filter by:

    basetype = '202' and baseentry = yourworkorder.docentry

    Select quantity and price.

    Kind regards

    Agustín

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 02, 2017 at 09:32 AM

    Hi,

    Try this,

    SELECT T0.[DocNum], T0.[DocDate], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[Price] FROM OIGE T0 INNER JOIN IGE1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE T1.[BaseRef] = 154 (This is your production order number)

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 02, 2017 at 10:04 AM

    Hi,

    Maybe u need to check Item Costing for the price

    Regards,

    -Eric-

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 02, 2017 at 10:07 AM

    Above query will show price regardless of issuing method.

    Add comment
    10|10000 characters needed characters exceeded