topic Re: LOGICAL DATABASE in Application Development and Automation Discussions

LOGICAL DATABASE

Former Member — Fri, 02 Nov 2007 11:57:38 GMT

HI,

can u guys explain me what is logical database?....and its uses?..........

Re: LOGICAL DATABASE

Former Member — Fri, 02 Nov 2007 12:01:24 GMT

HI,

see this link

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

rgds,

bharat.

Re: LOGICAL DATABASE

Former Member — Fri, 02 Nov 2007 12:02:12 GMT

Plz check this thread:

Thanks

Vijay

PLZ reward points if helpful

Re: LOGICAL DATABASE

Former Member — Fri, 02 Nov 2007 12:26:01 GMT

HI,

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

Hope it is useful,

Thanks,

Sandeep.

Re: LOGICAL DATABASE

Former Member — Fri, 02 Nov 2007 13:04:05 GMT

hii Steam,

you can find everything about LDBs here...

to be more practical, LDBs in SAP are generally used with reports in HR module...

PNP and PNPCE LDBs are used generally in HR reports..

These LDBs have their own selection screena nd while used with GET event in the report...they automatically filter the selection screen data and they have authorisation checks as well...

They also provide better control over employee data access authorisation..

Reward useful answers,

Regards,

Tejas

Re: LOGICAL DATABASE

Former Member — Fri, 02 Nov 2007 13:37:59 GMT

Hi ,

Logical databases are special ABAP programs that retrieve data and make it available to application programs. 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.

<b>Reward Points if its usefull</b>.

Re: LOGICAL DATABASE

Former Member — Fri, 02 Nov 2007 13:49:00 GMT

Hi,

PLease go thru this link.

<a href="http://help.sap.com/saphelp_47x200/helpdata/en/9f/db9be035c111d1829f0000e829fbfe/frameset.htm">http://help.sap.com/saphelp_47x200/helpdata/en/9f/db9be035c111d1829f0000e829fbfe/frameset.htm</a>

Thanks,

Sri.