External view cannot be activated ( 0RECORDTP, 0REQUID error )

[former_member185511]

Hi everyone,

I have a standard infocube where we put our plan data which is coming from a UI5 application. Recently we moved to HANA and i want to consume our infocube data through external view. I click the checkbox from RSA1 and external view for cube successfully generated. Now i want to create dictionary view -> External view on top of this view so i can consume in my CDS view like a normal view.
Why i get below errors and how can i overcome this ?

Error during external view activation ( dictionary view creation)

columns of current external view from infocube:

There are possible workaround like CDS table functions via AMDP or creating another view in HANA layer by removing below columns but i want to do workarounds as final option.

thanks.

[former_member303082]

Hi Bilen,

Following special ABAP methods are not suitable and they are deprecated in SAP HANA XSA.

• DDIC external views for SAP HANA views in SAP HANA Repository
• Database procedure proxies for SQLScript Procedures in the SAP HANA Repository

ABAP Managed Database Procedures (AMDP) are recommended instead.

More information: https://launchpad.support.sap.com/#/notes/3116165

Regards,
Harish Mehta

[former_member185511]

thanks Harish that explains why!