topic Re: Select statement in Application Development and Automation Discussions

Select statement

Former Member — Wed, 15 Oct 2008 17:34:21 GMT

Hi All,

I have a situation where I need to select few fields from a std table to my internal table based on certain crtiteria and one of the criteria is if the field indicator is "X" then it should not insert the data in the internal table, can you please tell me how to write this statement. my table name is it_tab abd std table let say xyz and the field name is "OPEN".

so the statement should be:

select * from xyz into tabke it_tab

where name = 'ravi' and

bukrs = c_bukrs and

open ne 'X'.

is the above statement right?

Thanks,

Rajeev Gupta

Re: Select statement

Former Member — Wed, 15 Oct 2008 17:37:14 GMT

Hi,

Your stmt is correct. But make sure that the it_tab structure is same as the table structure.

Thanks,

Senthil

Re: Select statement

Former Member — Wed, 15 Oct 2008 17:38:11 GMT

looks ok to me. what is the problem?

Re: Select statement

Former Member — Wed, 15 Oct 2008 17:41:11 GMT

Thanks for your replies... I was just cross checking !!!

Thanks,

Rajeev

Re: Select statement

Former Member — Wed, 15 Oct 2008 17:41:23 GMT

Yes your select must work, just mentioning below again.

SELECT * INTO TABLE IT_TAB

FROM XYZ

WHERE NAME = 'RAVI'

AND BUKRS = C_BUKRS

AND OPEN <> 'X'.

If, you find any discrepancies let us know.

Re: Select statement

Former Member — Wed, 15 Oct 2008 17:46:27 GMT

Hi When I tried to run this statement it gav eme following error:

REPORT/PROGRAM statement missing, or program type is (include). How can make the chnage now.

Thanks,

Rajeev

Re: Select statement

Former Member — Wed, 15 Oct 2008 17:49:11 GMT

Go to ->Attributes then change the Program type to executable program and activate it

Re: Select statement

Former Member — Wed, 15 Oct 2008 17:51:57 GMT

Thanks for the reply but this is defined as an include program, don't you think it will create some problem !!!!

Thanks,

Rajeev

Re: Select statement

Former Member — Wed, 15 Oct 2008 17:53:02 GMT

You cant execute an include program .create a report and use this include

Re: Select statement

Former Member — Wed, 15 Oct 2008 17:54:42 GMT

Everything is already created and I just need to make some changes in the program which is basically a include in the main program

Re: Select statement

Former Member — Wed, 15 Oct 2008 17:56:37 GMT

then activate the include and try

Re: Select statement

Former Member — Wed, 15 Oct 2008 18:04:31 GMT

Activate the include, and execute the Main program

Re: Select statement

Former Member — Wed, 15 Oct 2008 18:48:39 GMT

Press <ctrl> <shift> <f5> and them run the main program.

Regards