Skip to Content
avatar image
Former Member

logical database

Hi,

can any body tell me how to use logical database

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Aug 20, 2007 at 07:08 AM

    Refer the links -

    logical-database

    logical-database

    logical-database

    Regards,

    Amit

    Reward all helpful replies.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 20, 2007 at 07:56 AM

    Logical databases are special ABAP programs that retrieve data and make it available to application programs. The most common use of logical databases is still to read data from database tables by linking them to executable ABAP programs.

    However, from Release 4.5A, it has also been possible to call logical databases using the function module <b>LDB_PROCESS</b>. This allows you to call several logical databases from any ABAP program, nested in any way. It is also possible to call a logical database more than once in a program, if it has been programmed to allow this. This is particularly useful for programs with type 1.

    Logical databases contain <b>Open SQL</b> statements that read data from the database. You do not therefore need to use SQL in your own programs. The logical database reads the program, stores them in the program if necessary, and then passes them line by line to the application program or the function module LDB_PROCESS.

    <b>Tasks of Logical Databases</b>

    As well as allowing you to read data from the database, logical databases also allow you to program other tasks centrally, making your application programs less complicated. They can be used for the following tasks:

    <b>Reading the same data for several programs.</b>

    The individual programs do not then need to know the exact structure of the relevant database tables (and especially not their foreign key relationships). Instead, they can rely on the logical database to read the database entries in the right order during the GET event.

    <b>Defining the same user interface for several programs.</b>

    Logical databases have a built-in selection screen. Therefore, all of the programs that use the logical database have the same user interface.

    <b>Central authorization checks</b>

    Authorization checks for central and sensitive data can be programmed centrally in the database to prevent them from being bypassed by simple application programs.

    <b>Improving performance</b>

    If you want to improve response times, logical databases permit you to take a number of measures to achieve this (for example, using joins instead of nested SELECT statements). These become immediately effective in all of the application programs concerned and save you from having to modify their source code.

    This link shows how to use a logical DB

    http://help.sap.com/saphelp_nw2004s/helpdata/en/60/183d78163011d2953c0000e8353423/content.htm>

    Reward if helpful.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 20, 2007 at 08:18 AM

    hi

    first u have to include the logical database in the main program

    while entering the prgm description and prgm type u have an option for ldb also

    enter the logical database name (ex : PNP)

    in the prgms u can use them

    u have get events related to these ldb's

    Add comment
    10|10000 characters needed characters exceeded