Skip to Content
author's profile photo
Former Member

STRUCTURES of LOGICAL DATABASE?

STRUCTURES of LOGICAL DATABASE?

please explain

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • author's profile photo
    Former Member
    Posted on Aug 20, 2007 at 10:42 AM

    Hi See following link :

    http://help.sap.com/saphelp_nw2004s/helpdata/en/9f/db9b8535c111d1829f0000e829fbfe/content.htm

    Reward points if helpful.

    Regards.

    Srikanta Gope

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 20, 2007 at 10:42 AM

    Hi,

    plz go through the following link.....

    https://forums.sdn.sap.com/click.jspa?searchID=3168951&messageID=3211596

    ***do rewards if usefull

    vijay

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 20, 2007 at 10:43 AM

    Structure

    The structure defines the data view of the logical database. It adopts the hierarchy of the database tables defined by their foreign key relationships. This also controls the sequence in which the tables are accessed. It determines the structure of the other components and the behavior of the logical database at runtime.

    do" target="_blank">http://help.sap.com/saphelp_nw2004s/helpdata/en/9f/db9b8535c111d1829f0000e829fbfe/content.htm">do refer this for a detailed description

    regards,

    srinivas

    <b>*reward for useful answers*</b>

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 20, 2007 at 10:43 AM

    Hi,

    use SE36, insert your LDB, marc Structure and use Display.

    Regards, Dieter

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 20, 2007 at 10:45 AM

    hi,

    Logical Databases

    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 LDB_PROCESS. 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 Open SQL 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 using an interface work area.

    Logical Databases - Views of Data

    A logical database provides a particular view of database tables in the R/3 System. It is always worth using logical databases if the structure of the data that you want to read corresponds to a view available through a logical database.

    The data structure in a logical database is hierarchical. 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. Logical databases read data from database tables that are part of these structures.

    Add comment
    10|10000 characters needed characters exceeded