re: logical database

[Former Member]

Hi,

What is the logical database. I know how to create.

I think it is useful for dynamic selections of parameters.

This logical databases use by HR ABAP. Is it right?

But i heard that these will increase performnace of ur coding. How can u justify these doubts.

rgds

p.kp

[Former Member]

hi,

check this link...

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

regards

vijay

[Former Member]

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

-->they have inbuilt selection-screen

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

check this link

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

Message was edited by: chandrasekhar jagarlamudi

[Former Member]

Hi,

My doubt is It improves the retrieving data time from database than noraml select statement. In what situation we need to go for ldbs

rgds

p.kp

[andreas_mann3]

Hi,

ldb's can reduce your effort (selection-screen and select) . sometimes they offer additional structures (e.g. gseg by ldb SDF or anlcv by ada ) which will be useful !

regards Andreas

[Former Member]

Logical databases are used to

Encapsulate Open SQl and for Authority checks and code reusability.

[Former Member]

Logical databases can provide authority check whereas in other programs you have to code for this if you need to.

LDB can be helpful in creating a program which can be used by one or more programs...

Ps: Reward points if helpful.

[Former Member]

Hi paluri,

1. What is the logical database

Logical database is nothing

but a program only,

which provides the facility of

a)pre-defined seleciton secreen

b) facility for GETting records

(without knowint the databse tables)

2. logical databases use by HR ABAP. Is it right?

Yes, absolutely right. Its mostly used

in HR.

But it is also used now a days in other modules

like FI, SD.

3. But i heard that these will increase performnace of ur coding

Yes, it will increase the performanc,e

in the sense, that,

the SQL, FMs used for fetching from the database

is already fine tuned and written

into the already tested program of logical database.

regards,

amit m.

[Former Member]

HI,

Thanks Amit.

Do u have any screen document on this topic. Please send me if u have to this id shiva_krishnaprasad@yahoo.co.in

rgds

p.kp