Extracting data from Hr tables (recruitment module tables)

[Former Member]

Hi Gurus,

Can anyone help me how to extract unique data from the hr recruitment module tables (PB****) by giving PERNR (applicant number) as input.

Thanks in advance.

G.Vamsi Krishna

[Former Member]

Hi,

To retrieve the data from recruitment tables PB**** you can use the logical database PAP. It is a standard logical database.

How to use it.

1. Goto se38.

2. Give a program name.

3.press on the attribute radio button and click on create.

4.Please provide the appropriate details.

5.Also specify the logical database name 'PAP' in the field provided for the entry of logical database.

6.Press on save.

REPORT  zpap_ldb_test.


TABLES : applicant.
INFOTYPES : 4000,4001. "declaring the data structure for data storage fetching PB4000 & PB4001



START-OF-SELECTION.

GET applicant.     "Filling the details to the data structure.

  WRITE : p4001-refem.

END-OF-SELECTION.

For more information refer the link given below.

http://sap-hr-abap.blogspot.in/2012/01/basvuru-durumu-izleme-ornek-abap.html

With Regards,

Alenlee MJ.

[Former Member]

Hi Alenlee,

Thanks for the reply it was helpful, but i got the issue resolved in the other way. The HR module is really logical and typical , In HR module based on the types of applications we use i.e, "PA" or "PB" we can assume the tables names. Its simple the table name will be the type of the application we are using , joined with the infotype. Eg. <PB>+<1006> = PB1006 is a table for the PB application.

Kind Regards,

G.VamsiKrishna.