Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Alternate to READ Billing Document Header Text and Line item Text

Former Member
0 Kudos

Hello Gurus,

I have written one report to get the historical data of billing and sales order details using the selection criteria. now, I have around 2 million records in my internal table (internal table has billing document number, billing document item no, sales order number, sales order item number etc..).

I used "READ_TEXT" to get the billing document header & item texts. because of the READ_TEXT call, my report is executing for a long time (Performance issue).

When I trace my report using ST12, I've come to know that single READ_TEXT is taking 5 seconds to get the billing document header text and 5 seconds for billing document item text. So I want to replace the READ_TEXT with select query on STXH & STXL tables. once i get the data from STXH & STXL tables I am not sure where to look for the text.

Can anyone please let me know if there is a way to replace READ_TEXT function module with any SELECT statements?

Thanks in Advance.

Thanks

Shyam

5 REPLIES 5

0 Kudos

Dear Shyam,

The Function module"READ_TEXT" is to read single record at one step.

Mean while,

There is another Function Module "SELECT_TEXT", In this pass the Values in the form of Table and get the required records in the "Selections" Table.(Go through the FM for Details)

Try this...

It's May be need full I think.

Thanks

Kranthi

former_member15255
Active Participant
0 Kudos

Hello Shyam,

I don't think there is any alternative solution available for READ_TEXT function module.

Regards

Suresh Nair

Former Member
0 Kudos

There is a perform in READ_TEXT FM.....

READ_TEXTLINES

Have a look at the code it will help you in converting the binary data into normal values.

Former Member
0 Kudos

Hi,

You can write select on STXH & STXL tables

Former Member
0 Kudos

Hi Shyam,

STXL stores text data in some cryptic format so we cannot directly query it and get the value.

Please see thread,

https://scn.sap.com/thread/1907053

It will surely help you.

Regards,

Ankit.