cancel
Showing results for 
Search instead for 
Did you mean: 

Do Gateway generator tools + BDC publisher support Query with input filter?

Former Member
0 Kudos

Hi,

Our use case is the following:

1) Application: Retrieve via Query on GW-model of SAP entity 1 all values of source table; and display in SharePoint external list

2) User: selects a value in List

3) Application: Retrieve via Query on GW-model of SAP entity 2 all values of related table, filtered / selected on value user selected

For 3 we have a RFC with input parameter. We however do not succeed in mapping this input parameter such that it appears in the signature of the generated Duet Enterprise web service. When we test that service in SProxy, the request signature is as follows:

<no:Z....>

<IS_INPUT>

<VALUE>String 1</Value>

</IS_INPUT>

<IV_BCSCORRELATIONID>String 2</IV_BCSCORRELATIONID>

Gateway and Duet Enterprise documentation is very scarce on this, but what is written indicates that it should be possible (although only described for BOR generation)

Best regards, William.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Question positively answered with thanks to Girimurugan, architect of Duet Enterprise / SAP Gateway product team.

Yes GW generator tools support input params for Query operation.

We did something wrong within the Change Mapping Route; we had an initial constant value defined for the input param. In such case, the GW tools assume that there is not mapping parameter in the GW model, the reason why the Mapping route column is empty.

When we corrected that, and selected the root node when defining the mapping for the input param; the GW model includes it as input parameter.

Successively the generated BDC model contains the input param as filtered type; and created ExternalList on basis of the External ContentType expose a Filter for the same input param.

Effectively this makes it possible to control from SharePoint context for what SAP key the GetList must return data.

We use this to navigate from a SAP source entity (GW-model 1) displayed in ExternalList 1, to related SAP entity information on another page and displayed via another external list (to different GW-model).

Regards, William.