topic Inner join in Application Development and Automation Discussions

Inner join

Former Member — Tue, 27 Nov 2007 13:18:49 GMT

Hi Experts,

I want to inner join two tables.

From Ekpo : matnr, TXZ01.

From Mbew : STPRS

i don't how to do that.

Please send some suggestions on this issue.

Thanks,

Points Assured.

Re: Inner join

former_member195698 — Tue, 27 Nov 2007 13:22:13 GMT

join EKPO MBEW on MATNR and BWTAR

select ekpo_{ebeln ekpo}posnr

ekpo_{matnr ekpo}TXZ01 mbew~STPRS

into table tb_ekpo_mbew

from EKPO join MBEW

on EKPO_{mantr = MBEW}matnr

and EKPO_{BWTAR = MBEW}BWTAR

where (your where condition)

Regards,

Abhishek

Re: Inner join

former_member386202 — Tue, 27 Nov 2007 13:25:29 GMT

Hi,

Better to use FOR ALL ENTRIES it will be performance wise good

select matnr txzo1

from EKPO

into table it_ekpo

where condition.

if not it_ekpo[] is initial.

select stprs

from mbew

into tbale it_mbew

for all entries in it_ekpo

where matnr eq it_ekpo-matnr.

endif.

Regards,

Prashant

Re: Inner join

Former Member — Tue, 27 Nov 2007 14:01:35 GMT

Hi,

I tried with your code,

But it shows dump like,

The data that was read could not be written to the specified target field during a SELECT access. Either the conversion is not supported for the type of the target field, or the target field is too short to accept the value, or the data is not in the appropriateformat for the target field.

Thanks.

Re: Inner join

Former Member — Tue, 27 Nov 2007 14:10:59 GMT

Jasmine,

Can you paste internal table declaration here?

Regards,

Satish

Re: Inner join

Former Member — Tue, 27 Nov 2007 14:16:24 GMT

Hi Sathish,

I cleared that error and I used Prasanth code. But now it displays standars price only. Its not displaying the Matnr and Description.

My code is,

select matnr TXZ01

from EKPO into corresponding fields of table rep_search .

if not rep_search is initial.

select stprs from mbew into corresponding fields of table rep_search for all entries in rep_search.

where matnr eq rep_search-matnr .

endif.

Thanks.

Re: Inner join

Former Member — Tue, 27 Nov 2007 14:28:50 GMT

select matnr TXZ01

from EKPO into corresponding fields of table rep_search .

if not rep_search is initial.

select mbew_{matnr mbew}stprs makt~maktx from mbew

join MAKTX on makt_{matnr= mbew}matnr and makt~spras = sy-langu into corresponding fields of table rep_search for all entries in rep_search.

where matnr eq rep_search-matnr .

endif.

Message was edited by:

Jacek Slowikowski

Message was edited by:

Jacek Slowikowski