topic Re: select stmt error in Application Development and Automation Discussions

select stmt error

Former Member — Fri, 27 Apr 2007 16:29:23 GMT

plz rectify the error,

there is some prob with my inner join select stmt which i am unable to identify

here is the code.

tables: lfa1, ekko,

select-options: vend for lfa1-lifnr.

data: begin of itab occurs 0,

lifnr like lfa1-lifnr,

name1 like lfa1-name1,

land1 like lfa1-land1,

ebeln like ekko-ebeln,

end of itab.

select lfa1_{lifnr lfa1}name1 lfa1_{land1 ekko}ebeln into table itab from lfa1 inner join ekko on lfa1_{lifnr = ekko}ebeln where lfa1~lifnr in vend.

loop at itab.

write: itab.

endloop.

Re: select stmt error

Former Member — Fri, 27 Apr 2007 16:32:33 GMT

Hi!

Try like this:


select lfa1~lifnr lfa1~name1 lfa1~land1 ekko~ebeln 
  into table itab 
  from lfa1 inner join ekko on lfa1~lifnr = ekko~lifnr   "ekko~lifnr
  where lfa1~lifnr in vend.

Regards

Tamá

Re: select stmt error

Former Member — Fri, 27 Apr 2007 16:33:02 GMT

Hi,

you need match lifnr in your select query not PO number (lfa1_{lifnr = ekko}lifnr ), it should be like this

tables: lfa1, ekko,

select-options: vend for lfa1-lifnr.

data: begin of itab occurs 0,

lifnr like lfa1-lifnr,

name1 like lfa1-name1,

land1 like lfa1-land1,

ebeln like ekko-ebeln,

end of itab.

select lfa1_{lifnr lfa1}name1 lfa1_{land1 ekko}ebeln into table itab from lfa1 inner join ekko on lfa1_{lifnr = ekko}lifnr where lfa1~lifnr in vend.

loop at itab.

write: itab.

endloop.

Regards

Re: select stmt error

Former Member — Fri, 27 Apr 2007 16:36:11 GMT

hi tamas,

thanx for the response.

actually it was type mistake , i am having prob with the one which had provided

Re: select stmt error

sreeramkumar_madisetty — Fri, 27 Apr 2007 17:39:00 GMT

Whenever you are writing the select query on joins are tables first note down that

fields order in the select query must match with the Internal table fields declarations otherwise simply use the <b>corresponding fields of table</b> in your query.

Your query is going wrong because of these reason only.

Regards,

Sreeram