Regarding logical databases

Former Member — Wed, 12 Sep 2007 07:20:47 GMT

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

Re: Regarding logical databases

Former Member — Mon, 17 Sep 2007 10:36:27 GMT

Re: Regarding logical databases

Former Member — Thu, 27 Sep 2007 04:49:14 GMT

nss

Re: Regarding logical databases

Former Member — Thu, 27 Sep 2007 05:04:01 GMT

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.

topic Re: Regarding logical databases in Application Development and Automation Discussions

Regarding logical databases

Re: Regarding logical databases

Re: Regarding logical databases

Re: Regarding logical databases