Inner join

[Former Member]

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.

[former_member195698]

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

[former_member386202]

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

[Former Member]

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.

[Former Member]

Jasmine,

Can you paste internal table declaration here?

Regards,

Satish

[Former Member]

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.

[Former Member]

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