Skip to Content
0

how to calculate ex wprks price for a Purchase Order

Nov 29, 2016 at 11:28 AM

110

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Jürgen L
Nov 29, 2016 at 03:07 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
VINAY REDDY Nov 30, 2016 at 06:09 AM
0

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.

Show 1 Share
10 |10000 characters needed characters left 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

0
VINAY REDDY Nov 30, 2016 at 06:37 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Raymond Giuseppi
Nov 30, 2016 at 07:46 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
VINAY REDDY Nov 30, 2016 at 10:06 AM
0

hi raymond,

thanks for your reply,

unfortunately there is no table KOMV , its only a structure

Share
10 |10000 characters needed characters left characters exceeded