cancel
Showing results for 
Search instead for 
Did you mean: 

Open Cursor - internal table

Former Member
0 Kudos

Hello,

I'm trying to use the

OPEN CURSOR

statement in my FM which is used for data extraction to split the data in packages of 10 000.

The problem is that I have an internal table where my data is (because I had to extract it first from a cluster table). How is the correct syntax?

 OPEN CURSOR s_cursor FOR SELECT * FOR ALL ENTRIES IN it_tab

does not work.

Or is there any other possibility to split the data into packages?

thanks

Margit

Accepted Solutions (1)

Accepted Solutions (1)

former_member205352
Active Contributor
0 Kudos

Try this :

E_T_DATA[] = your internal table[].

Donot use Open Cursor and fetch cursor statements.

While pulling it to BI you can restrict the package size.

Answers (2)

Answers (2)

former_member205352
Active Contributor
0 Kudos
Open cursor ...

This is not valid for internal table (I feel) it sets cursor at database level.

Former Member
0 Kudos

Hi Margit,

you usually limit the package not at the open cursor command but at the fetch statement by fetch next cursor into.... package size x.

regards

Siggi

Former Member
0 Kudos

yes, i know that i have to limit the package size with the fetch statement

but i'm not able to define the cursor correctly... i don't know why..

OPEN CURSOR s_cursor FOR SELECT * from 

after from it always wants a transparent table, but i do not have a transparent table, but only an internal table (data from internal table were fetched from a cluster table)