Get Long Text with CDS Views like READ_TEXT function

[javier_barneogonzlez]

Hi.

I have creating a CDS that gets values form VBRP and VBRK tables.

I need get the long text from the Billing Document like a READ_TEXT function in ABAP, but I can't read the cluster table directly.

How can get the long text using CDS views?

Thanks in advanced.

[AbhijeetK]

Hi Javier,

These sap scrips texts are stored in an encoded binary format and challenge is to convert binary to text in CDS view.As of now there is no function for conversion in cds view.

to use the same functionality READ_TEXT in cds view one can use virtual elements using custom ABAP code exit on abap cds.

There are basically 3 interfaces available for this -

if_sadl_exit_filter_transform, if_sadl_exit_calc_element_read, if_sadl_exit_sorrt_transform

Virtual elements on CDS can be found on below blog

https://help.sap.com/viewer/cc0c305d2fab47bd808adcad3ca7ee9d/7.51.7/en-US/a7fc007921d44263b09ccc0923...

Below is similar kind of technical article is

https://blogs.sap.com/2019/04/26/fiori-elements-utilizing-cds-with-virtual-elements/

Abhijeet Kankani

[ClaudiaPirig]

Hello,
do you have any news on this topic? Is there a workaround available?

Thanks, Claudia

... unfortunately I just found this:

https://help.sap.com/http.svc/rc/abapdocu_751_index_htm/7.51/en-US/abenddic_database_tables_poclure....

[javier_barneogonzlez]

No news.

Thanks.

[eralper_yilmaz]

Hello is there any progress in this issue?

[javier_barneogonzlez]

Hi.

Not at the moment.

Sorry.

[sefakocali]

Hi. Is there any solution for that?

Thanks.