cancel
Showing results for 
Search instead for 
Did you mean: 

how to calculate ex wprks price for a Purchase Order

former_member185116
Active Participant
0 Kudos

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..

Accepted Solutions (0)

Answers (5)

Answers (5)

former_member185116
Active Participant
0 Kudos

hi raymond,

thanks for your reply,

unfortunately there is no table KOMV , its only a structure

raymond_giuseppi
Active Contributor
0 Kudos

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

former_member185116
Active Participant
0 Kudos

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..

former_member185116
Active Participant
0 Kudos

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.

JL23
Active Contributor
0 Kudos

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

JL23
Active Contributor
0 Kudos

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.