Skip to Content
0
Former Member
Jun 08, 2009 at 02:40 PM

Read data from STATIC internal table during round trip in DO_PREPARE_OUTPUT

762 Views

Dear Gurus

I have a requirement where I need to select some data from the database table BUT_HIER_NODE_D.

After SELECTING this data to an internal table (say ITAB), I am displaying this data in a table view. I was able to achive this functionality by putting some code in the DO_PREPARE_OUTPUT method.

Now according to my requirement, after the above data has been displayed on the screen initially, the user will click on any row. After clicking on a particular row, I need to capture the document number on that particular row and need to display all its child document numbers in a separate table. I am able to achive this functionality also.

Initially I am not sure of how to READ the same internal table (ITAB) again and again by avoiding the SELECT query upon each round trip (between CRM and Web).

After some research, I understand that I might have to use STATIC internal table to store the data during the

initial SELECT. This way, upon each round trip, I can READ the data from the same internal table.

My question: But now, when I tried to create a STATIC internal table in DO_PREPARE_OUTPUT, it is not allowing me to declare this table because DO_PREPARE_OUTPUT method is a INSTANCE method.

I didn't find any STATIC methods in the IMPL class of the view.

I would really appreciate if somebody can help me on how to proceed further.

Thanks

Raj