topic Re: Regarding a select statement in Application Development and Automation Discussions

Regarding a select statement

Former Member — Tue, 25 Mar 2008 09:48:50 GMT

hi,

i got a select statement in my program as shown below

select * from ce4e001 where bukrs eq s_bukrs-low.

check s_kndnr.

check s_prctr.

move-corresponding ce4e001 to v_ce4e001.

append v_ce4e001.

endselect.

now i want to rewrite this select statement with using into table like

select * from ce4e001 into table v_ce4e001 where bukrs eq s_bukrs-low.

but my problem is

in the initial select statement they have used two check statements before appending

now how can i incorporate those two check statements in my new select statement

thanks

ram

JozsefSzikszai — Tue, 25 Mar 2008 09:54:18 GMT

hi Ram,

select * from ce4e001 into table ... where bukrs eq s_bukrs-low

*AND kndnr IN s_kndnr

AND prctr IN s_prctr*.

hope this helps

Former Member — Tue, 25 Mar 2008 09:55:45 GMT

since the 2 check statements are not dependant from the select, you can do them in front of your new Select into table statement.

Former Member — Tue, 25 Mar 2008 10:05:39 GMT

Hi Ram,

Not sure why the check keywords where embedded within the select statments...it will have no impact if the selection variable where outside.

You could rewrite your new code as:

check s_kndnr.

check s_prctr.

select * from ce4e001 into table v_ce4e001 where bukrs eq s_bukrs-low.

Assign points if it works.

Thanks

-Saif