Vacancy Report

[Former Member]

Hi guys,

i need some data from the vacancy, but i cant determine exactly from wich table may i get the data,

i think is hrp1007, but i can determine wich vacancies are open and wich closed, i tried endda = '99991231' and Status = '0' (open) but the rows does not match with the ones i get from pbay (vacancy standard report).

Any ideas?

[Former Member]

Hi guys,

i need some data from the vacancy, but i cant determine exactly from wich table may i get the data,

i think is hrp1007, but i can determine wich vacancies are open and wich closed, i tried endda = '99991231' and Status = '0' (open) but the rows does not match with the ones i get from pbay (vacancy standard report).

Any ideas?

[Former Member]

Javier,

I have a Z program to read vacancies, and the select is like this:

  SELECT otype objid status begda endda
  INTO CORRESPONDING FIELDS OF TABLE it_hrp1007
  FROM hrp1007
  WHERE 
  AND endda >= SY-DATUM
  AND begda <= SY-DATUM
  AND otype  EQ 'S'       "object type: position
  AND objid  IN s_objid   "IDs of positions
  AND status IN s_status. "it is char(1), 0 -> open, 2 -> filled

Let me know if that helped you (=

Regards