Skip to Content
avatar image
Former Member

New PO smartform requirement


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

CurrentPP.GIF (35.7 kB)
Requirement.GIF (17.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Dec 26, 2014 at 06:14 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.

      Subtotals.PNG (15.9 kB)
      EKPO.PNG (35.5 kB)
  • Dec 26, 2014 at 12:54 PM

    Hi,

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

    Regards,

    Prakash.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 26, 2014 at 01:49 PM

    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

    Add comment
    10|10000 characters needed characters exceeded