Skip to Content
author's profile photo Former Member
0
Former Member

database view client dependent

Posted on Jan 09, 2007 at 09:25 AM 42 Views

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2007 at 09:26 AM
    2

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Vidya GUGNANI
    Vidya GUGNANI
    Posted on Jan 09, 2007 at 09:46 AM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.