topic Re: Difference between PNP and PCH logical database in Application Development and Automation Discussions

Difference between PNP and PCH logical database

abdulazeez12 — Tue, 17 Jul 2007 07:02:36 GMT

WHats the difference between PNP nd PCH? When to use which??

Re: Difference between PNP and PCH logical database

Former Member — Tue, 17 Jul 2007 07:07:16 GMT

chk this link

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

PNP is used most of the time as it gives fast result and it is best suited to the task of selecting persons.

Re: Difference between PNP and PCH logical database

Former Member — Tue, 17 Jul 2007 07:11:08 GMT

Hi,

The Difference is only with in an SAP R/3 system in which Concurrent Employment is active, reports are executed by the PNPCE logical database. The general logic of the PNPCE logical database corresponds to the PNP logical database. The PNPCE logical database can also process the concept of Concurrent Employment.

HR Logical Databases

In Human Resources (HR), the following logical databases can be used as a data source for HR InfoSets:

PNP (PNPCE)

PAP

PCH

By selecting a logical database, you determine the HR data that can be reported on using an InfoSet.

Logical Database PCH

This logical database generally enables you to report on all HR infotypes. However, you are advised not to use this logical database unless you want to report on Personnel Planning data.

Logical Database PNP (or PNPCE)

Use logical database PNP to report on HR master data. It is possible to use logical database PCH to access this data, but PNP meets such reporting requirements more quickly because it is best suited to the task of selecting persons.

Logical database PNP enables you to access HR master data and infotypes from Personnel Planning. For example, you have the following options:

Reporting on the costs, number of attendees booked, and instructor for a business event on which an employee is booked

Reporting on working time and planned compensation for a position that an employee occupies

Reporting on the validity and proficiency of a qualification that an employee fulfils

From a technical perspective, this means you can use PNP to report on all of the infotypes that exist for objects (infotype 1000) that have a direct relationship (infotype 1001) with the Person object.

The ability to access infotypes from Personnel Planning using logical database PNP is a special feature that you can only use in the context of SAP Query and Ad Hoc Query. You cannot use this functionality for ABAP reports you programmed yourself.

You can also use logical database PNP to report on data from Personnel Time Management (infotypes 2000 to 2999) and Payroll (special payroll infotypes for the USA and customer infotypes; for more information, access Customizing for the Human Resources Information System and see Payroll Results).

Logical Database PAP

Logical database PAP enables you to access data from Recruitment.

Check this link for more details

http://help.sap.com/saphelp_erp2004/helpdata/en/e1/e1f83f6e5a11d687620000e82158f1/frameset.htm

<b>Reward points</b>

Regards

Re: Difference between PNP and PCH logical database

Former Member — Tue, 17 Jul 2007 07:12:59 GMT

hi,

PNP -> organizational management.

Used when the program deals with recrutment, payroll etc..

PCH -> Personnal Planning.

Rgds

Reshma

Re: Difference between PNP and PCH logical database

Former Member — Tue, 17 Jul 2007 07:13:27 GMT

We use PNP LDB in most of the HR reports in Personal admn and Payroll reports

and PCH is used in Personal Planning

See the doc for PNP LDB

HR Master Data

In future, the PNPCE logical database should be used for new developments instead of the PNP logical database.

Description

The logical database PNP performs the following functions in Reporting:

provides the standard selection screen for the HR master data

makes the specified selections

checks whether the user has the necessary authorizations to read the data

The logical database is assigned to a report by maintaining the "Logical database PNP" report attribute.

The selection screen can then be created by assigning a HR report class.

In the report itself, the persons, along with the specified infotypes at the GET PERNR event are retrieved from the logical database in accordance with the selections entered. Furthermore, the system checks the authorization for data access.

You can use the GET PAYROLL event to evaluate payroll results.

Requirements

The structure PERNR must be declared in the TABLES statement.

If you use the GET PAYROLL event, the hrpy_rgdir and hrpy_wpbp tables must be stored in the TABLES statement. The PAYROLL structure is completed using the NODES statement. Enter 900 for the selection screen. This ensures that the personnel numbers at the GET PERNR event are selected using payroll results and not master data. Use PAYROLL as the report class. A sample report is EXAMPLE_PNP_GET_PAYROLL, and you can find additional information in the report documentation.

see the doc of the PCH LDB

The database driver SAPDBPCH fulfils the following functions in reporting:

It provides the standard selection screen for planning data.

It retrieves data from the file PLOG and carries out the chosen selections.

It checks that the user has the required authorization to read the data.

You activate the database driver by maintaining the report attributes 'Logical Database PC Application H'. From here you access the report generally via the standard selection screen.

In the report itself, from the point of GET OBJEC, the database driver retrieves the chosen selections from the file PLOG as stipulated and checks the authorization.

The structure declaration OBJEC in the TABLES instruction is the prerequisite. If, in addition to the structure OBJEC, the structure GDSTR is defined, the parameter for structure evaluation is added to the standard selection screen. This enables structure evaluations via evaluation paths.

<b>Reward points for useful Answers</b>

Regards

Anji