2007 Nov 02 11:57 AM
HI,
can u guys explain me what is logical database?....and its uses?..........
2007 Nov 02 12:02 PM
2007 Nov 02 12:01 PM
HI,
see this link
http://help.sap.com/saphelp_nw04/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/content.htm
rgds,
bharat.
2007 Nov 02 12:02 PM
2007 Nov 02 12:26 PM
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.
2007 Nov 02 1:04 PM
hii Steam,
you can find everything about LDBs here...
<a href="http://help.sap.com/saphelp_46c/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/content.htm">LDBs</a>
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
2007 Nov 02 1:37 PM
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>.
2007 Nov 02 1:49 PM
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.