database view client dependent

[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.

[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

[vidya_gugnani]

SY-MANDT helps you check which is the client.

For this,database tables should have the MANDT field as the first one and this should be mandatory