Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 30, 2011 at 07:56 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded