Skip to Content
avatar image
Former Member

LDB IN HR-ABAP

LIST LDB'S CONCERNED TO THE DIFFERNENT PARTS OF HR MODULE LIKE PP,PA,OM ,PLEASE

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    May 22, 2008 at 12:20 PM

    Hi Raghunandan,

    Different Logical databases in HR

    PNP

    PNPCE

    PAP

    PCH

    The logical database, PNP, consists of the database driver, SAPDBPNP , and is activated using the report attributes.

    It fulfils three main functions:

    Data retrieval: HCM data is written for each employee to the main memory,

    where it can be processed.

    Screening: A selection screen enables you to select employees in accordance

    with the organizational criteria. For example, you can select all the hourly

    wage earners of a particular personnel subarea.

    Authorization check: The implicit authorization check is another advantage

    of the logical database. Personnel data is frequently confidential and it is not

    fruitful to allow all programs to carry out the authorization check.

    To enable the concurrent employment function, you must use the logical database,PNPCE.

    And in brief,

    The following assignments between components and logical databases apply:

    HR-Administration: PNP or PNPCE

    Time Management: PNP or PNPCE

    PayrollPNPorPNPCE

    Recruitment: PAP

    Personnel Development: PCH

    Organizational Management: PCH

    Training and Event Management: PCH

    *Reward points if found useful

    Regards,

    Naresh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 22, 2008 at 12:07 PM

    Hi,

    1. There are mainly two ldbs.

    2.

    PNP HR Master Data

    PNPCE HR Master Data (Incl. Concurrent Employment)

    PNPCE is the new one, which is more better

    and a replacement of PNP.

    Depending upon the INFOTYPES we declare in our program,

    related to PP,PA,OM etc, it will fetch those data.

    regards,

    amit m.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 22, 2008 at 12:10 PM

    Hi Raghunandan

    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.

    Data Retrieval from LDB

    1. Create data structures for infotypes.

    INFOTYPES: 0001, "ORG ASSIGNMENT

    0002, "PERSONAL DATA

    0008. "BASIC PAY

    2. Fill data structures with the infotype records.

    Start-of-selection.

    GET PERNR.

    End-0f-selection.

    Read Master Data

    Infotype structures (after GET PERNR) are internal tables loaded with data.

    The infotype records (selected within the period) are processed sequentially by the PROVIDE - ENDPROVIDE loop.

    GET PERNR.

    PROVIDE * FROM Pnnnn BETWEEN PN/BEGDA AND PN/ENDDA

    If Pnnnn-XXXX = ' '. write:/ Pnnnn-XXXX. endif.

    ENDPROVIDE.

    Period-Related Data

    All infotype records are time stamped.

    IT0006 (Address infotype)

    01/01/1990 12/31/9999 present

    Which record to be read depends on the date selection period specified on the

    selection screen. PN/BEGDA PN/ENDDA.

    Current Data

    IT0006 Address - 01/01/1990 12/31/9999 present

    RP-PROVIDE-FROM-LAST retrieves the record which is valid in the data selection period.

    For example, pn/begda = '19990931' pn/endda = '99991231'

    IT0006 subtype 1 is resident address

    RP-PROVIDE-FROM-LAST P0006 1 PN/BEGDA PN/ENDDA.

    *Reward points if found useful

    Regards,

    Naresh

    Add comment
    10|10000 characters needed characters exceeded