Working of Views

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

hi lalit,

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

[Former Member]

hi lalit,

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