topic Logical Database in Application Development and Automation Discussions

Logical Database

Former Member — Thu, 06 Jul 2006 07:41:52 GMT

How do we create a new Logical Database which can include the tables which we want to use?

Re: Logical Database

Former Member — Thu, 06 Jul 2006 07:43:22 GMT

You can create your own LDB in transaction SE36.

Re: Logical Database

Former Member — Thu, 06 Jul 2006 07:44:13 GMT

Please got through the link where you can find how create or modify logical database.

http://www.datamanagementgroup.com/Resources/Articles/Article_1005_2.asp

check..

Re: Logical Database

Former Member — Thu, 06 Jul 2006 07:44:33 GMT

Hi,

these are the steps to create logical DB. I'm taking example of ekko and ekpo.

1. transaction code SLDB.

2.enter name z<ldb-name>

3.create

4.short text

5.create

6. name of root node (here Ekko)

7. enter short text (f6)

8.node type -> data base table.

9.create

10 change logical DB

riht click on ekko and insert node

here node name ekpo

11.create

12. click on selections

13. press no Should the changed structure of Z<ldb name> be saved first.

14.select tables which you want to join.

15.transfer

16 now you have to o to coding part.

17. save

activate.

19.click to src code

double click on first include and activate

regards,

Sumit.

Re: Logical Database

Former Member — Thu, 06 Jul 2006 08:43:40 GMT

Cluster Tables cannot be used for Table Join.

But can we use a Cluster Table as root node in Logocal database??

Re: Logical Database

Former Member — Thu, 06 Jul 2006 09:21:19 GMT

If I want to define my own Select Options then how to do?

Because if I am trying to click on 'Selections'Tab it says 'Should the selections of logical database ZGL be generated from the structure?' and if I click 'No'it does not proceed.

What to do in this case?

Re: Logical Database

andreas_mann3 — Thu, 06 Jul 2006 09:28:56 GMT

hi,

have a look here: <a href="http://help.sap.com/saphelp_47x200/helpdata/en/9f/db9bed35c111d1829f0000e829fbfe/frameset.htm">ldb</a>

and here: <a href="http://help.sap.com/saphelp_47x200/helpdata/en/9f/db9c2e35c111d1829f0000e829fbfe/frameset.htm">Editing Selections</a>

Message was edited by: Andreas Mann

Re: Logical Database

Former Member — Thu, 06 Jul 2006 09:40:54 GMT

Hai Anurita

Check the following document for creating Logical Database

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

good info about Logical Database. you can check the link.

http://www.geekinterview.com/question_details/1506

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

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

Functions for displaying and changing logical databases:

Call Transaction SE36 or

Choose ABAP Workbench -> Development -> Programming environ. -> Logical databases

Interaction between database program and report:

During program processing, subroutines are performed in the database program and events are executed in the report.

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

The programmer need not worry about the primary key for each table.Because Logical database knows how the different tables relate to each other,and can issue the SELECT command with proper where clause to retrieve the data.

i)An easy-to-use standard user interface.

ii)check functions which check that user input is complete,correct,and plausible.

iii)meaningful data selection.

iv)central authorization checks for database accesses.

v)good read access performance while retaining the hierarchical data view determined by the application logic.

disadvantages:-

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

1. transaction code SLDB.

2.enter name z<ldb-name>

3.create

4.short text

5.create

6. name of root node (here Ekko)

7. enter short text (f6)

8.node type -> data base table.

9.create

10 change logical DB

riht click on ekko and insert node

here node name ekpo

11.create

12. click on selections

13. press no Should the changed structure of Z<ldb name> be saved first.

14.select tables which you want to join.

15.transfer

16 now you have to o to coding part.

17. save

activate.

19.click to src code

double click on first include and activate

Thanks & regards

Sreeni

Message was edited by: Sreenivasulu Ponnadi