Regarding a select statement

[Former Member]

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

[Former Member]

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

[JozsefSzikszai]

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

ec

[Former Member]

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]

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