Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

MANDT field not getting considered in database view.

Former Member

‎2011 Apr 22 6:26 AM

0 Likes
1,044

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
Read only

Former Member

‎2011 Apr 22 7:04 AM

0 Likes
794

-

Read only

Former Member

‎2011 Apr 22 10:40 AM

0 Likes
794

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

Read only

RaymondGiuseppi
Active Contributor

‎2011 Apr 22 12:35 PM

0 Likes
794

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