topic Re: client dependent database view in Application Development and Automation Discussions

client dependent database view

Former Member — Mon, 08 Jan 2007 10:05:09 GMT

Hey,

how can I make a database view client dependent? If I put the clients of the different tables I want to join, in the joinconditions, it joins the different tables for the right clients, but it is not restricted to the client I'm currently logged on to. So I still have too much data.

greet,

Pieter

Re: client dependent database view

Former Member — Mon, 08 Jan 2007 10:19:55 GMT

Hi pieter,

1. Make MANDT (client)

as the FIRST FIELD in

(U must have forgotten that)

2. It will solve the problem.

regards,

amit m.

Re: client dependent database view

Former Member — Mon, 08 Jan 2007 10:25:11 GMT

hi Pieter

adding first field "MANDT" can solve ur problem...

Re: client dependent database view

Former Member — Mon, 08 Jan 2007 10:32:12 GMT

the first field should be MANDT which will hold the client no. Using this u can see the entries to which system they belong.

Always it is good to maintain MANDT for all tables & views.

Re: client dependent database view

Former Member — Mon, 08 Jan 2007 10:38:13 GMT

ok thanks, my MANDT field was not the first field in the view fields. Moving it upwards has solved the problem

greet,

Pieter

Re: client dependent database view

Former Member — Mon, 08 Jan 2007 10:41:00 GMT

people has given u the solutions...

So, u need to atleast assign points before closing the thread as it has solved ur problem.