05-17-2013 12:09 AM
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
05-17-2013 5:59 AM
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
05-17-2013 6:12 AM
Hello Shyam,
I don't think there is any alternative solution available for READ_TEXT function module.
Regards
Suresh Nair
05-17-2013 6:13 AM
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.
05-17-2013 8:19 AM
05-31-2013 8:56 AM
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.