SAP FAQ - Frequently Asked Questions

Quick internal links for our pages with SAP tips & tricks:

SAP HR PA | SAP HR Payroll | SAP ABAP and BW

SAP HR

PA – PERSONNEL ADMINISTRATION

Logical Databases in SAP HR - PNPCE PCH PAP
Description 
A layer above the physical database lies the hr logical databases called PNPCE, PCH and PAP. Logical databases contain data tables from sub-modules of sap hr.
- PNPCE logical database contain data tables (HR Master Data & Time Data) infotypes 0000-0999 and 2000 to 2999)
- PAP logical database contains data tables of Recruitment (4000-4999)
- PCH logical database depends upon whether the object type is specified or not (for Personnel Planning and Development)

You should know when to choose between the PNP and the PCH logical databases when building your report or query and the key is whether you want the primary key for selection to be the personnel number or the object type.If the primary key is to be the PERNR ( personnel number) then you should select the PNP logical database and if you want it to be any object type like O - org unit, S- position, C- job ,L- Business Event Group, D- Business Event Type E- Business Event?.etc)
This means if you want to query by employee the business events attended, you choose PNP, and if you want to know for certain specific business events who are the attendees, you choose PCH logical database to build your query,program or reports.
 

Posting dateApr, 2009