logical dbase vs view

[Former Member]

hi,

what is the difference for these 2?

logical dbase is made up by a collection of tables whereas view also about the same. so what is the difference in sap?

thanks

[RichHeilman]

The logical database is not a dictionary entity. It also includes the data retrieval as well as the selection parameters. The logical database is used in your programs to provided the selection screen(in some cases) and the data retrieval using the GET statement. The view is simply a view of a database table or a join of multple tables, you can specify the fields that you want as well as the join condition. The view is maintain via SE11. In your programs, you simply do a SELECT statement against the few.

Regards,

RIch Heilman

[former_member194669]

Hi,

Logical databases are special ABAP programs that retrieve data and make it available to application programs. The most common use of logical databases is still to read data from database tables by linking them to executable ABAP programs.

Logical databases contain Open SQL statements that read data from the database. You do not therefore need to use SQL in your own programs.

http://help.sap.com/saphelp_47x200/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/frameset.htm

Database views are defined in the ABAP Dictionary. A database view is automatically created in the underlying database when it is activated.

Application programs can access the data of a database view using the database interface. You can access the data in ABAP programs with both OPEN SQL and NATIVE SQL

http://help.sap.com/saphelp_47x200/helpdata/en/36/74c0358373003ee10000009b38f839/frameset.htm

aRs

[Former Member]

View is a collection of tables. But in LDB's , tables / structures which share a hierarchial relationship are formed as LDB's. And LDB is a program where the filling logic of the nodes is defined.

Follow the link for more info on LDB's:

/people/srivijaya.gutala/blog/2007/03/05/why-not-logical-databases

and

http://help.sap.com/saphelp_nw04/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/content.htm