Select statement

[Former Member]

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

[Former Member]

Hi,

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

Thanks,

Senthil

[Former Member]

looks ok to me. what is the problem?

[Former Member]

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

Thanks,

Rajeev

[Former Member]

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

[Former Member]

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

[Former Member]

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

Thanks,

Rajeev

[Former Member]

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

[Former Member]

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

[Former Member]

then activate the include and try

[Former Member]

Activate the include, and execute the Main program

[Former Member]

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

Regards

[Former Member]

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.