Skip to Content
0
Former Member
May 16, 2013 at 11:09 PM

Alternate to READ Billing Document Header Text and Line item Text

271 Views

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