Method for Casting with Where condition in CDS view

former_member854927 — Fri, 28 Apr 2023 05:00:40 GMT

The following error was displayed when creating CDS view on Eclipse.

"Field AUSP-ATINN（type conflict in selection condition)"

My guess is that this error is caused by the item specified in the Where condition being defined in Numc.

But you can't do a Cast inside a Where condition. Is there a better way?

I specified the Where condition with the following syntax.

where ausp.atinn = 'asdfgh'

thank you

Re: Method for Casting with Where condition in CDS view

SeshaP — Wed, 31 May 2023 13:44:11 GMT

Hi,

Remove the ' ' single quotes and check - ausp.atinn = asdfgh

Single quote will be used for data types with Char.

create a new column using cast statement as cast (AUSP-ATINN as char10) as Atinn

and use this column in composite view where condition

Thank you