Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Maintanance view, Help view, Data Base
View and Projection View?
- 1 Answers
- 33328 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / uma mb
Maintenance View: Created by joining two or more related (by
foreign key) tables. Join conditions are always using the
foreign key. Data can be changed, viewed and created using
such maintenance views. This type of view implements outer
join (where those records that do not have a corresponding
entry in some of the tables participating in the view also
show up) against database views that implement inner joins
(where the user sees only records which have a corresponding
entry in all tables participating in the view).
In tcode SE54, generate table view, and select view type as
'maintenance view'. More information is available in
manuals/books on how to create a one step and two step
maintenance view.
A database view can be READ only (formed by joining two or
more tables) and of course, if the appropriate option is
selected while creating it, it could write into the
underlying table also. If a database view involves more than
one table, then it can only be a READ ONLY view.
Projection View is formed out of exactly only one table and
it is a projection view (selective columns are displayed
from the table).
Help views also implement an outer join in the tables
participating in the view. Typically these are used when one
creates a F4 help in a field of a data entry screen. A
database view could also be linked to a search help but must
be avoided because database views use an inner join and
therefore some records may get hidden and may not therefore
really HELP.
| Is This Answer Correct ? | 58 Yes | 2 No |
Post New Answer View All Answers
How do we handle multiple line items in BDC's.
I need some information regarding Vcentric Test pattern ? with questions.
What are the relational operations that can be performed on view in sap? : abap data dictionary
Why are insert and append statement used in sap abap?
What is an abap instance?
Explain the Importance of pa20? : abap hr
WHAT ARE THE INPUT PARAMETERS TO BE PASSED FOR THE BAPIS 'BAPI_CUSTMATINFO_GETDETAILM' AND 'BAPI_CUSTMATINFO_GETLIST'
What is a view in sap? : abap data dictionary
What are the events in screen programming?
Give Some examples of reports generated in real time scenarion? Also give examples of standard reports in SAP used in real time?
What is interactive reporting?
If your project is support project ? when is your implementation has completed ?
What is collective search help? : sap abap data dictionary
Why do we declare a method of a class final? What can be the purpose? Give a scenario.
What is delivery class? : abap data dictionary
