CDS Views in SEGW: mismatch of target 'EntitySet' and binding of association 'EntityAuxSet'

[former_member522662]

Hi all,

I am having a serious problem when creating a service implementation in SEGW, that causes the error written above: "mismatch of....".

Here is the CDS-View personal_Data, which is the basis for the entity, that was created in SEGW:

define view personal_Data with parameters pv_date: datum as select from lview_personal_data as pdata association[1..1] to v_i_it0000 as _infotype0000 on _infotype0000.pernr = pdata.pernr {

key pdata.pernr,

nachn,

vorna,

gbdat,

case when pdata.pernr like '5%' then 'X' else ' ' end as ist_extern,

$parameters.pv_date as date,

_infotype0000 } where

begda <= $parameters.pv_date and endda >= $parameters.pv_date

Infotype0000 looks like this:

define view v_i_it0000 as select from t_infotyp0000 {

key pernr,

key begda,

key endda,

stat2,

case when stat2 = '3' then 'X' else '' end as is_active }

An entity for each of them was created: an entity for v_i_it0000 and another one for personal_data. There´s an association between personal_data and infotype0000 as well

when I import this view into gateway, setup the service implementation mappings and add the association, I get the following error: Mismatch of target 'Infotype0000Set' and binding of association 'PersonalDataSet'.

I have tried 2 different implementations of my view personal_data but I am still getting the same error.

Has someone had the same issue? Do you know what may be wrong?

Thanks in Advance

J

[wolfgang_lindner2]

Hi,

currently I have a similar issue in NW7.40.

In SEGW the message "Mismatch of target 'QueueSet' and binding of association 'KeyItemSet1', since the target a" appears when I try to assign a CDS association.

Regards Wolfgang

[Andre_Fischer]

Hi Juan,

there was a similar question posted here with the suggestion to use the Referenced Data Source approach.

https://answers.sap.com/questions/271483/odata-service-in-segw-with-cds-service.html

Would you be able to use this as well or are you using SAP NW 740 and are thus forced to use the mapped data source approach?

The coding of your CDS views could be entered in code boxes. Simply use the "code" button on top of the editor window.

define view v_i_it0000 as select from t_infotyp0000 {
key pernr,
key begda,
key endda,
stat2,
case when stat2 = '3' then 'X' else '' end as is_active }

Best Regards,

Andre

[former_member522662]

Hi Andre,

I am using NW 750. I have tried the solution proposed via that link, but it somehow does not work.

In SEGW I choose Reference->Data Source. In the 2nd step ("reference Datasource wizard") the status is red and I get the following sentence as Information: SADL-Model type is not the expected type CDS

What may be wrong?

Thanks in advance

Juan