What are logical databases? What are the advantages/disadvantages of logical databases?
Submitted by: AdministratorTo 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online SAP ABAP Job Interview Questions And Answers
Top SAP ABAP Questions
☺ | What is Function group? Difference between function group and function module? |
☺ | What is an ABAP instance? |
☺ | What are the contents in technical specifications? |
☺ | Difference between domain and data element? What are aggregate object? |
☺ | In selection screen, I have three fields, plant material number and material group. If I input plant how do I get the material number and material group based on plant dynamically? |
Top SAP (Systems, Applications, Products) Categories
☺ | SAP Modules Interview Questions. |
☺ | SAP (Systems, Applications, Products) Interview Questions. |
☺ | SAP Internal Tables Interview Questions. |
☺ | SAP ABAP Interview Questions. |
☺ | SAP BW Interview Questions. |