topic Re: Select statement without into in Application Development and Automation Discussions

Select statement without into

Former Member — Tue, 26 May 2009 10:34:45 GMT

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

Re: Select statement without into

Former Member — Tue, 26 May 2009 10:37:51 GMT

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.

Re: Select statement without into

Former Member — Tue, 26 May 2009 10:38:03 GMT

Hey guys,

the problem is solved now.

Thanks

Re: Select statement without into

Former Member — Tue, 26 May 2009 10:39:48 GMT

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.

Re: Select statement without into

Former Member — Tue, 26 May 2009 10:40:21 GMT

cnvmbtrename ..take it as with header line.

it will work

Re: Select statement without into

Former Member — Tue, 26 May 2009 10:47:21 GMT

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

Re: Select statement without into

Former Member — Tue, 26 May 2009 10:48:19 GMT

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