topic Re: Open cursor for internal table in Application Development and Automation Discussions

Open cursor for internal table

Former Member — Tue, 21 Apr 2009 13:26:29 GMT

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

Re: Open cursor for internal table

former_member194669 — Tue, 21 Apr 2009 13:39:20 GMT

Why don't you use EXEC and ENDEXEC

Check this link

http://help.sap.com/saphelp_nw04/helpdata/EN/fc/eb3b8b358411d1829f0000e829fbfe/content.htm

a®

Re: Open cursor for internal table

Former Member — Tue, 21 Apr 2009 13:44:05 GMT

Hi a®s

I don't use native sql due to the fact "[..] will not run under different database systems." as mentioned on help.sap.com.

Mrcl