topic Re: MANDT field not getting considered in database view. in Application Development and Automation Discussions

MANDT field not getting considered in database view.

Former Member — Fri, 22 Apr 2011 05:26:49 GMT

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.

Re: MANDT field not getting considered in database view.

Former Member — Fri, 22 Apr 2011 06:04:34 GMT

Re: MANDT field not getting considered in database view.

Former Member — Fri, 22 Apr 2011 09:40:39 GMT

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

Re: MANDT field not getting considered in database view.

RaymondGiuseppi — Fri, 22 Apr 2011 11:35:45 GMT

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