We can help. Together we learn....

Efficient way to retrieve Open Sales Order using FM SD_SELECT_SALES_DOCUMENTS

by Raju | Friday, April 15, 2011 in , , , , |


We are moving to a better and faster site SAPYard.com  (http://www.sapyard.com/).

The content has been moved to below link. Please visit it at your convenience. Thank you for all your cooperation.

http://www.sapyard.com/efficient-way-to-retrieve-open-sales-order-using-fm-sd_select_sales_documents/

10 comments:

  1. Biswa on June 22, 2011 at 10:56 PM

    Nice Blog.. Raju.. really helpful.. We might need this in our project when we do performance optimization

     
  2. Raju on June 23, 2011 at 12:03 AM

    Thanks Biswa.. :)

     
  3. Chinu on June 23, 2011 at 12:34 AM

    It's a real good one. Thanks Raju.

     
  4. Raju on June 26, 2011 at 9:57 PM

    Thanks Bhai.. glad that you all had a look at it.. [:)]

     
  5. Unknown on November 23, 2012 at 12:50 PM

    i tried that but its going into dump


    data:
    t_vbmtv type table of svbmtv_trvog.

    call function 'SD_SELECT_SALES_DOCUMENTS'
    exporting
    iv_trvog = '0'
    * IV_BSTKD = IV_BSTKD
    * IV_ZPAVW = IV_ZPAVW
    iv_vboff = 'X'
    * IV_VBALL = IV_VBALL
    tables
    t_vbmtv = t_vbmtv
    * LVBMTV = LVBMTV
    * I_VKORG_RT = I_VKORG_RT
    * I_VTWEG_RT = I_VTWEG_RT
    * I_SPART_RT = I_SPART_RT
    * I_MATNR_RT = I_MATNR_RT
    * I_KUNNR1_RT = I_KUNNR1_RT
    * I_VKBUR_RT = I_VKBUR_RT
    * I_VKGRP_RT = I_VKGRP_RT
    * I_AUART_RT = I_AUART_RT
    * I_ERNAM_RT = I_ERNAM_RT
    * I_VBELN_RT = I_VBELN_RT
    * I_AUDAT_RT = I_AUDAT_RT
    * I_WERKS_RT = I_WERKS_RT
    * I_ZPERS_RT = I_ZPERS_RT
    * I_DATAB_RT = I_DATAB_RT
    * I_ERDAT_RT = I_ERDAT_RT

     
  6. Unknown on November 23, 2012 at 1:02 PM

    please tell me why it is going into dump i need it urgently

     
  7. Raju on November 23, 2012 at 1:56 PM This comment has been removed by the author.  
  8. Raju on November 23, 2012 at 2:15 PM

    Hi Pranshu - I checked, there is no issue in data declaration.

    Can you please provide the details of the dump?

    Do you have huge volume of open orders in your system. In that case, the internal table may overflow. Can you please put some restriction in the FM, with date or /and order type or/and material or/and plant.

    Please let me know if this helps.

    Raju

     
  9. Jaibo on November 11, 2013 at 7:27 AM

    Hi, I tried to use it in SAP R/3 4.7 and that function does not exist... in what SAP version are you using 'SD_SELECT_SALES_DOCUMENTS'?

     
  10. Raju on November 11, 2013 at 10:14 AM

    @ Ubaldo Vega .. We are ECC 6.0..

     

Post a Comment

Subscribe to: Post Comments (Atom)

Categories