LDB IN HR-ABAP

[Former Member]

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

[Former Member]

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.

[Former Member]

HELLO AMIT

STILL THERE ARE MANY LDB'S.I THINK

[Former Member]

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

[Former Member]

then what is LDB'S PHP,PAP

[Former Member]

Hi,

They are also related to HR module,

but they are specifically related NOT to employees,

but for recruitment purpose - Applicant master data.

regards,

amit m.

[Former Member]

HI,

THEN PCH IS FOR PD KNOW

[Former Member]

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

[Former Member]

PLEASE TELL ME IMP TCODES & ANY TABLE IN HR

[Former Member]

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

[Former Member]

U HAVE HELPED ME A LOT ..THANK U VERY MUCH.

[Former Member]

Hi Raghunandan,

Please close the thread by allotting suitable points.

Regards,

Naresh