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

Table or View for Generic Datasource

Hi,

We need to create reports for Purchase Requisitions and realized that there is no

std. datasoucre as such fr Purchase Requisitions. They come from the table EBAN. Fine. So, we have decided to create a generic datasource based on this table EBAN. Now the question is : Should I create the datasource based on View

or just directly on the table ? On what basis do I decide?. EBAN is the only table I need to use.

so, what is the normal procedure when we need a datasource over a single table.

- table or view ?

Advise me pls.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2007 at 09:54 AM

    Hi Vaishali,

    You can create it on the table directly.No need of creating a view again.

    Regards

    Karthik

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2007 at 11:08 AM

    Hi,

    you need to create a view. There are some quantities which reference table mara for the unit. With a view you have the ability to exclude those fields or with including, you can add the unit to your view in order to get a working datasource.

    kind regards

    Siggi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      First see if the system will allow you to create a data source directly on the table .

      if it allows its ok no need to create a view.

      it might not if there are some fields eg meins which have a reference to other tables eg mara. so in such cases you have to create a view leaving out these fields .

      you can populate these fields in bw by adding the corresponding info objects in the comm structure and populating them in update rules by looking up the corresponding master data

      hope this helps

      regards

      pls assign points if useful

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.