topic Re: Logical Database in Application Development and Automation Discussions

Logical Database

Former Member — Fri, 07 Jul 2006 03:44:06 GMT

Can somebody helps me learning more about 'Logical Database'? If anyone give me link that will also be helpful.

Regards,

Subhasish

Re: Logical Database

Former Member — Fri, 07 Jul 2006 03:49:23 GMT

Hi,

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

Hope that helps.

Regards,

Tanveer.

<b>Please mark helpful answers</b>

Re: Logical Database

Former Member — Fri, 07 Jul 2006 03:50:17 GMT

Here is from the help

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

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

Regards,

Ravi

Note : Please mark all the helpful answers

Re: Logical Database

Former Member — Fri, 07 Jul 2006 03:57:18 GMT

GOOD

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.

Reading a SAP standard logical database (DB M - MRP Documents) in your ABAP/4 program.

start-of-selection.

get is equal to select * from....

get mdkp.

check field-name.

get mdtb.

check field-name

end-of-selection.

GO THROUGH THIS LINK

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

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

THANKS

MRUTYUN

Re: Logical Database

ferry_lianto — Fri, 07 Jul 2006 04:05:03 GMT

Hi Subhasish,

Please check this online document (starting page 1163).

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCABA/BCABA.pdf

Hope this will help.

Regards,

Ferry Lianto

Please reward points if helpful.

Re: Logical Database

Former Member — Fri, 07 Jul 2006 04:10:03 GMT

look here:

LOGIGAL SYSTEM means usually the SLD entry "logical system" resp the name which is given by customizing in transaction SALE. It is only used for IDoc traffic. I dont know where you found that in the proxy.

Proxy deoes not require any logical name of the system. This is the entry made in transaction SALE.

Refer to following weblog for proxy.

/people/vijaya.kumari2/blog/2006/01/26/how-do-you-activate-abap-proxies - Activate Proxy

/people/siva.maranani/blog/2005/04/03/abap-server-proxies - ABAP Server Proxy

/people/ravikumar.allampallam/blog/2005/03/14/abap-proxies-in-xiclient-proxy - ABAP Client Proxy

Check this demo of ABAP Proxy.

https://www.sdn.sap.com/irj/sdn/docs?rid=/webcontent/uuid/110ff05d-0501-0010-a19d-958247c9f798#xi [original link is broken]

Logical databases are special ABAP programs that retrieve data and make it available to application programs. The most common use of logical databases is to read data from database tables by linking them to executable ABAP programs.

However, from Release 4.5A, it has also been possible to call logical databases using the function module LDB_PROCESS. This allows you to call several logical databases from any ABAP program, nested in any way. It is also possible to call a logical database more than once in a program, if it has been programmed to allow this.

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 using an interface work area.

Tasks of Logical Databases

1.Reading the same data for several programs.

2.Defining the same user interface for several programs.

3.Central authorization checks

4.Improving performance

First part of your question

So,if i am not wrong, LDB cannot be completely considered as object oriented programmming.

I have highlighted some important points above

For understanding this in detail you can go through the sap help .(if you donot know go through the below path

sap library

+ Basis Components

-Abap Programing and runtime enviornment

-BC-ABAP Programming(noe serach for ldb

Here I am mentioning a link which shows a complete implementation of an LDB.

http://homepages.wmich.edu/~r2raviko/HandsOnQuest/HO9.doc

I suppose after going through the reply(or sap help) and the link mentioned above all your doubts regarding LDB will be cleared.

For Logical database

http://help.sap.com/saphelp_46c/helpdata/en/9f/db9bed35c111d1829f0000e829fbfe/frameset.htm

very useful

http://help.sap.com/saphelp_46c/helpdata/EN/35/2cd77bd7705394e10000009b387c12/frameset.htm

Re: Logical Database

Former Member — Fri, 07 Jul 2006 05:26:48 GMT

Hi subhashish,

1. A logical database is in fact

a program only.

2. This LDB provides two main things :

a) a pre-defined selection screen

which handles all user inputs and validations

b) pre defined set of data

based upon the user selection.

3. So we dont have to worry about from

which tables to fetch data.

4. Moreover, this LDB Program,

handles all user-authorisations

and is efficient in all respects.

5. tcode is SLDB.

*----

1. To get a taste of it.

2. create a new z program.

3. while creating type PNP

in logical database field.

4. paste this code and execute.

REPORT ABC.

*----

infotypes : 0001.

TABLES : PERNR.

*----

GET PERNR.

WRITE 😕 PERNR-PERNR.

5. The selection screen which u see

is coming from logical database PNP program.

6. Execute

7. U will get a list of pernr.

SAPDBPNP

this is the main program of LDB PNP

which does the main work.

SAPDB + ldb name.

regards,

amit m.

Re: Logical Database

Former Member — Fri, 22 Jun 2007 10:28:53 GMT

hi there

try this might of some help

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

anuj