topic Select Query Issue ! in Application Development and Automation Discussions

Select Query Issue !

sachin_soni — Mon, 04 Jun 2007 10:41:00 GMT

Hi all,

I have the following query which is fetchin me each record three times :

select ekpo_{ebeln ekpo}matnr ekpo_{adrnr ekpo}meins ekpo_{menge ekpo}netpr ekpo~netwr

eket_{banfn eket}eindt ekpo_{ebeln ekko}bedat makt~maktx

from ekpo

join ekko on ekko_{ebeln = ekpo}ebeln

join eket on eket_{ebeln = ekpo}ebeln

join makt on makt_{matnr = ekpo}matnr

into corresponding fields of table potab

where ekpo~ebeln = pono.

ANY GUESSES WHY ?

Thanks,

Sachin

Re: Select Query Issue !

former_member480923 — Mon, 04 Jun 2007 10:45:28 GMT

Please do the folowing change

select ekpo~ebeln ekpo~matnr ekpo~adrnr ekpo~meins ekpo~menge ekpo~netpr ekpo~netwr
eket~banfn eket~eindt ekpo~ebeln ekko~bedat makt~maktx
from ekpo
join ekko on ekko~ebeln = ekpo~ebeln
join eket on eket~ebeln = ekpo~ebeln
join makt on makt~matnr = ekpo~matnr
into corresponding fields of table potab
where ekko~ebeln = pono.

Hope That helps

Anirban M.

Re: Select Query Issue !

Former Member — Mon, 04 Jun 2007 10:46:12 GMT

Hello Soni,

Change the code like this:


select ekpo~ebeln ekpo~matnr ekpo~adrnr ekpo~meins ekpo~menge ekpo~netpr ekpo~netwr
eket~banfn eket~eindt ekpo~ebeln ekko~bedat makt~maktx
from ekpo
join ekko on ekko~ebeln = ekpo~ebeln
join eket on eket~ebeln = ekpo~ebeln and 
                  eket~ebelp = ekpo~ebelp   " Check here
join makt on makt~matnr = ekpo~matnr
into corresponding fields of table potab
where ekpo~ebeln = pono.

REgadrs,

Vasanth

Re: Select Query Issue !

Former Member — Mon, 04 Jun 2007 10:48:06 GMT

try this it may help you

select ekpo_{ebeln ekpo}matnr ekpo_{adrnr ekpo}meins ekpo_{menge ekpo}netpr ekpo~netwr

eket_{banfn eket}eindt ekpo_{ebeln ekko}bedat makt~maktx

from ekpo

join ekko on ekko_{ebeln = ekpo}ebeln

join eket on eket_{ebeln = ekpo}ebeln and

eket_{ebelp = ekpo}ebelp

join makt on makt_{matnr = ekpo}matnr

into corresponding fields of table potab

where ekpo~ebeln = pono.

regards

shiba dutta

Re: Select Query Issue !

Former Member — Mon, 04 Jun 2007 10:48:20 GMT

Hi Sachin,

may be ur using this query under internal table which have three records...........

loop at itab

ur query........

endloop.

if not than specify ur entire code here............it makes more clear to solve it....

reward point if helpful,

Regards,

Imran