Skip to Content
0

Consume XS oData Service (with CalculationView) in SAP Gateway via Transaction /IWBEP/OCI_SRV_GEN

Oct 24, 2016 at 09:10 AM

189

avatar image

Hello and good morning wxperts,

System:

SAP_GWFND - 740 - 0014 - SAPK-74014INSAPGWFND - SAP Gateway Foundation 7.40

SAP HANA SPS 12


I have a severe problem with consuming a HANA XS oData-service in SAP Gateway, that embeds a CalculationView with several input-parameters as follows:

service {
"playground.USERNAME::CV_AS_SEARCH_COMBINED" as "ArticleSearchList"
keys generate local "ID"
parameters via entity;
}

When i call the Service in my Browser i get a nice and wonderful response with the Data I wish to have, all the parameters work as designed.

In the metadata of the Serivce in the browser I can see the automatic generated key:

[...]
<EntityType Name="ArticleSearchListType">
<Key>
<PropertyRef Name="ID"/>
</Key>
<Property Name="ID" Type="Edm.String" Nullable="false" MaxLength="2147483647"/>
[...]

Out of reasons of single point of entry and hiding the HANA etc. we want to "route" all oData-Services including this one over our SAP Gateway System.


So naturally I use the OSCI - Feature of SAP Gateway and want to generate the Gateway-Service out of the defined HANA XS oData-Service via transaction

"/IWBEP/OCI_SRV_GEN"

Connection to HANA is established in SM59, and the service generates beautifully.

When i want to activate the Service via

"/IWFND/MAINT_SERVICE"

the system generates a Shortdump:

The problem is the length of the automatic generated OData-Key in our Unicode System. The Calculation View doesnt have a unique key, so I think I have to generate it in the oData definiton.
Any Ideas how I can resolve that?

If any further information is needed, just tell me and I will provide.

I really hope you can help me.

Best wishes

Martin

en-1.png (46.0 kB)
en-23.png (43.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers