Database View

Former Member — Tue, 26 Jun 2007 14:18:02 GMT

Hi Experts,

I want to create a database view for my search help. From one of the tables I want to select distinct entries only. How can I specify it in SE11 while creating the view.

Regards

Abdullah.

Re: Database View

Former Member — Tue, 26 Jun 2007 16:59:57 GMT

From SE11 create the DB view and join the tables with the key fields

Database View (SE11)

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&;

Reward points for useful Answers

Regards

Anji

Re: Database View

Former Member — Wed, 27 Jun 2007 13:16:17 GMT

Hi Everyone,

I used a function module to solve my issue. I dropped the idea of creating a view and a search help.

Regards and thanks for your help.

Abdullah

topic Re: Database View in Application Development and Automation Discussions

Database View

Re: Database View

Re: Database View