select stmt error

[Former Member]

hi

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.

[Former Member]

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á

[Former Member]

hi tamas,

thanx for the response.

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

[Former Member]

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

MM

[sreeramkumar_madisetty]

Hi

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