how to get plant wise distribution channels

Hi Venkat,

MVKE - Matnr,VKORG,VTWEG

MARC - MATNR,WERKS

Regards,

Satish

by using inner join you can fetch the combination

select matnr marc from MARC and vtweg from MVKE table.

Thanks

Siva Kumar

SELECT a~matnr
         a~werks
         b~vkorg
         b~vtweg
  FROM marc AS a INNER JOIN
       mkve AS b ON a~matnr = b~matnr                     
  INTO TABLE itab WHERE a~matnr IN s_matnr
                       AND a~werks IN s_werks.
                       

Please reward if useful.