client dependent database view

[Former Member]

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

[Former Member]

Hi pieter,

1. Make MANDT (client)

as the FIRST FIELD in

<b>THE VIEW.</b>

(U must have forgotten that)

2. It will solve the problem.

regards,

amit m.

[Former Member]

hi Pieter

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

[Former Member]

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.

[Former Member]

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

greet,

Pieter

[Former Member]

people has given u the solutions...

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