Creating external view for Calculation Query View

[Former Member]

Hello all,

We are able to create an external view for attribute views.

However when try to create an external view for a Calculation view we receive this error message:

We already trying adding the role CONTENT_ADMIN but this did not resolve the issue.

Thanks!

[padmashree_b]

Hi Tim,

Kindly refer to the thread , similar issue is being discussed there.

Hope this helps.

Kind Regards,

Padma

[JensWeiler]

Hi Tim,

if you have a SAP Netweaver ABAP SP2, SP3 or SP4 please use SAP Note 1837708.

If you have a newer release -> A ticket is already in process. I will update as soon as we know more.

Cheers

Jens

[jasmin_gruschke]

Hi Tim,
SAP note 1932922 will help to solve the issue.

Cheers,

Jasmin

[Former Member]

Hello,

This notes helps in a way that we are receiving different error messages now.

Do you have any advice regarding this issue?

Thanks!

[jasmin_gruschke]

Hi Tim,
on that issue I don't have good news and even worse not a good advice.
The issue is, that the ABAP Dictionary does not support a type mapping for the non-unicode type VARCHAR but only for the corresponding unicode type NVARCHAR. For that reason it's not possible to create an external view on a HANA view including a VARCHAR column.

I said I don't have a good advice but there are workarounds.

• If you created the HANA view yourself, the advice is of course not to use VARCHAR but to go for NVARCHAR (from the DB site that does not modify the behaviour since HANA only supports unicode systems and in that sense VARCHAR behave like NVARCHAR)
• One option is to create a wrapper, i.e. a HANA view or a HANA stored procedure for the HANA view sap.hba.ecc/PurchasingGroupAnalysisQuery. The wrapper can then be exposed as external view or DB procedure proxy in the ABAP.

Cheers,

  Jasmin