Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

database view client dependent

Go to solution
Former Member

‎01-09-2007 9:25 AM

0 Kudos

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.

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎01-09-2007 9:26 AM

0 Kudos

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

2 REPLIES 2

Go to solution
Former Member

‎01-09-2007 9:26 AM

0 Kudos

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

Go to solution
vidya_gugnani
Explorer

‎01-09-2007 9:46 AM

0 Kudos

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