Skip to Content
0
Former Member
Apr 21, 2009 at 01:26 PM

Open cursor for internal table

472 Views

Hi folks,

I have a tricky question concerning the cursor function and internal tables. First of all, it is not possible to create a view. Instead I've to use a function module for extracting some data to the BI system.

Actually most of the time I work with SELECT (for outer joins) and internal tables. At the end I have a internal table and must open an cursor. As fact, I can't open a cursor for an internal table - only database tables are allowed.

 OPEN CURSOR WITH HOLD s_cursor FOR SELECT * FROM lt_temp. 

Does someone have a clue how to solve my problem? Obviously I have to use a db table for a open cursor statement but on the same way I have to use a internal table for all my previous SELECT-statements.

Thanks in advance for your help.

Regards,

Mrcl