Logical database definition

[Former Member]

Hi Experts ,

I am trying to execute a program with logical database .

It is showing error that logical database is unknown.

REPORT ZHRTRAIN.

tables :pernr.

Infotypes: 0002.

data: begin of name,

nachn like p0002-nachn,

vorna like p0002-vorna,

end of name.

select-options : nation for p0002-natio.

GET PERNR.

provide * from p0002 between pn/begda and pn/endda.

check nation.

move-corresponding p0002 to name.

condense name.

write : / p0002-pernr,

name,

p0002-natio,

p002-gebat.

endprovide.

Pls tell me how to correct this error.

Thank you.

Regds,

devika.

[naimesh_patel]

Have you assigned PNP as logical database in the attributes of the report.

To assign logical db to program, follow this steps

SE38 .. give program name.. select Attributes .. Change

Here you will see the field for the Logical database .

Assign the PNP here.

Regards,

Naimesh Patel

[Former Member]

HR Logical Databases

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

PNP

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

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.

See also:

HR InfoSets for InfoSet Query

InfoSets in the HR Application