Automate

Welcome to the Automate community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  MD04 Query

    Posted 11-23-2018 07:30

    Hi,

     

    I have Studio V11. I am quite familiar with Transaction and Query. However I know nothing about Direct. I have a list of a few hundred materials that I need to pull the data that I see in MD04 (Reservations, Requisitions and POs that may be present). When I look at the technical information for the fields that I want to query they are not in tables but in structures. I feel that Direct is the way to go but I have no idea how to get started. I have no BAPI experience. Can someone tell me how to take the technical information that I see in the MD04 fields and turn that into a query in Direct?

     

    Thanks.

     

    Mark Doucette

    Materials Data Administrator, Procurement

    EAP Resource Team Member

    Sudbury Integrated Nickel Operations

    A Glencore Company

    ________________________________

     LEGAL DISCLAIMER. The contents of this electronic communication and any attached documents are strictly confidential and they may not be used or disclosed by someone who is not a named recipient.
    If you have received this electronic communication in error please notify the sender by replying to this electronic communication inserting the word "misdirected" as the subject and delete this communication from your system.

    MENTION LEGALE: Le contenu de cette communication électronique et ses pièces jointes sont strictement confidentiels et ne peuvent pas être utilisés ou divulgués par une personne qui n'est pas le destinataire désigné.
    Si vous avez reçu cette communication électronique par erreur, s'il vous plaît, veuillez aviser l'expéditeur en répondant à cette communication électronique en insérant le mot 'mauvais destinataire' dans le sujet et supprimer ce message de votre système informatique.
    ________________________________



  • 2.  RE: MD04 Query

    Employee
    Posted 11-27-2018 10:53
    Hello Mark, 
    I am not super familiar with the t-code itself but a quick google search led me to this remote enabled function module - MD_STOCK_REQUIREMENTS_LIST_API which looks like a good candidate to further explore. 
    There may be others as well, I generally start my search with the t-code BAPI for a list of published options. 
    Then I also search on google to find some function modules or APIs that are remote enabled but may not have been listed under official BAPIs. 

    To get yourself more familiarized with using DIRECT, I suggest this upcoming WUGinar on Dec 11 - https://more.winshuttle.com/181211_GLOBAL_Webinar_WUGinar_Direct_Registration-Page.html

    In the interim, there is a training course on DIRECT on our eLearning Portal - https://winshuttle.ancileuperform.com/gm/folder-1.11.1874

    Hope that helps you start, 
    Jayasri 




    ------------------------------
    Jayasri Varyani | Solutions Engineer
    Winshuttle North America |
    ------------------------------



  • 3.  RE: MD04 Query

    Employee
    Posted 12-06-2018 09:26
      |   view attached
    Hi Mark - 

    As Jayasri mentioned, the MD_STOCK_REQUIREMENTS_LIST_API BAPI is the one to go with.  I've attached an example Studio v11 version of a Direct-based script and excel.  You will need to provide a number of D rows, more than you think might be needed, so that you don't end up missing any of the line items.

    The one thing about this BAPI that won't be the most helpful is that you can only easily do this with one material number at a time, and I know that you have hundreds to do.  If you wanted to do hundreds, then you would need to provide an H row for each material and a fixed number of D rows for each material number underneath, which makes it kind of painful to format the sheet.  If you are handy with excel macros, you could create one that would populate the Ds for you.  

    Good luck!
    Jennifer

    ------------------------------
    Jennifer Hwang | SE
    Winshuttle North America
    ------------------------------

    Attachment(s)

    zip
    MD_STOCK_REQUIREMENTS_LIST_API.zip   371 KB 1 version