Error while creating ABAP view from Calculative View

[Former Member]

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.

[jasmin_gruschke]

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

[Former Member]

Thankd Jasmin,

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

[yeushengteo]

Hi,

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

Regards.

YS

[jasmin_gruschke]

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