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

I wanted to Know about VIEWS in Sap abap

hi, this is Abdul Rahman.

I wanted to know about VIEWS,How it exactly works and

what is the perpose of it and in what way it is helpfull

to create reports .how should i create a perfect VEIWS and use it . whats the tansaction code for it.

thank you,

Abdul Rahman

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Aug 07, 2005 at 01:41 AM

    Views are just another way of looking at data from the database. For example say that there is a database table with 100 fields and you only need to see 10 of the fields. In a view you would define the table where the data comes from and those 10 fields that you want to see. When doing select against this view, the database processor will take a look and see what fields are defined in the view and select only those fields instead of all the fields. You can also define in the view, certain selection criteria, also you can join other tables. You create views via SE11.

    Regards,

    Rich Heilman

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      To extend of the comments above, Views are not a concept specific to SAP. Database views are part of the Relational Database model created by Dr. E.F Codd in the early 1970s.

      Views can be created for the sole purpose of reducing the resultant columns (as mentioned above).

      However, they are more appropriately used to join multiple tables based on certain criteria. This "joining" inside of the view reduces the amount of SQL that an application developer needs to write get create reports, etc.

      In theory (at least), it should also reduce the number of "bugs" that an application developer might create by not understanding the data table structures, inefficient SQL, poor coding structure, etc.

  • author's profile photo Former Member
    Former Member
    Posted on Aug 07, 2005 at 07:46 AM

    Hi~ abdul.

    Additionaly speaking, there are 4 kinds of views in SAP.

    it's a little different concept with Database views(RDB created by Dr. E.F Codd ).

    1. Database view
     : this is inner join view.
    2. Mainternance view
     : this is left outer join view. we usaully use this 
       one for mainternance. as you know, SAP doesn't 
       provide DB maninpulation tools like SQL Plus(Oracle),
       query analyzer(MS-SQL). SAP provide 'SE11', 'SE16'
       instead. however, we just can retrive data with 
       se11,se16. not changing, deleting.
       so SAP provide mainternace tool(SM30). we can 
       inserting, changing, deleting with that. and 
       mainternace view is useded for it.   
    3. Projection view
      : this is projection view. just retrieve some fields
      from only one table.
    4. Help view
      : this is used for search help.
    

    you can create it with T-code 'SE11'.

    please refer http://cma.zdnet.com/book/abap/index.htm

    http://help.sap.com

    you may find more good information.

    sorry for my poor english __

    Best regards

    kyung woo.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 08, 2005 at 04:06 AM

    Hi Abdul,

    This will be helpful for you,

    http://help.sap.com/saphelp_40b/helpdata/en/cf/21ec5d446011d189700000e8322d00/content.htm

    Best Regards,

    Anjali

    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.