Explain Logical Databases?

Answer

• Instead of using "Select" queries you can use logical database to retrieve data for a program.
• Logical databases are created by transaction SE36
• The name of a logical database can be up to 20 characters long. It may begin with a namespace prefix.
• The data is selected by another program and one can access the data using GET <table-name> command which places the data in the work area <table-name>.

Advantages of a logical database over normal Select queries.

1. It offers check conditions to see whether the input is correct, complete and plausible
2. It contains central authorization checks for database access
3. Enhancements such as improvement in performance immediately apply to all reports which use logical database.

Note: Due to the complexities involved, logical databases are not used in most of the cases