Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Vacancy Report

Former Member
0 Kudos

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?

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

1 REPLY 1

Former Member
0 Kudos

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