Material Long Text Data Extraction in Datasphere

[Alka01]

Hi All,

I have a project requirement to extract Material Long text from STXL table to SAP Datasphere by Replication flow. I am using CDS view as source of Datasphere replication flow and looking for suggestions to achieve this requirement in Datasphere or in CDS view.
I have searched in SCN and found function module READ_TEXT can be call in CDS view by using virtual elements but my understanding is virtual elements can only be use for FIORI not for data extraction in Datasphere.

Thanks you.
Alka

[Martin_Kuma]

Interesting approach Alka using Using Virtual Element. 

I would rather persist the text table independently, load it into DSP and use text-association to assign the text. 

[asantos_mad]

Hi!

We did not know how to manage via CDS (call a function ...) .

We are interested in to know how as we have other cases !

We found other way to get it via API.

We opt to use in batch mode but could use event mesh to capture and send when create/change

API Reference | Product Master (A2X) | SAP Business Accelerator Hub