Skip to Content
author's profile photo Former Member
Former Member

Simple Read Operation

After looking through the developers guide, is it possible to simply just do a Read operation verus a Query and subsequent Read operation? Having a hard time finding any documentation around a simple scenario like where a user wants to type in an employee number and retrieve their individual details.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Jul 22, 2011 at 04:30 AM

    Hi Rory,

    You will be able to do Read operation with Query operation if you are can generate a key, which will be used by NW SCL system to identify an object. In normal flow, Query operation will return this unique key for each object in and this key will be used for subsequent read operation.

    In developeru2019s guide, page 64, you will be able to see following code snippet. Here we are populating /IWFND/S_COR_ID structure to fetch sales order details.

    • Populate the GSDO key structure, every GSDO instanc requires a unique key like this

    ls_key-value = ls_response_rfc_sales_order-sd_doc. "Sales Order Number

    ls_key-scheme_id = 'ZSALES_ORDER_HEADER'. "this is the GSDO type name ls_key-scheme_agency_id = iv_system_alias." this is the System Alias to the Backend u2026

    Like this if you are able to set key for GSDO objects, then you will be able to do read operation without query operation.

    Regards,

    Binson

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 31, 2011 at 08:42 AM

    Hi Rory,

    As on the Microsoft side, Duet Enterprise is dependent on Business Connectivity Services [BCS], it has to comply to the minimal BCS requisites for connecting to an external system. BCS requires at minimal both a ReadList / Finder operation and ReadItem/SpecificFinder operation, which on the SAP Duet Enterprise Add-on side are connected to via Query and ReadItem webservices.

    For some more details, see a.o. following postings:

    Best regards, William.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2011 at 01:52 PM

    Thanks William and Binson. Yes, as I dove more into the documentation I noticed this requirement. Its a pity about this restriction, as I do find it somewhat of a "clunky" way of doing things in my opinion.Seems as though you are now forced to do two queries into the SAP backend system when based on certain requirements, all could be done with one call.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Rory,

      As already pointed out, Sharepoint Out of the Box components mandates that you have both your Read / Finder operation defined.

      But you can attain the desired result, that of having only a read method to query the SAP BE, by creating custom solution.

      You can use the BCS object model to invoke the read method directly. Needless to say , you will have to have your custom controls to display the data received.

      You can find more information on how to use the object model at the following location:

      [Code Snippets: Executing Methods Using the BDC Runtime Object Model|http://msdn.microsoft.com/en-us/library/ff464409.aspx]

      Thanks, Oyshik

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.