SAP ABAP Question:
Download Questions PDF

What are logical databases? What are the advantages/disadvantages of logical databases?


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: - The programmer need not worry about the primary key for each table. Because Logical database knows how the different tables relate to each other, and can issue the SELECT command with proper where clause to retrieve the data.

1) An easy-to-use standard user interface.
2) Check functions, which check that user input is complete, correct, and plausible.
3) Meaningful data selection.
4) Central authorization checks for database accesses.
5) Good read access performance while retaining the hierarchical data view determined by the application logic.
6) No need of programming for retrieval, meaning for data selection

Disadvantages: -

1) If you do not specify a logical database in the program attributes, the GET events never occur.
2) 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).
3) Fast in case of lesser no. of tables But if the table is in the lowest level of hierarchy, all upper level tables should be read so performance is slower.

Download SAP ABAP Interview Questions And Answers PDF

Previous QuestionNext Question
Have you used SAP supplied programs to load master data?What specific statements do you using when writing a drill down report?