Skip to Content
author's profile photo Former Member
Former Member

Release Strategy in PO based on total value of invoicing plan

Hello,

I have the requirement to implement the purchase order release strategy based on the total value in a framework order with invoicing plan.

SAP standard uses the price in the line item and not the sum of the dates in the periodic invoicing plan.

There are already several threads regarding the same topic, but in none of them I found a feasible solution.

I tried to use user exit ZXM06U22, but the invoicing plan data is not available there (after saving it is stored in table fplt, field netwr). Where can I find the invoicing plan information before saving and use it for the release strategy?

Thank you and kind regards,

Christine

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Oct 12, 2015 at 05:15 PM

    Hello Christine,

    try function module ML_INVOICING_SCHEDULE_READ using the EKPO-FPLNR as input field.

    At creation time, the entry starts with a $.

    best regards,

    JNN

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Jacques Nomssi Nzali

      Hello Jacques,

      I tried this now and it works perfectly. Thank you very much!

      Using the function module ML_INVOICING_SCHEDULE_READ I can determine the invoicing plan data of the whole PO. If I sum up the lines of table fplt_bt then I get the total value (invoicing plan data for deleted line items in the PO need to be excluded explicitly - they are contained in table fplt_bt.

      Thank you and best regards,

      Christine

  • Posted on Oct 13, 2015 at 12:43 AM

    HI Christine

    There is possibility that you can calculate the value and pass it to custom z-field in CEKKO structure using release exit available for purchase orders

    - Add new Z field to CEKKO structure

    - Calculate the total value and pass the value in the z field added in first step

    Make sure you create release strategy with reference to Z field added in the CEKKO structure.

    Thanks,

    Jagdeep

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Jagdeep,

      in the exit for release strategy I don't know how to determine the value of the invoicing plan. Otherwise I agree it would be no problem to add a new Z field for CEKKO and then pass the value. But the data of the invoicing plan is not available in the exit ZXM06U22.

      Thank you for any further ideas.

  • author's profile photo Former Member
    Former Member
    Posted on Dec 11, 2015 at 10:27 AM

    Hello,

    in the end we added a new field renetwr for the total of the invoicing plan in the structure cekko. Based on this field the release strategy is found. In addition, we set the standard field cekko-gnetw to the total including the total of the invoicing plan (in our case, all purchase orders of order type "FO" are used with invoicing plan for every item). By doing this, the field ekko-rlwrt is populated with the value relevant for release (and not only the "normal" net value of the item) and also e.g. a new release is triggered if the PO is changed and additional dates are added.

    data: z_sum type p decimals 2,

    z_total type p decimals 2.

    data: FPLT_itab type table of FPLTVB,

    wa_fplt like line of fplt_itab.

    clear z_total.

    clear z_sum.

    clear fplt_itab.

    refresh fplt_itab.

    loop at it_bekpo into ps_bekpo where fplnr <> '' and loekz = ''.

    CALL FUNCTION 'ML_INVOICING_SCHEDULE_READ'

    EXPORTING

    FPLNR_IMP = ps_bekpo-fplnr

    TABLES

    XFPLT = fplt_itab.

    loop at fplt_itab into wa_fplt where fplnr = ps_bekpo-fplnr.

    z_sum = wa_fplt-fakwr + z_sum.

    endloop.

    * z_sum: sum of invoicing plan for one item

    * z_total: sum of invoicing plan for total PO

    z_total = z_sum + z_total.

    clear z_sum.

    refresh fplt_itab.

    clear fplt_itab.

    endloop.

    if z_total > 0.

    e_cekko-renetwr = z_total.

    if i_cekko-bsart = 'FO'.

    e_cekko-gnetw = z_total.

    endif.

    endif.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 12, 2015 at 05:56 PM

    Hi,

    Before designing PO Release Strategy- Can you share where you store or entire total value of invoicing plan?

    If you go for Release Strategy of total value of invoicing plan- how handle Release Strategy for other PO types? Are you going to use one Release Class for PO or two Release Classes for PO?

    You can go ahead of designing PO Release Strategy based on PO NET PRICE( standard-without development) or based PO EFFECTIVE PRICE.(with development))

    PO NET PRICE= Material Gross price - Discount

    PO EFFECTIVE PRICE= Material Gross price - Discount + Delivery cost + Insurance +Tax

    Regards,

    Biju K

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Bijay,

      exactly that is my main problem - I don't know where to find the total value of the invoicing plan while creating a PO. After saving the values are stored in table FPLT, but in user exit ZXM06U22 i don't have the values availble.

      Thank you for any further ideas.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.