topic Re: re: logical database in Application Development and Automation Discussions

re: logical database

Former Member — Thu, 19 Jan 2006 07:06:34 GMT

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

Re: re: logical database

Former Member — Thu, 19 Jan 2006 07:09:50 GMT

hi,

check this link...

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

regards

vijay

Re: re: logical database

Former Member — Thu, 19 Jan 2006 07:10:52 GMT

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

Re: re: logical database

Former Member — Thu, 19 Jan 2006 07:12:05 GMT

Logical databases are used to

Encapsulate Open SQl and for Authority checks and code reusability.

Re: re: logical database

Former Member — Thu, 19 Jan 2006 07:20:17 GMT

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

Re: re: logical database

Former Member — Thu, 19 Jan 2006 07:29:52 GMT

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.

Re: re: logical database

andreas_mann3 — Thu, 19 Jan 2006 08:14:38 GMT

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

Re: re: logical database

Former Member — Thu, 19 Jan 2006 09:08:31 GMT

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.

Re: re: logical database

Former Member — Thu, 19 Jan 2006 09:36:13 GMT

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