topic Re: Database view in Application Development and Automation Discussions

Database view

Former Member — Wed, 08 Aug 2007 15:26:06 GMT

Hello ,

I have a problem with displaying the data in view. I created a view (SE11) following the guidelines from library . I made join of two tables already containing the data .

The data can be seen when using SE16 for the table separately , but when i when to see the data in the view ( also with se 16 ) i can see only the data from the first table not from the second one in the view . And what i s more strange I can't even see the columns of the second table.

Please advice .

Christo

Re: Database view

seshatalpasai_madala — Wed, 08 Aug 2007 15:35:20 GMT

Hi,

Check if you have added fields from the second table to the View fields.

Also only 40 columns can be displayed when you want ot see the table or view contents from SE11.

Also for your info Database view is created using INNER JOIN in the underlying database.

Regards,

Sesh

Re: Database view

Former Member — Wed, 08 Aug 2007 16:00:57 GMT

Database views are implement an inner join, that is, only records of the primary table (selected via the join operation) for which the corresponding records of the secondary tables also exist are fetched. Inconsistencies between primary and secondary table could, therefore, lead to a reduced selection set.

In database views, the join conditions can be formulated using equality relationships between any base fields. In the other types of view, they must be taken from existing foreign keys. That is, tables can only be collected in a maintenance or help view if they are linked to one another via foreign keys.

Please have a look at below link. It will help you.

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed06446011d189700000e8322d00/frameset.htm

for more detailed info look on:

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

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abap+dictionary&;

<b>Reward points for useful Answers</b>

Regards

Anji

Re: Database view

Former Member — Thu, 09 Aug 2007 05:40:36 GMT

Thank you