topic Re: Production Orders in Application Development and Automation Discussions

Production Orders

Former Member — Thu, 21 Sep 2006 01:52:05 GMT

How do I get the latest production orders for the whole work week except for the current week. I'm looking at table afpo, afko, mseg and mkpf.

Re: Production Orders

Former Member — Thu, 21 Sep 2006 04:28:24 GMT

put like this

  select afru~wablnr as mblnr          "Material Doc. no.
         afru~werks                    "Plant
         afru~aufnr                    "Order no.
         afru~iedd  as budat           "Order Posting Date
         afru~budat                    "Order Posting Date
         afru~lmnga
         afru~stokz
         afru~vornr
         afpo~matnr                    "Material no.
         afpo~wemng                    "Net.QTY "Prabhu 5.5.5.
    into corresponding fields of table t_fert
    from afru
    inner join afpo
      on   afru~aufnr = afpo~aufnr
    where  afru~budat  in s_budat
    and    afru~werks  in r_werks
    and    afru~wablnr ne space
    and    afru~stokz  ne 'X'           "Document not cancelled
    and    afru~stzhl  = '00000000'
    and    afpo~matnr  in s_matnr
    and    afpo~pwerk  in r_werks. "Prabhu On 1.1.2005

Regards

Prabhu

Re: Production Orders

Former Member — Thu, 21 Sep 2006 04:29:52 GMT

You can get the confirmed latest orders in AFRU table.Sort the resuts by RMZHL descending.