Select Query Issue !

[sachin_soni]

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

[former_member480923]

hi

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.

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Sachin,

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

like

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