06-26-2007 3:18 PM
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.
06-26-2007 5:59 PM
Hi
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
06-27-2007 2:16 PM
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