External view on top of Attribute View

[sunil_hirgude2]

Hi,

I am trying to create External View on top of attribute view.

But getting Errors:

Import of HANA view is not possible. See ABAP Log for details.

Field CALENDAR_VARIANT: no Dictionary type exists for database type VARCHAR

Field DATE: no Dictionary type exists for database type VARCHAR

Field FISCAL_YEAR: no Dictionary type exists for database type VARCHAR

Field FISCAL_PERIOD: no Dictionary type exists for database type VARCHAR

Mapping DB type to DDIC type for view test/ZTIME_CONV_TEST is not possible

Could you please help me to understand the issue and resolve it.

Thanks & Regards,

Yogesh

[pfefferf · Accepted solution]

As the documentation describes (External Views) type VARCHAR is not supported. You have to check if you can e.g. change the type on HANA side from VARCHAR to NVARCHAR. If not possible you can create a "consumption" view on HANA side which calls your existing view and makes the type conversion (so the original view must not be changed, if that is not possible).

Regards,
Florian