Database view

[Former Member]

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

[seshatalpasai_madala]

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

[Former Member]

Hi

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

[Former Member]

Thank you