topic problem with a select statement in Application Development and Automation Discussions

problem with a select statement

Former Member — Mon, 31 Mar 2008 10:04:43 GMT

see this select statement

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.

in the above select statement you can see two check statements befor appending (both those checks are on the select options)

i came to know that these two check statements is to check whether the values(kdnr,prctr) are present in the table ce4e001.

if present then the following conditions are executed.

if not nothing wiil be moved into v_ce4e001.

now my problem is, i want to replace this statement with

select using into table. in this case how can i incorporate those two check statements in my new select statement

Re: problem with a select statement

Former Member — Mon, 31 Mar 2008 10:06:55 GMT

try below code

select *

from ce4e001

into table v_ce4e001

where bukrs eq s_bukrs-low

and kndnr in s_kndnr

and prctr in s_prctr.

regards

shiva

Re: problem with a select statement

Former Member — Mon, 31 Mar 2008 10:16:58 GMT

Hi,

select * from ce4e001 into corresponding fields of table v_ce4e001 where bukrs eq s_bukrs-low and

kndnr in s_kndnr and

prctr in s_prctr.

Regards,

Morris Bond.

Reward Points if Helpful.

Re: problem with a select statement

Former Member — Mon, 31 Mar 2008 10:22:21 GMT

hi Vamshi,

do this way


select * from ce4e001 into corresponding field of  table it_ce4e001
 where bukrs eq s_bukrs-low and
                                         kndnr in s_kndnr        and
                                         prctr  in s_prctr.