topic Re: Creating external view for Calculation Query View in Application Development and Automation Discussions

Creating external view for Calculation Query View

Former Member — Mon, 07 Apr 2014 14:12:46 GMT

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!

Re: Creating external view for Calculation Query View

padmashree_b — Mon, 07 Apr 2014 17:17:07 GMT

Hi Tim,

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

Hope this helps.

Kind Regards,

Padma

Re: Creating external view for Calculation Query View

JensWeiler — Tue, 08 Apr 2014 12:57:59 GMT

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

Re: Creating external view for Calculation Query View

jasmin_gruschke — Wed, 09 Apr 2014 08:33:06 GMT

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

Cheers,

Jasmin

Re: Creating external view for Calculation Query View

Former Member — Wed, 09 Apr 2014 08:58:03 GMT

Hello,

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

Do you have any advice regarding this issue?

Thanks!

Re: Creating external view for Calculation Query View

jasmin_gruschke — Wed, 09 Apr 2014 10:58:46 GMT

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