Skip to Content

how to calculate ex wprks price for a Purchase Order

hello all,

in me23n for a given PO

i want to get the Ex-works price ,

is ex-works price equal to NETPR field in EKPO table and Net value(here marked in red color 353.97 Inr) equal to EFFWR field in EKPO table , i want to clarify on this,

or is there any FM from where i can get ex-works price and unit price.

and NETPR = EFFWR / MENGE

is my inference correct. does this always true or is it going to change based on any tax code or some thing else.

thanks in advance..

me1.jpg (285.9 kB)
me2.jpg (140.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Nov 29, 2016 at 03:07 PM

    I would recommend to check the calculation schema T-code M/08 or path SPRO-IMG-MM-Purchasing-Conditions-Define Price Determination Process-Define Calculation Schema

    Because here is defined which conditions are used from the initial price to the net value subtotal.

    and then do a test in your test system, add a price as in your example for condition P000 (which is named gross price in my system) and then add one of the other condition from your calculation schema along with a value to see how the values develop in table field EKPO-EFFWR and in the net value field in the condition tab.

    If you only have a single condition (P000) in your calculation schema then it might be as straight forward as you assumed, if you use further conditions you might be surprised.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 30, 2016 at 06:09 AM

    hi jurgen

    thanks for your reply,

    can i come to a conclusion that Ex-works(P000) is equal to NETPR field in EKPO table.

    regards,

    vinay.

    Add comment
    10|10000 characters needed characters exceeded

    • as I said, it is depending on the calculation schema and the used conditions in the purchase order. If you are on a training system which has not any complexity then your conclusion might be right, in my system your conclusion would be wrong

  • Nov 30, 2016 at 06:37 AM

    yes jurgen,

    your right some times its varying..

    need a small clarification though,

    so the appropriate table to get ex-works price and total price is KOMV table .

    am i correct.

    KOMV- KBETR = ex works price

    KOMV-KWERT = total price.

    do i need to use these fields..

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 30, 2016 at 07:46 AM

    Try to call BAPI_PO_GETDETAIL1, then look at returned table parameter POCOND for records where COND_TYPE = 'P000' (or select from table KOMV if performance problem for high volume of data)

    Regards,
    Raymond

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 30, 2016 at 10:06 AM

    hi raymond,

    thanks for your reply,

    unfortunately there is no table KOMV , its only a structure

    Add comment
    10|10000 characters needed characters exceeded