11 Replies Latest reply: May 22, 2008 2:51 PM by Naresh D RSS

LDB IN HR-ABAP

raghunandan mj
Currently Being Moderated

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

  • Re: LDB IN HR-ABAP
    Amit Mittal
    Currently Being Moderated

    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.

  • Re: LDB IN HR-ABAP
    Naresh D
    Currently Being Moderated

    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

     

  • Re: LDB IN HR-ABAP
    Naresh D
    Currently Being Moderated

    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

    • Re: LDB IN HR-ABAP
      raghunandan mj
      Currently Being Moderated

      PLEASE TELL ME IMP TCODES & ANY TABLE IN HR

      • Re: LDB IN HR-ABAP
        Naresh D
        Currently Being Moderated

        Hi Raghunandan,

         

        SAP HR Transaction Codes

         

        Master Data 

        PA10 - Personnel file

        PA20 - Display HR Master Data

        PA30 - Maintain HR Master Data

        PA40 - Personnel Events

        PA41 - Change Hiring Data

        PA42 - Fast Data Entry for Events

        PRMD - Maintain HR Master Data

        PRMF - Travel Expenses : Feature TRVFD

        PRML - Set Country Grouping via Popup

        PRMM - Personnel Events

        PRMO - Travel Expenses : Feature TRVCO

        PRMP - Travel Expenses : Feature TRVPA

        PRMS - Display HR Master Data

        PRMT - Update Match code

        PS03 - Info type Overview

        PS04 - Individual Maintenance of Info types

         

        Time Management 

        PA51 - Display Time Data

        PA53 - Display Time Data

        PA61 - Maintain Time Data

        PA62 - List Entry of Additional Data

        PA63 - Maintain Time Data

        PA64 - Calendar Entry

        PA70 - Fast Data Entry

        PA71 - Fast Entry of Time Data

        PBAB - Maintain Vacancy  assignments

        PT01 - Create Work Schedule

        PT02 - Change Work Schedule

        PT03 - Display Work Schedule

         

        Payroll

        PC00 - Run Payroll

        PC10 - Payroll menu USA

        PE00 - Starts Transactions PE01 PE02 PE03

        PE01 - Schemas

        PE02 - Calculation Rules

        PE03 - Features

        PE04 - Create functions and Operations

        PE51 - HR form editor

        PRCA - Payroll Calendar

        PRCT - Current Settings

        PRCU - Printing checks USA

        PRD1 - Create DME

        SM31 - Maintain Table

        SM12 - Locked Secessions

        TSTC - Table Look up

        SPRO - IMG

        SE16 - Data Browser (Table Reports)

        PP03 - PD Tables

        PPOM - Change Org Unit

        PO13 - Maintain Positions

        PO03 - Maintain Jobs

         

        Benefits

        PA85 - Benefits - Call RPLBEN11

        PA86 - Benefits - Call RPLBEN07

        PA87 - Benefits - Call RPLBEN09

        PA89 - COBRA Administration

        PA90 - Benefits Enrollment

        PA91 - Benefits - Forms

        PA92 - Benefits Tables - Maintain

        PA93 - Benefits Tables - Display

        PA94 - Benefits - Access Reporting Tree

        PA95 - Benefits IMG - Jump to Views

        PA96 - Benefits reporting

        PA97 - Salary Administration - Matrix

        PA98 - Salary Administration

        PA99 - Compensation Admin - rel. Changes

        PACP - HR-CH : Pension fund, interface

         

        General Reporting

        PM00 - Menu for HR Reports

        PM01 - Dialogs in HR - Create Custom info types

        PRFO - Standard Form

        PSVT - Dynamic Tools Menu

        PAR1 - Flexible Employee Data

        PAR2 - Employee List

         

        Organizational Management

        PPOM - Change org Unit

        PO03 - Maintain Jobs

        P013 - Maintain Position

        PO10 - Maintain Organizational Unit

        PP01 - Maintain Plan Data (menu-guided)

        PP02 - Maintain Plan Data (Open)

        PP03 - Maintain Plan Data (Event-guided)

        PP05 - Number Ranges

        PP06 - Number Ranges Maintenance HR Data

        PP07 - Tasks/Descriptions

        PP69 - Choose Text for Organizational Unit

        PP90 - Setup Organization

        PP01 - Change Cost Center Assignment

        PP02 - Display Cost Center Assignment

        PP03 - Change Reporting Structure

        PP04 - Display Reporting Structure

        PP05 - Change Object indicators (O/S)

        PP06 - Change Object indicators OS

        PPOA - Display Menu Interface (with dyn.)

        PPOC - Create Organizational Unit

        PPOM - Maintain Organizational Plan

        PPOS - Display Organizational Plan

        PQ01 - Events for Work Center

        PQ02 - Events for Training Program

        PQ03 - Events for Job

        PQ04 - Events for Business Event Type

        PQ06 - Local Events

        PQ07 - Resource Events

        PQ08 - Events for External Person

        PQ09 - Events for Business Event Group

        PQ10 - Events for Organizational Unit

        PQ11 - Events for Qualification

        PQ12 - Resource Type Events

        PQ13 - Events for Position

        PQ14 - Events for Task

        PQ15 - Events for Company

        PSO5 - PD : Administration Tool

        PSOA - Work Center Reporting

        PSOC - Job Reporting

        PSOG - Org Mgmt General Reporting

        PSO1 - Tools Integration PA-PD

        PSOO - Organizational Unit Reporting

        PSOS - Position Reporting

        PSOT - Task Reporting

         

        Recruitment

        PB10 - Initial Entry of applicant master data

        PB20 - Display applicant master data

        PB30 - Maintain applicant master data

        PB40 - Applicant events

        PB50 - Display applicant actions

        PB60 - Maintain Applicant Actions

        PB80 - Evaluate Vacancies

        PBA0 - Evaluate Advertisements

        PBA1 - Applicant Index

        PBA2 - List of applications

        PBA3 - Applicant vacancy assignment list

        PBA4 - Receipt of application

         

         

        Infotype tabes :0000,0001,0002,0006,0007,4000,40001,40002 etc

        DB Tables      :PA0000,PA0001,PA0006,PA0007 etc

         

        ****Reward points if found useful

         

        Regards,

        Naresh

Actions