what is a logical database

[#1]

Hi All,

what is a logical database? what is the use of it.

[Former Member · Accepted solution]

Hi again,

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.

Message was edited by: Amit Mittal

[Former Member · Accepted solution]

Hi Amit,

This is bhanu.

I got a problem while creating the logical database.

while creating the structure, when i go for save its giving a runtime error (i.e CONVT_NO_NUMBER).

please help me out.

Thank u.

[Former Member]

hi,

Logical database provides read-only access to a group of related tables to an ABAP/4 program.

regs,

jaga

[Former Member]

Hi please go the following site to find more info abt it.

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

Logical Database - SE36

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.

Satish

[suresh_datti]

Hi Lisa,

The Transaction Code to mainatin & Display Logical a Database is SE36.

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.

Here is an example to Read a SAP standard logical database (DBM - 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.

Regards,

Suresh Datti

[Former Member]

Hi Lisa,

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.

Regards,

Amit M.

Message was edited by: Amit Mittal

[Former Member]

To read data from a database tables we use logical database. A logical database provides read-only access to a group of related tables to an ABAP/4 program.

Advantages: i)check functions which check that user input is complete, correct,and plausible. ii)Meaningful data selection. iii)central authorization checks for database accesses. iv)good read access performance while retaining the hierarchical data view determined by the application logic. dis advantages: i)If you donot specify a logical database in the program attributes,the GET events never occur. ii)There is no ENDGET command,so the code block associated with an event ends with the next event statement (such as another GET or an END-OF-SELECTION).

[Former Member]

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.

Please check the follwoing link.

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

Hope This Info Helps YOU.

<i>Reward Points If It Helps YOU.</i>

Regards,

Raghav