on 12-26-2014 12:49 PM
Dear Expert,
We have a new PO smart form requirement to pick the amount ( 11 EUR from in below example) from the condition type "Net value incl. tax" which is having dependency on other pricing condition like PB00, NAVS etc.,
from the functional team prospective we need to provide table level information to the programmer on how this amount needs to fetched. While checking for the table info I found below
Field Data
Table Name KOMV
Table category Struct.
Field Name KBETR
Data Element KBETR
Also understand table "KONV" holds data of condition type. How can the abap team fetch this (11 EUR) to the new smart form.? with reference to what table.? Kindly suggest
Display view "Procedure" overview
Display tab from the purchase order
Thanks
Jenny
Dear Jennifer,
Kindly pass your PO number to EKKO table and fetch the Document condition from KNUMV, then pass the KNUMV value into KONV and take the value for corresponding condition types.
Regards,
Karna J
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Jennifer,
The subtotal values are not stored in KONV as Prasoon has mentioned above. If you follow his option 2 above (ie maintaining a subtotal in the pricing procedure against this subtotal line), you will get the value directly in EKPO. There are many subtotals you can play with (see the screenshot); each of these store in a different field in EKPO.
If you want a more convoluted option, use Prasoon's option 3 of a statistical/dummy condition type replacing the subtotal line in the pricing procedure. This will store the values in KONV against this condition type.
Thanks.
Hi,
As you are already aware, the condition table KONV will store the price details with condition types only. If you need the price calculated as subtotal in the PO (without condition type), you may check the below options:
1. Check with functional consultant, how the "Net value incl. Tax" is calculated in the PO. The value will be calculated based on the condition types only. You may pull the respective condition types from KONV and do the same calculation in the driver program.
2. Do a slight modification in the PO pricing procedure to add a subtotal (say subtotal 5) against the required line in the PO.
Now, create a new PO and save. The value of the above field will be directly saved in EKPO table (EKPO - KZWI5 based on the subtotal). Please check the impact of the subtotal used, before proceeding.
3. Create a new dummy statistical condition type (% calculation) and maintain the access sequence as purchase organization or similar. Maintain the condition type in the pricing procedure and maintain the from and to for the new condition type as the step number of the net value line. Maintain the condition record for the condition type as 100% in MEK1. Now, create a new PO and check - the value of the net value line will be stored in KONV table with the dummy condition type.
Please check and revert back.
Regards,
AKPT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
All the pricing in PO can be fetched by using the Function module " PRICING" in SAP.
Regards,
Prakash.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.