7 Replies Latest reply: Apr 14, 2011 12:58 PM by Ahsan Rizvi RSS

Pending Orders Report

Ahsan Rizvi
Currently Being Moderated

Dear Expert

 

We are into manufacturing industry & my M.D. wants to see All pending orders value-wise with Sub-Total and Grand-Total.

 

How can we export All pending orders in Microsoft Excel.

 

Anyone can help me to complete this task, as I am a Technical Consultant(BASIS) & I am not sure how to start this task.

 

Thanks in Advance.

 

 

Ahsan

  • Re: Pending Orders Report
    Venkatesh Yogesh
    Currently Being Moderated

    Hi,

     

    Create a query using table T16FS and EKKO.

     

    Join the table and use the fields release codes and release stratergy from table T16FS as inputs to extract the unreleased  PO's and its values.

    • Re: Pending Orders Report
      Ahsan Rizvi
      Currently Being Moderated

      Hi Venkatesh,

       

      Thanks for your reply

       

      Can you help me how to select fields to get the desired result?

       

      I will be very thankful to you for all your help.

       

      Regards

       

       

      Ahsan

      • Re: Pending Orders Report
        Venkatesh Yogesh
        Currently Being Moderated

        Hi,

         

        I believe  you are looking for a report to see the pending orders which are not approved.

         

        If So,

         

        Use transction SQVI to create a query.

         

        1.Join the tables T16FS and EKKO.

         

        2.Link the fileds Release groups and Release stratergy of both the tables T16FS and EKKO.Then come back from that screen.

         

        3.There will b 2 coloumns with list fields and selection fileds.

         

        Flag the selection fields indicator for release codes which you want to use as input parameter to extract the other details like PO,value etc.

         

        4.In the list coloumn select the fields which you want to extract.

         

        then execute you will get a screen where you need to input the Release code and execute it.

         

        Then the output with the fields choosen will be displayed,Which you can download it to excel.

  • Re: Pending Orders Report
    Senthil Palaniyandavan
    Currently Being Moderated

    Hi There

     

    I hope you are referring the Open POs as Pending orders,,do the following to get the details,,  (If not you can use the previous posting,,,)

     

    1.T Code: Me2m

    2.Provide the selection parameters & F8

    3.You will get the list of POs with open qty values

    4.List-Export-Sreadsheet-Download it to desktop

     

     

    hope it helps

     

    Thanks

    Senthil

  • Re: Pending Orders Report
    Deepak Kulkarni
    Currently Being Moderated

    Hi dear,

    Hope with pending POs u are reffering to Open PO.

    U can use ,ME2L,ME2M,ME2N enter selection parameter as WE101 along with plant if required you can enter document date also to get the open POs in perticular period and execute the report.

    Once the report is executed click on local file icon (controlshiftF9) -> Select option of spread sheet -> Then give the required location and file name for the data.

    Thus u will get the data in excel.You can set the total and subtotal options in excel as well as in SAP once the report is executed.

     

    Edited by: Deepak Kulkarni on Apr 5, 2011 4:00 PM

  • Re: Pending Orders Report
    Dishant Mistry
    Currently Being Moderated

    T code ME2L

     

    Plant:

    Scope of List :  ALV

    Selection Parameters: WE101

    Document Date: From To To Date

     

    You get all open PO spread sheet to Excel.

     

    Regards,

    Dishant

Actions