Logical Database - PNP, PCH, PNPCE

[Former Member]

Hi Experts,

Im New ABAP HR,

I would like to know about the logical databases we are using .

Logical Database - PNP, PCH, PNPCE, basic principles

If any body cud let me know about the differences , requiremnts , associated with these Logical databses will be much helpful for me.

Thanks

Rohini Devi

bgrohinidevi@gmail.com

[Former Member]

i have one doubt .

i have 500 employees in organization , how to process  payroll for only 450 employess

[Former Member]

Hi,

You can have two payroll areas (say 'A' and 'B'), group those 450 employees under payroll area A and the remaining in payroll area B...run payroll only for payroll area A.

Hope this helps.

Thanks,

Sriram

[Former Member]

if one payroll area (like 'A'), how to run payroll.

[Former Member]

i have another doubt,,

if i am using pnp in OM ? what use of Pch LDB ?

[Former Member]

Solved myself.

[Former Member]

Hi,

See the documentation in the transaction code -SE36 by putting each logical databases.

Have a look at this links also.

http://help.sap.com/saphelp_46c/helpdata/EN/c6/8a15381b80436ce10000009b38f8cf/content.htm

Reward points if helpful

Regards,

Manoj.

[Former Member]

hi ,

The LDB is special type of ABAP program that combines the contents of certain related database tables and retrieve some related data and make it available to application programs.

In other words, a LDB is a method by which ABAP programs read and process the data. The sequence in which the data is supplied to the program is determined by a tree structure.

The LDB usually consists of the following components.

Structure

Selections

Database programs

A logical database can contain a maximum of 300 tables

Functions of LDB:

Data retrieval :

The personnel data of each employee is loaded into the main memory where it can be accessed for processing.

Screening :

Employees can be selected according to the organizational criteria entered on the selection screen.

E.g...Hourly wage earners in a particular personnel sub area

Authorization check : This ensures that the person starting the evaluation Is authorized to access the report data.

Not only for authority checks for fetch LDB's are used to data also we use LDB's. they provide selection screen by default.HR data is stored in cluster tables so to retrieve data we use LDb's and macros etc

in HR ABAP WE have LDBs like PNP , PCh, PAP.

this will used for

pnp is for PA And TM reporting

Logical database

A logical database is a special ABAP/4 program which combines the contents of certain database tables. Using logical databases facilitates the process of reading database tables.

HR Logical Database is PNP

Main Functions of the logical database PNP:

Standard Selection screen

Data Retrieval

Authorization check

To use logical database PNP in your program, specify in your program attributes.

Standard Selection Screen

Date selection

Date selection delimits the time period for which data is evaluated. GET PERNR retrieves all records of the relevant infotypes from the database. When you enter a date selection period, the PROVIDE loop retrieves the infotype records whose validity period overlaps with at least one day of this period.

Person selection

Person selection is the 'true' selection of choosing a group of employees for whom the report is to run.

Sorting Data

· The standard sort sequence lists personnel numbers in ascending order.

· SORT function allows you to sort the report data otherwise. All the sorting fields are from infotype 0001.

Report Class

· You can suppress input fields which are not used on the selection screen by assigning a report class to your program.

· If SAP standard delivered report classes do not satisfy your requirements, you can create your own report class through the IMG