Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

MANDT field not getting considered in database view.

Former Member
0 Kudos

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.

3 REPLIES 3

Former Member
0 Kudos

-

Former Member
0 Kudos

Are you sure there aren't 2 records for that material in MVKE or MAKT?

raymond_giuseppi
Active Contributor
0 Kudos

If you don't specify CLIENT SPECIFIED and if the table or view is client-dependent the current client should be used by the SQL interface

- Are you giving the full key of a single record : MATNR, VKORG, VTWEG, SPRAS ?

- Is MANDT in the view in first position ?

Regards,

Raymond