cancel
Showing results for 
Search instead for 
Did you mean: 

New PO smartform requirement

Former Member
0 Kudos


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

Accepted Solutions (1)

Accepted Solutions (1)

former_member201529
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Dear Karna,

Info was much helpful.

the only open issue is how do we fetch the amount from Net value incl. tax which is a sub total and not the main condition type.

Thanks

Mahesh

former_member201529
Active Contributor
0 Kudos

Dear Jenifer,

You can take the total value while do the sum of KONV condition or take the total value from EKPO- EFFWR.

Regards,

Karna J

Former Member
0 Kudos

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.

Answers (2)

Answers (2)

Prasoon
Active Contributor
0 Kudos

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

prakashjasti
Contributor
0 Kudos

Hi,

All the pricing in PO can be fetched by using the Function module " PRICING" in SAP.

Regards,

Prakash.