What is Logical Database (LDB) in SAP ABAP HR ? How it is advantageous over normal report ?

 1. LBD is a hierarchical structured table that retrieves several tables collectively and brings them and stores them in RAM to filter the selected output.

2. The T-code is SE36.

3. The three main concepts involved in LDB are :

a )Selection screen

b )Authorization check

c )Fetching up of data.

Advantage of Logical databases:

1-Less coding s required to retrieve data compared to normal internal tables.

2-Tables used LDB are in hierarchical structure.

Types of LDBs

PNP

PNP is a logical database in SAP ABAP HR which is mainly used for administering human resources, time management of human resources and payroll processes.

PNPCE

This is a customized version of PNP which handles the payroll, time management and administration of human resources with concurrent employment functions.

PCH

This SAP ABAP HR logical database handles data pertaining to organizational management, event management, and training & personality development duties of an organization.

PAP

This is a logical database in SAP ABAP HR which is dedicated to the recruitment process of human resources.

Sample structure of basic ABAP-HR report program

REPORT zreport.

INFOTYPES: 0001.       “This is the info type declaration area

TABLES: pernr.         “Key fields for Personnel Admin infotypes

START-OF-SELECTION.

GET PERNR.             “Get PERNR gets all data related to a PERNR

PROVIDE * FROM P0001 BETWEEN PN-BEGDA AND PN-ENDDA.

WRITE:/ P0001-PERNR,

        P0001-STELL,

        P0001-BEGDA.

ENDPROVIDE.

Infotypes are basically used to group related together. They provide information and store data for specific time periods. In the above sample program the INFOTYPE statement declares an internal table which is populated at the GET PERNR event.

For example if we have

INFOTYPE: 0001.

This instruction creates an internal table with structure p0001 and which is filled at the GET PERNR event. We also add MODE N to this instruction.

INFOTYPE: 0001 MODE N.

The addition of MODE N restricts data from filling into the internal table at GET PERNR.

GET PERNR statement is basically an event which triggers the data read operation into respective infotypes which have declared by using the INFOTYPES statement for each PERNR (Personnel Number) that satisfies the selection criteria.