Inner Join between MARA, MARC and MVKE

[Former Member]

hi experts,

please give me a sample code to join these 3 tables.

thanks.

sasi.

[Former Member]

select a~matnr

a~mtart

b~werks

c~prodh

from ( mara as a join mard as b

on a_{matnr eq b}matnr )

inner join mvke as c

on a_{matnr eq c}matnr

into table i_mard

for all entries in i_yplnt

where a~mtart eq 'FERT' and

b~werks eq i_yplnt-pplnt.

Regards

Prabhu

[Former Member]

select a_{matnr a}mbrsh a_{mtart c}werks v_{vkorg v}vtweg into table itab from mara as a inner join marc as c on a_{matnr = c}matnr inner join mvke as v on c_{matnr = v}matnr.

Cheers.

[Former Member]

hi,

instead of inner joins go for all entries,

select matnr ersa ernam from mara into table it_mara

where matnr in s_matnr.

if it_mara[] is not initial.

select matnr werks pstat from marc into table it_marc

for all entries in it_mara where matnr = it_mara-matnr.

endif.

if it_marc[] is not initial.

select matnr vkorg vtweg from mvke into table it_mvke

for all entries in it_marc where matnr = it_marc-matnr.

endif.

if helpful get some points.

regards