topic Re: Help with a select in Application Development and Automation Discussions

Help with a select

Former Member — Wed, 21 Mar 2007 14:55:00 GMT

I know this is a dumb question but I can't figure out why this select statement gives me a syntax error:

SELECT mblnr budat mjahr from mkpf INTO CORRESPONDING FIELDS OF table it_docnum
     WHERE budat IN s_budat.
ENDSELECT.

Regards,

Davis

Re: Help with a select

suresh_datti — Wed, 21 Mar 2007 14:56:19 GMT

drop the endselect.. you don't need it with inTO table option.

SELECT mblnr budat mjahr from mkpf INTO CORRESPONDING FIELDS OF table it_docnum

WHERE budat IN s_budat.

is enough.

~Suresh

Re: Help with a select

Former Member — Wed, 21 Mar 2007 14:59:34 GMT

hi,

No need of ENDSELECT as you are passing into internal tbale by saying into table.

Regards,

Sailaja.

Re: Help with a select

Former Member — Wed, 21 Mar 2007 15:00:22 GMT

hi Davis,

remove ENDSELECT statment ..

Regards,

Santosh

Re: Help with a select

Former Member — Wed, 21 Mar 2007 15:01:26 GMT

Thanks to all for your help. When do you use an endselect?

Regards,

Davis

Re: Help with a select

Former Member — Wed, 21 Mar 2007 15:01:50 GMT

If you want to keep endselet then remove table keywod in select stmnt

Thanks

Re: Help with a select

Former Member — Wed, 21 Mar 2007 15:03:26 GMT

When you are not selecting the records using the primary key and you are not moving the selected records into an internal table in one single shot by using INTO TABLE option.

Re: Help with a select

Former Member — Wed, 21 Mar 2007 15:03:36 GMT

refer this

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/endselec.htm

Regards,

Santosh

Re: Help with a select

Former Member — Wed, 21 Mar 2007 15:03:48 GMT

hi Davis,

When you are passing records into an internal table by using INTO TABLE or

when you are using SELECT SINGLE , then there is no need of ENDSELECT.

Regards,

Sailaja.

Re: Help with a select

SantoshKallem — Wed, 21 Mar 2007 15:04:58 GMT

one more is,

better avoid into corresponding fields

for that the order of field in internal table and select statement must be same.

data: begin of it_docnum occurs 0,

mblnr like mkpf-mblnr,

budat like mkpf-budat,

mjahr like mkpf-mjahr,

end of it_docnum.

SELECT mblnr

budat

mjahr

from mkpf INTO table it_docnum

WHERE budat IN s_budat.

Re: Help with a select

Former Member — Wed, 21 Mar 2007 15:06:02 GMT

Thanks a lot to everybody for all of your help! I apologize for the dumb, easy question.

Davis

Re: Help with a select

Former Member — Wed, 21 Mar 2007 15:07:58 GMT

Thanks a lot Santhosh, that answers the question of why I wasn't getting any records! I would love to reward you points for this but I'm all out for this question.

Thanks again!

Davis