Logical Database

[Former Member]

Hello Everybody,

what is logical database. 'SE36'

How to make any logical database.

How to use them into ABAP Program.

Can anybody help me in this topic.

Thanks in advance....

[RaymondGiuseppi]

Logical database are programs that predefine a structured access to table and structure. There are mainly used in HR.

You create/maintain those via SE36 or SLDB.

You use them in program linking then in program attributes and using GET instructions or by using FM LDB_PROCESS.

For definition of logical database look at <a href="http://help.sap.com/saphelp_46c/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/frameset.htm">Logical Databases</a>

<i>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.</i>

For creation/editing look at <a href="http://help.sap.com/saphelp_46c/helpdata/en/9f/db9bfa35c111d1829f0000e829fbfe/content.htm">Creating a Logical Database</a>

For using these in Abap <a href="http://help.sap.com/saphelp_46c/helpdata/en/60/183d78163011d2953c0000e8353423/frameset.htm">Using Logical Databases</a>

Regards

[Former Member]

check this

Regards

Prabhu

[Former Member]

Hi Dharmishta,

Please check this link.

/people/srivijaya.gutala/blog/2007/03/05/why-not-logical-databases

Thanks&Regards,

Siri

[Former Member]

Hi ,

Check this info.

A logical database is a special ABAP/4 program which combines the contents of certain database tables. You can link a logical database to an ABAP/4 report program as an attribute. The logical database then supplies the report program with a set of hierarchically structured table lines which can be taken from different database tables.

GET will fetch the table data immediately

GET LATE

In the LDB when you define the table structure in hierarchy, first it will fetch the higher node data and then all the below node tables data and comes to a second record in the top node table. for this GET Late is used.

You can create any number of primary keys in a table

GO THROUGH LINKS -

http://www.sap-basis-abap.com/saptab.htm

http://help.sap.com/saphelp_nw04/helpdata/en/9f/db9bfa35c111d1829f0000e829fbfe/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/c6/8a15381b80436ce10000009b38f8cf/frameset.htm

/people/srivijaya.gutala/blog/2007/03/05/why-not-logical-databases

www.sapbrain.com/FAQs/TECHNICAL/SAP_ABAP_Logical_Database_FAQ.html

www.sap-img.com/abap/abap-interview-question.htm

www.sap-img.com/abap/quick-note-on-design-of-secondary-database-indexes-and-logical-databases.htm

Hope this resolves your query.

Reward all the helpful answers.

Regards

[Former Member]

hi ,

<b>Logical database:(LDB)</b>

1. LBD is a hierarchical structured table that retrieves several tables collectively and brings them and stores them in RAM to filter the selected output.

2. The T-code is SE36.

3. The three main concepts involved in LDB are :

• Selection screen

*Authorization check

*Fetching up of data.

<b>Advantage of Logical databases:</b>

• Less coding s required to retrieve data compared to normal internal tables.

• Tables used LDB are in hierarchical structure.

Regards,

Thasneem

Reward if useful.

[Former Member]

Hello Dharmishta ,

I have written a blog on LDB's and i have pasted the link below. Go thru it .

/people/srivijaya.gutala/blog/2007/03/05/why-not-logical-databases

[Former Member]

Hi,

Logical Databases

Objectives

In this Chapter we will discuss

– Overview of LDB

– Usage of LDB in ABAP Program

– Advantages of LDB

Database Selections

· Two ways of accessing data from database tables

– Accessing data using SELECT.

You can read and analyze data from all database tables

known to the SAP system by using SELECT statement

with

its different clauses.

– Accessing data using Logical Database(LDB).

Logical databases provide a method for accessing data in

database tables which differs from the SELECT statement.

You can link a logical database to an ABAP/4 report

program

as an attribute , it then supplies the report program with a

set

of hierarchically structured table lines which can be taken

from different database tables.

Comparison of Access Methods

· Report with SELECT statements Report with LDB

· Report …….. Report ……..

· Tables spfli, sflight, sbook. Tables spfli, sflight,

sbook.

· SELECT * from spfli where ... Get spfli.

· .

Hope this resolves your query.

Reward all the helpful answers.

Regards