topic database view client dependent in Application Development and Automation Discussions

database view client dependent

Former Member — Tue, 09 Jan 2007 09:25:57 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.

Re: database view client dependent

Former Member — Tue, 09 Jan 2007 09:26:49 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: database view client dependent

vidya_gugnani — Tue, 09 Jan 2007 09:46:26 GMT

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