Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what are logical and physical databases

Answer Posted / hari

LOGICAL DATABASE:
=================
To read data from a database tables we use logical database.
A logical database provides read-only access to a group of
related tables to an ABAP/4 program.

Advantages: i)check functions which check that user input is
complete, correct,and plausible. ii)Meaningful data
selection. iii)central authorization checks for database
accesses. iv)good read access performance while retaining
the hierarchical data view determined by the application
logic. dis advantages: i)If you donot specify a logical
database in the program attributes,the GET events never
occur. ii)There is no ENDGET command,so the code block
associated with an event ends with the next event statement
(such as another GET or an END-OF-SELECTION).


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. The logical database reads the
program, stores them in the program if necessary, and then
passes them line by line to the application program or the
function module LDB_PROCESS using an interface work area.

A logical database provides a particular view of
database tables in the R/3 System. It is always worth using
logical databases if the structure of the data that you want
to read corresponds to a view available through a logical
database.

The data structure in a logical database is
hierarchical. Many tables in the R/3 System are linked to
each other using foreign key relationships. Some of these
dependencies form tree-like hierarchical structures. Logical
databases read data from database tables that are part of
these structures.

Physical Database is actual Database.

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a data class? : abap data dictionary

1166


What kind of BDC programs are written ?

1068


Difference between sy-tabix and sy-index? Where it is used? Can you check sy-subarc after perform?

1085


There is a situation where there is a field "MATERIAL DESCRIPTION" in say 20 display only transaction. You want that whenever user opens any of these transaction, this particular field is masked with ****. But table does not holds ****. It holds the actual value. What are different ways of doing it? Which is the best way.

1393


What is Buffering Concept? When should a Table be buffered?

12953


How do you validate the selection criteria of a report? And how do you display initialvalues in a selection screen?

1216


What is the difference between upload and ws_upload ? : abap bdc

1243


How to Raise a Particular Ticket in Realtime ?

2286


Explain what is the step-by-step process to create a table in data dictionary?

1136


What is an Unpack command?

1152


There is a delivery that is being created through the ABAP code and in the middle it says delivery created but someone is modifying , how would you rectify this issue

8600


What is meant by slab? How is indian slab and us slab? : sap abap hr

1125


How do you set up background jobs in sap?

1016


What is a table cluster? : abap data dictionary

1177


Can a constructor be redefined?

1373