Select statement without into

[Former Member]

Hi ,

I am currently working with a include which is already written. The include has a select statement where the into clause is not available.

SELECT SINGLE * FROM cnvmbtrename

WHERE packid = p_pack

AND domname = space

AND param = gc_rfcdest

AND value_old = ls_rename1-value_old

AND value_new = ls_rename1-value_new.

This statement works fine when it is sued in some other program, but i does not work in mine. Can someone help me on this front.

Regards,

Rishav

[Former Member]

well it´s good to know what is happening here, tho you should not rebuild it.

youd need a Tables statement for that, which is by now obsolete.

[Former Member]

Hey guys,

the problem is solved now.

Thanks

[Former Member]

Hi,

They have declared this table 'cnvmbtrename' with the command TABLES.

So it is declared as a internal table with header line.

In that scenario, after select single, it will automatically fetch the data into the header.

If you want to use the similar one, then u need to define the same in the data declaration as TABLES.

Regards,

Santhosh.

[Former Member]

hi

cnvmbtrename ..take it as with header line.

it will work

[Former Member]

Hi,

Whenever you declare like

Tables : tab.

then tab will act as an work area.

So, If you are not writing into work area statement in a select query, which selects from the table tab, then the default work area will be taken as tab.

So, you do the tables statement on the top.

Thanks and regards,

Venkat

[Former Member]

Hi

U make sure all global data are defined in your program too, so:

- Database table:

TABLES cnvmbtrename.

- Selection screen (I suppose):

PARAMETERS: P_PACK....

- Data:

DATA: gc_rfcdest
..............

Max