cancel
Showing results for 
Search instead for 
Did you mean: 

Getting long text using query using amdp

jackyhjj
Explorer

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).

Accepted Solutions (0)

Answers (1)

Answers (1)

fedaros
Advisor
Advisor
0 Kudos

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
Explorer
0 Kudos

Hi fedaros ,
thanks for the response.

I will look into it.