Skip to Content
0

Create ABAP external view on virtual table

Oct 11, 2017 at 03:36 PM

98

avatar image

Hello.

I'm trying to create ABAP external view on a virtual table in HANA. However none of the examples in howtos work. Is there a way to create SE11 view directly?

hana | sda
10 |10000 characters needed characters left characters exceeded

How you try to link the virtual table to the External View? A direct link is not possible, just via a column view (e.g. a calculation view).

SE11? No, that "dinosaur" (:)) transaction cannot be used for such kind of actions.

The other question is also why you are you wanna use an External View which is a Bottom-Up Approach instead of using e.g. an ABAP CDS Views using a CDS Table function to access the virtual table?

Regards,
Florian

0

Hey, Florian.

I tried to created DDL Source like so

define view ztest1 as select from ZBC_REQ { * }

but is says

 Basis object ZBC_REQ does not exist or is not active

Virtual table is in SAP schema

SELECT TOP 1000 * FROM "SAP<SID>"."ZBC_REQ"

Best regards,

Kirill

0

If ZBC_REQ is the virtual table, my answer from above is the same. You cannot access virtual tabels directly in an ABAP CDS View. You have to use e.g. a CDS Table function where you can implement the access logic in SQLScript and then use that CDS table function in the CDS view.

0

Oh, I see now. It only works for ABAP 7.5, while I'm still on 7.4.

Thanks for your help!

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers