Showing posts with label VIEW. Show all posts
Showing posts with label VIEW. Show all posts

Tuesday, October 6, 2020

Differences Between Database View & Projection View in SAP ABAP.

 Database View & Projection View in SAP ABAP.



· Database view can built over many tables whereas projection view can be built over a single table only.

 Database view can be updated if the view is built over a single table whereas in projection view data can be updated.

 In case of database view, data updates can use open SQL or native SQL whereas in case of projection view, data updates must use open SQL.

 Database view can be buffered whereas Projection view cannot be buffered. 

Views In SAP ABAP.

What Are The Different Types Of Views In SAP?

Views In SAP

In SAP, you have total four types of views. Based on the way in which the view is implemented and the methods that are permitted for accessing the view data they are divided into Database View, Projection View, Maintenance View and Help View. Database views implement an Inner Join whereas Projection View, Maintenance View and Help View implement an Outer Join. There are 4 Different types of

 Views in SAP. They are:

 Maintenance View

 Database View

 Projection View

 Help View

Friday, September 11, 2020

Types of Views and explain in SAP ABAP.

What are the types of Views and explain about them?



View in SAP ABAP.

Ans: - Views are the virtual/imaginary tables. It does not contain the data permanently.

View contains the data at Run time only.

1) Database View: - 

It is used to combine the multiple tabled data by joining them. It can be used to extract the data in the programs.

2) Maintenance View: - 

It is used to maintain multiple tables data using the T-code SM30 (TMG).

3) Help View: 

- It is used in the selection method in an Elementary Search Help to provide the

list of possible entries from the multiple tables.

4) Projection View

: - It is used to HIDE the unwanted fields of the table. It can be

defined using one table only.