Getting long text using query using amdp

[#1]

Hi,
Is there any way that we can use query in AMDP to retrieve long text value of any object ?

We are trying to avoid using FM read_text in a loop (very bad in performance).

[fedaros]

Hi jackyhjj,

Are you on S/4 2020 or above. Take a look on report ESH_SR_LTXT_REPLICATE which persist the texts on a table as string and exposed as cds.

More info:

https://blogs.sap.com/2023/08/07/accessing-long-text-of-sap-master-data-objects-or-fields-in-s4-hana...

https://blogs.sap.com/2023/09/22/tables-to-read-po-header-and-item-texts-in-s4-hana/

Regards, Fernando Da Rós

[jackyhjj]

Hi fedaros ,
thanks for the response.

I will look into it.