Infoset VS View

[Former Member]

HI SDN,

How infoset capabilities are different than VIEW. Both of them used as a symatic layer to Join tables rite.

Please share your knowledge

thanks

[Former Member]

hi check this..

Basically a view contains the table fields which are relevant for a business sub function. The data in a view is not physically saved (in the database), it is derived from one or more tables. Views are created in the Generate Table Maintenance Dialog (SE54) and are edited in the Extended Table Maintenance (SM30).

where as a InfoSets contain ODS objects and master data tables. These are linked to one another (join) by fields of the same category (InfoObject). This makes it possible for the Analyzers to select data across various objects

i hope this clears

http://help.sap.com/saphelp_nw04/helpdata/en/3f/548c9ec754ee4d90188a4f108e0121/content.htm

regards,

venkat

[Former Member]

hi there,

All the information you are looking for infosets will is available in the link i am providing:

http://help.sap.com/saphelp_erp2004/helpdata/en/ed/084e3ce0f9fe3fe10000000a114084/content.htm

And for the view in SAP the link is:

http://www.sapdb.org/7.4/htmhelp/a8/cf8c3cc5bc5e16e10000000a114084/content.htm

http://help.sap.com/saphelp_webas630/helpdata/en/a8/695a3e740be946e10000000a114084/content.htm

Hope these links are helpful.

<REMOVED BY MODERATOR>. Thanks.

Edited by: Alvaro Tejada Galindo on May 20, 2008 3:23 PM

[Former Member]

I really appreciate all your replies.

Basically I am trying to undertand the difference from R3 Perspective not from BW. In R3 how these both concepts differ.

thanks

[martin_lehmann4]

Hello BI Boy,

Infoset Query as part of SAP Query, which is a tool of the ABAP workbench provides more powerfull techniques of data retrieval than a view, see help [Infoset Query|http://help.sap.com/saphelp_nw70/helpdata/en/f6/c39138e4a0341fe10000009b38f8cf/frameset.htm] .

To my knowledge with no claim to be complete two of these differences are

- access to pooled and clustered tables (not possible with views)

- possibility of left outer joins, see help [Defining Table Joins with the Help of Graphics|http://help.sap.com/saphelp_nw70/helpdata/EN/50/a71ec8f65911d296390000e82de14a/content.htm] .

Hope this helps

M.L.