cancel
Showing results for 
Search instead for 
Did you mean: 

Simple Read Operation

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

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:

  • [Duet Enterprise development work plus applicability|http://williamvanstrien.blogspot.com/2011/03/duet-enterprise-development-work-plus.html]

  • [Working with complex SAP business entities in Duet Enterprise|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25112] [original link is broken] [original link is broken] [original link is broken];

Best regards, William.

binson
Advisor
Advisor
0 Kudos

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