Welcome to SAP ABAP Interview Questions. SAP VIEWS Types- Database, Projection, Maintenance, and Help view.
What Are VIEWS in SAP ABAP?
A view is a virtual table which is used to access the data of multiple database tables. A view contains fields from multiple database tables to display data. Views are four types in SAP ABAP.
•It access the data of one or more database tables.
•If it is created on more than one table it can be used only for reading.
•It implement an inner join.
•It only contain transparent tables.They may or may not have FK relationship.
•It can be used in ABAP program with open & native SQL statements.
•It has corresponding object in database.
•Append view & technical settings is possible .
•It is used to access few or all columns of a single DB table for reading & writing data.
•Can not specify selection conditions.
•It can be used in ABAP program.
•It can access pooled & cluster tables also.
•There is no corresponding object in DB.
•To update the data of one or more tables at a time.
•Transaction Codes associated with MV:
SE54 – Generate table maintenance dialog.
SM30 – Extended table maintenance.
•It implement both inner join and left outer join.
•FK relationship is compulsory between tables.
•It can not be used in ABAP program.
•All key fields of primary & secondary tables must be included in MV.
•You can insert tables that are linked by FK with one of secondary tables that was already inserted.
•Cardinality & FK field type is mandatory in MV.If secondary table is dependent table, cardinality can be 1:1 or 1:C. If secondary table is reference table, cardinality can be 1:N or 1:CN.
•The key fields must be defined before other fields.They must not be mixed.
•Maintenance attribute (p) has to be defined like R,S,H,<space>.Refer on line help.
•In SE54 , Mention function group,Authorization group, maintenance Type (one or two step) & screen number for overview & single screen.
•It is used while creating search helps for providing F4 help.
•It implement outer join.
•FK relationship is compulsory between tables.
•It can not be used in ABAP program.
•Not necessary to include all key fields of secondary tables in HV.
•You can insert tables that are linked by FK with one of secondary tables that was already inserted.
•Cardinality & FK field type is mandatory in HV.If secondary table is dependent table, cardinality can be 1:1 or 1:C. If secondary table is reference table, cardinality can be 1:N or 1:CN.
Different Types of Views in SAP
Database view
Projection view
Maintenance view
Help view
Database View
•It access the data of one or more database tables.
•If it is created on more than one table it can be used only for reading.
•It implement an inner join.
•It only contain transparent tables.They may or may not have FK relationship.
•It can be used in ABAP program with open & native SQL statements.
•It has corresponding object in database.
•Append view & technical settings is possible .
Projection View
•It is used to access few or all columns of a single DB table for reading & writing data.
•Can not specify selection conditions.
•It can be used in ABAP program.
•It can access pooled & cluster tables also.
•There is no corresponding object in DB.
Maintenance View
•To update the data of one or more tables at a time.
•Transaction Codes associated with MV:
SE54 – Generate table maintenance dialog.
SM30 – Extended table maintenance.
•It implement both inner join and left outer join.
•FK relationship is compulsory between tables.
•It can not be used in ABAP program.
•All key fields of primary & secondary tables must be included in MV.
•You can insert tables that are linked by FK with one of secondary tables that was already inserted.
•Cardinality & FK field type is mandatory in MV.If secondary table is dependent table, cardinality can be 1:1 or 1:C. If secondary table is reference table, cardinality can be 1:N or 1:CN.
•The key fields must be defined before other fields.They must not be mixed.
•Maintenance attribute (p) has to be defined like R,S,H,<space>.Refer on line help.
•In SE54 , Mention function group,Authorization group, maintenance Type (one or two step) & screen number for overview & single screen.
Help View
•It is used while creating search helps for providing F4 help.
•It implement outer join.
•FK relationship is compulsory between tables.
•It can not be used in ABAP program.
•Not necessary to include all key fields of secondary tables in HV.
•You can insert tables that are linked by FK with one of secondary tables that was already inserted.
•Cardinality & FK field type is mandatory in HV.If secondary table is dependent table, cardinality can be 1:1 or 1:C. If secondary table is reference table, cardinality can be 1:N or 1:CN.
"You found the information helpful and want to say thanks? Your donation is enough to inspire us to do more. Thanks a bunch!"
Posted in: 
0 comments:
Post a Comment
Note: Only a member of this blog may post a comment.