on 11-29-2016 11:28 AM
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..
hi raymond,
thanks for your reply,
unfortunately there is no table KOMV , its only a structure
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
69 | |
14 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.