topic HR Logical Database in Application Development and Automation Discussions

HR Logical Database

Former Member — Tue, 29 Jul 2008 07:01:07 GMT

Hi,

Is it common to use logical database for HR report?? How about other module such as SD/MM??

Regards,

Kit

Re: HR Logical Database

Former Member — Tue, 29 Jul 2008 07:02:30 GMT

hi,

LDB's are mainly used in HR ABAP. They have a pre defined Structure and a functionality to cater to the needs of HR ABAP programming.

Regards

Sumit Agarwal

Re: HR Logical Database

Former Member — Tue, 29 Jul 2008 07:03:12 GMT

Hi,

Generally LDB is used in HR report but it also depends on client.

There are already lots of LDB available in HR module so its better to use them than creating separate select Query and selection Screen..

Regards,

Sujit

Re: HR Logical Database

bpawanchand — Tue, 29 Jul 2008 07:04:11 GMT

LDB's are primarily used with HR module only

Regards

Pavan

Re: HR Logical Database

Former Member — Tue, 29 Jul 2008 07:04:52 GMT

Good

Except HR module no need to use the logical database for the other sap modules .You can use the normal database in the other SAP modules.

Thanks

mrutyun^

Re: HR Logical Database

Former Member — Tue, 29 Jul 2008 07:09:11 GMT

Hi Kit,

It is recommended to use only LDBs for HR reporting. Since the LDBs have their own Selection Screens, and any validations and authorizations are done by the system itself. This is very important for very sensitive data like HR.

Hope this helps you.

Regards,

Chandra Sekhar

Re: HR Logical Database

Former Member — Tue, 29 Jul 2008 07:22:32 GMT

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.

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. This is particularly useful for programs with type 1.

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.

Logical Databases - Views of Data

A logical database provides a particular view of database tables in the R/3 System. It is always worth using logical databases if the structure of the data that you want to read corresponds to a view available through a logical database.

The data structure in a logical database is hierarchical. Many tables in the R/3 System are linked to each other using foreign key relationships. Some of these dependencies form tree-like hierarchical structures. Logical databases read data from database tables that are part of these structures.

The diagram illustrates how the R/3 System might represent the structure of a company. A logical database can read the lines of these tables one after the other into an executable program in a sequence which is normally defined by the hierarchical structure. The term logical database is sometimes used to mean not only the program itself, but also the data that it can procure.

Tasks of Logical Databases

As well as allowing you to read data from the database, logical databases also allow you to program other tasks centrally, making your application programs less complicated. They can be used for the following tasks:

Reading the same data for several programs.

The individual programs do not then need to know the exact structure of the relevant database tables (and especially not their foreign key relationships). Instead, they can rely on the logical database to read the database entries in the right order during the GET event.

Defining the same user interface for several programs.

Logical databases have a built-in selection screen. Therefore, all of the programs that use the logical database have the same user interface.

Central authorization checks

Authorization checks for central and sensitive data can be programmed centrally in the database to prevent them from being bypassed by simple application programs.

Improving performance

If 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

Reward Points if useful

Raghunath.S

9986076729

Re: HR Logical Database

Former Member — Tue, 29 Jul 2008 07:24:18 GMT

For other Modules also .. LDB are their.. but most prefered in HR only..........

Reward Points if useful

Raghunath.S

9986076729

Re: HR Logical Database

Former Member — Tue, 29 Jul 2008 07:25:43 GMT

Whilst logical data bases are predominantly used in HR reporting you can use them in other reports. LBD can be found using SE36. LDB tend to take care of the authorisation asspect of programming.

You may find that if you use them in other parts of the system then you take the strain out of having to create your seletcion screen and program the select statements. Asset management reports apprear to be driven from the LDB.

They are there so that if you want to you can use them.

Jules