Only scalar types allowed in this location of a query

[Former Member]

What possible solutions are available for creation of CDS view join where the keys are not scalar values?

I get the following error at activation:

Only scalar types allowed in this location of a query.

DEFINE VIEW ZCDS_Delivery_View AS SELECT FROM LIPS_SHORT
INNER JOIN LIKP_SHORT ON LIPS_SHORT.VBELN = LIKP_SHORT.VBELN
{
POSNR,
LFIMG,
NTGEW,
GEWEI
};

[pfefferf]

Can you share more information about the error message you get and what types the fields you are using have (e.g. which structured type)?

Thx,
Florian