Skip to Content
author's profile photo Former Member
Former Member

Logical database definition

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Nov 26, 2007 at 03:51 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 26, 2007 at 03:52 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.