Insert ABAP CDS Data into a transaction table

Hi All,

I am merging historical data with S4 data and show them in SAC dashboard. But bringing historical data thru regular modeling is causing a severe performance degrade. So I am thinking of loading the Historical data after all modeling load into a table and use that table with S4 data. This way all we do is read and merge with S4 data, this saves a lot of time in real time modeling for the historical data.

I want to know whether I can use something

INSERT INTO <abap-table>

(SELECT columns FROM cds-view)

I can create exact structure of my CDS as a ABAP Table so the data can be loaded. We do not use embedded BW objects right now.

Any ideas or example would help.

Thank you,

Arthur.