topic Re: Error while creating ABAP view from Calculative View in Application Development and Automation Discussions

Error while creating ABAP view from Calculative View

Former Member — Fri, 25 Oct 2013 10:32:42 GMT

Hi Friends,

While creating External ABAP view from Hana calculative view, I'm getting error like:-

view _sys_bic schema does not have any column in database.

But records are maintained in the database table.

Re: Error while creating ABAP view from Calculative View

jasmin_gruschke — Fri, 25 Oct 2013 11:07:34 GMT

Hi Hema,
there might be an issue with the content of your Calculation View. Can you check if the tables you use in the CV are in the Column Store?
If yes, can you please provide some more details about versions (ABAP and HANA) or system details?

Thanks,

Jasmin

Re: Error while creating ABAP view from Calculative View

Former Member — Tue, 29 Oct 2013 18:04:58 GMT

Thankd Jasmin,

I'm using ABAP 730 and HANA SP06. Already records are maintained in HANA databse. So how can i check these details?

Re: Error while creating ABAP view from Calculative View

yeushengteo — Wed, 30 Oct 2013 07:12:26 GMT

Hi,

I believe you need ABAP 740 as prerequisite to create external view.

Regards.

Re: Error while creating ABAP view from Calculative View

jasmin_gruschke — Wed, 30 Oct 2013 07:16:50 GMT

Hi Hema,
yes YS is right. You need ABAP 740. When working with 730 your only option is to use native SQL, e.g. via ADBC. You'll find a report ADBC_DEMO in your system that demonstrates how to do a select from a standard table, the select syntax for the HANA Calculation View is quite similar.

Cheers,

Jasmin