Method for Casting with Where condition in CDS view

[former_member854927]

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

[SeshaP]

Hi,

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

Single quote will be used for data types with Char.

Or

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