Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Regarding logical databases

Former Member
0 Kudos

Hello All,

I want to re generate the structures for dynamic selection in logical database for that purpose im using the following menu path

se36>lg database name> change>menu option edit>generate selections

Its giving popup screen and its showing me the screen with the listing of tables

like this

Nodes for which free selections are to be generated

Nodes for which field selections are to be generated

Could any one pls explain what is the difference between two or any documentation will also be appreciated.

Thanks,

Sunny

3 REPLIES 3

Former Member
0 Kudos

ns

Former Member
0 Kudos

nss

Former Member
0 Kudos

hi

LOGICAL DATABASES ARE SPECIAL ABAP PROGRAMS THAT RETRIEVE DATA AND MAKE IT AVAILABLE TO APPLICATION PROGRAMS. THE MOST COMMON USE OF LDBS IS STILL TO READ DATA FROM DATABASE TABLES BY LINKING THEM TO EXECUTABLE PROGRAMS.

WE CAN ALSO CALL LDB’S USING THE FUNCTION MODULE LDB_PROCESS.

LOGICAL DATABASE CONTAIN OPEN SQL STATEMENTS THAT READ DATA FROM THE DATABASE. THEREFORE WE DO NOT NEED TO USE OPEN SQL STATEMENTS IN OUR ABAP PROGRAMS.

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. LDBS READ DATA FROM DATABASE TABLES THAT ARE PART OF THESE STRUCTURES.

 IT READS THE SAME DATA FOR SEVERAL PROGRAMS.

 IT DEFINES THE SAME USER INTERFACE FOR SEVERAL PROGRAMS.

 IT PROVIDES CENTRAL AUTHORIZATION CHECKS.

 IT IMPROVES THE PERFORMANCE.

THE LOGICAL DATABASE MADE UP OF THREE COMPONENTS.

 STRUCTURE – IT DEFINES THE DATA VIEW OF THE LDB.

 SELECTIONS – IT DEFINES A SELECTION SCREEN, WHICH FORMS THE USER INTERFACE OF THE EXECUTABLE PROGRAMS THAT USE THE LOGICAL DATABASE.

 DATABASE PROGRAM – IT CONTAINS THE ABAP STATEMENTS USED TO READ THE DATA AND PASS IT TO THE USER OF THE LDB. THE STRUCTURE OF THE DATABASE PROGRAM IS A COLLECTION OF SPECIAL ROUTINES.

THE DATABASE PROGRAM IS WITH THE NAMING CONVENTION OF SAPDB<LDB>. IT CONSISTS OF SUBROUTINES. EG, FORM PBO, PAI, LDB_PROCESS_INIT, AND INIT.

SELECTION VIEWS

THESE ARE THE COLLECTION OF FIELDS FROM DIFFERENT DATABASE TABLES.

TRANSACTION FOR CREATING LDB – SE36 OR SLDB

Pls reward if helpful.