logicacl database

[Former Member]

hi,

what are logical database

[Former Member]

Hi

Logical Databases are some form of tables linked logically from the user oriented view.

Say we have three Database tables, Zemployee, Zdepartment, Zsalary.

We create all these three tables in the database, but when we need to have these tables as a together to be accessed in a program we go for the creation of the LDB.

LDB creation is done from the t.code SE36.

Here you include the list of tables in hierarchical fashion.

Say,

ZEmployee

ZDepartment

Zsalary.

You can also define selection-screens in the LDB, so that when a program uses thi LDB by default that selection screens can be used.

An Executable program can have the usage of LDB.

During program creation we link the program with the desired LDB.

We can also link the program to several LDB's.

Hopefully this gives a little overview of the LDB.

Reward if helpful

[Former Member]

Hi,

Logical data base is nothing but combination of tables. If u want join some tables regularly in various programs, instead of joining those everytime dynamically in your program u will use the logical database.

Ex In se36 tr code check this logical database S1L_OLD. This table is combination of MARA, MARC MAKT...

Thanks and Regards,

Surya

[Former Member]

the use of logical database reporting is ..

actually we get data from database to application server every time.

with logical systems we keep some tables in the application server and get the data from that application server at that time perfomence increses.actually this type things used in hr-abap.