How do you read a virtual table with ABAP

[stephenl1]

Hi, I have created a virtual table using Smart Data Integration (SDI). The virtual table now exists on my CRM HANA database, and is based over a ECC view. In Hana Studio SAP Hana Modeler perspective I can successfully run an SQLscript select statement as follows. This returns 31681 rows. I have tried to create a amdp table function over this, but when I specify the same script within my class method I get an error saying my table is invalid, because it is not in the dictionary. Is what I am trying to do not possible, or if it is, can someone illustrate the way this needs to be created? My goal is to make ECC data accessible for use in CRM, and Virtual tables seemed like they were going to be a good solution until I realised there is no way to create a dictionary object representation of the virtual table. If it cannot be done using a AMDP class, what is the best method for getting this data into CRM in realtime?

select mandt, contract_object, consent_object, fee_amount, dc_amount
from zvt_pscd_psobbal;

[UweFetzer_se38]

Never have worked with virtual tables yet, but you may try to read the table with EXEC SQL or Dynamic Native SQL (cl_sql_statement).

[Sandra_Rossi]

"dynamic native SQL", mean ADBC?

[UweFetzer_se38]

Yes
(+ some random characters, beacause SCN needs at least 7 characters before I'm allowed to submit a comment...)