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

Working of Views

HI Gurus,

can anybody help me in views.actually i'm bit confused in fundamentals of views. So can anybody send me the implementation of views with screenshots.

Thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 06:07 AM

    Hi Gaurav,

    A view is nothing but a virtual table. You cannot store values into a view directly.

    A view can be a resultant of combination of two or more table based on their join queries. Views are created to view only the required fields,the original table might contain many felds which might not be useful to you.

    -Bhavin P Shah

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 06:19 AM

    Please go through this link.Hope its useful

    http://www.sap-img.com/abap/what-is-the-different-types-and-usage-of-views.htm

    Reward points,if useful

    -Bhavin P Shah

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 06:55 AM

    Hi,

    As rightly said by our other frineds a view is nothing but virtual tables.

    You can craete a view by SE11 transaction. there can be many types of view like DataBase Views, Projection Views , Help Views and Maintenance Views.

    The views in general is a Join on two or more database tables which shares some fields in common. This works in the same manner as that of the join statement in ABAP program.

    SAP gives some standard views also which can be used while programming also.

    e.g. If you need to query KNA1 ( Cust Master Table ) based upon the Company Code which is available in KNB1 table and not in KNA1, then you can use the SAP standard view <b>VF_DEBI</b> which is join of KNA1 and KNB1.

    VF_DEBI is standard view on LFA1 and LFB1.

    Hope this would help you to some extent in understanding View Concept.

    reward if helpful!

    Regards,

    Lalit Kabra

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 07:06 AM

    hi lalit,

    That is fine with me.But that concept is very much identical to SQVI join. THen why View???

    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.