Add fields to an existing database view.

Hi All,

My requirement is to add the VKORG and VTWEG fields from the MVKE table to an existing view with MARA, MARC and MAKT tables. My problem is when I add the two fields to the existing DB view , only the material in the MVKE are being pulled. How can I get the all the material (including material that does not have a sales org and distribution channel) ? This view will be used by an extractor. Any information will be helpful. Thanks in advance.

Raj