topic Re: select is not working!!!!!!!!!! in Application Development and Automation Discussions

select is not working!!!!!!!!!!

Former Member — Fri, 07 Sep 2007 16:17:43 GMT

hi,

my internal table is

data : begin of i_bkpf occurs 0,

xblnr like bkpf-xblnr,

end of i_bkpf.

and my select statement is

select xblnr into table i_bkpf

from bkpf

where blart = p_blart.

loop at i_bkpf.

write : / i_bkpf-xblnr.

endloop.

now there is no output for this statement...there is data int he table against blart inthe table..can anyone correct me ...

thankyou..

Re: select is not working!!!!!!!!!!

Former Member — Fri, 07 Sep 2007 16:26:09 GMT

What value is in p_blart?

Your code works fine in our system.

Rob

Message was edited by:

Rob Burbank

Re: select is not working!!!!!!!!!!

RichHeilman — Fri, 07 Sep 2007 16:27:11 GMT

Your code works ok for me, I enter "SA" into the parameter field and i get the output. How is your PARAMETER statement defined and what are you putting into that field?

Regards,

Rich Heilman

Re: select is not working!!!!!!!!!!

BGarcia — Fri, 07 Sep 2007 16:41:37 GMT

Hello Challa,

If p_blart is a SELECT-OPTIONS input variable, then the WHERE clause must be like:

where blart IN p_blart.

Best regards,

Bruno Garcia

Re: select is not working!!!!!!!!!!

Former Member — Fri, 07 Sep 2007 17:36:13 GMT

hi Rich,

this is my parameter statment:

parameters: p_blart like bkpf-blart.

canu help me in this...

regards,

Challa

Re: select is not working!!!!!!!!!!

Former Member — Fri, 07 Sep 2007 17:43:10 GMT

This code works:

TABLES bkpf.

PARAMETERS p_blart LIKE bkpf-blart DEFAULT 'SA'.

DATA : BEGIN OF i_bkpf OCCURS 0,
xblnr LIKE bkpf-xblnr,
END OF i_bkpf.

SELECT xblnr INTO TABLE i_bkpf
FROM bkpf
WHERE blart = p_blart.

LOOP AT i_bkpf.

  WRITE : / i_bkpf-xblnr.

ENDLOOP.

Rob

Re: select is not working!!!!!!!!!!

RichHeilman — Fri, 07 Sep 2007 17:45:34 GMT

Yep me too. What value are you putting into the selection screen parameter?

Regards,

RIch Heilman

Re: select is not working!!!!!!!!!!

BGarcia — Fri, 07 Sep 2007 17:46:53 GMT

Hey Challa,

Try this

select xblnr into <b>corresponding fields of</b> table i_bkpf

from bkpf

where blart = p_blart.

Regards,

Bruno