Skip to Content

Confirmed quantity field

Dear Guru ,

We are developing an abap program that can do the the production order confirmation ( like CO15 ) .

In order to calculate the open quantity ( "Current to Confirm" field in CO15 ) , we need the "Already Confirmed" field .

Is the "Already Confirmed" field saving in table "AFRU" ? I saw there have two fields : GMNGA & LMNGA , But i am not sure which one can be used .

And i am also not sure the relation-ship between AFPO & AFRU , because in my abap program , i only have the production order number as a parameter .

If i search the record on AFRU table with production order number , the performance will be very bad ... Does another solution can improve the performance ?

Many thanks .

Best Regards,

Carlos

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    May 18, 2010 at 05:11 AM

    Thanks S.

    Does SAP provide the standard function module for the open production order quantity ?

    Thanks again .

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Carlos,

      There is no fuction module for check open order quantity. You can check into Table AFKO. Put your order no. and it will give you the quantity already confirmed ( Field Name : IGMNG).

      Fuction Module to create confirmation: BAPI_PRODORDCONF_CREATE_HDR

      Hope it soles your problem

      Thaks,

      SISL !!

  • May 18, 2010 at 03:10 AM

    Can i use below code to get the production order open quantity ?

    * Get Confirmed Qty 
     select sum( LMNGA ) into cur_openqty from afru
             where
                 AUFNR = i_afpo-aufnr
               and
                 stokz = ' '
               and
                 stzhl = ' '.
    
    * Total Qty - Confirmed Qty
        cur_openqty = i_afpo-psmng - cur_openqty .
    

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 18, 2010 at 04:36 AM

    Hi Carlos,

    As AFRU is the confirmation table for production/Process orders. and if u want to use the order confirmation from some ABAP development then u should use AFRU for the quantity field.

    Are u using any fuction module for this?

    AFPO is just the Order item table, that u can use to verify the production order no. but not the confirmed quantity. Use the field "GMNGA" and also take care of the reversal too.

    Thanks,

    SISL !!

    Add comment
    10|10000 characters needed characters exceeded