MANDT field not getting considered in database view.

Hi,

I have created a database view with tables MARA, MAKT and MVKE. The joi conditions are as below:

MARA-MANDT = MVKE-MANDT

MARA-MATNR = MVKE-MATNR

MARA-MANDT = MAKT-MANDT

MARA-MATNR = MAKT-MATNR

However, the MANDT of the logon client is not considered and when I execute the view, same Material code M0001 appears twice as it exists in clients 110 and 120.

Where am I going wrong?

Kindly assist.

Thanks in advance.