How to get jobs,positions assigned to an vacancy ?

[Former Member]

Hi,

Is there any relation betwenn applicant vacancy and postion(pb4002-objid).

I have pb4002-objjid, i need to get Position and job in relation to that.

What is the order and how to get it ?

Actaully i need all the essential and additional qualifications assgned to the job for the postion which is assned to an vacancy for the applcant.

Please reply ASAP.

Regards,

Rama.P

[Former Member]

Thank you for all for helping us.

[paul_davidson]

Hi Rama,

Go back to square 1....Use the Position to create the Vacancy! Set T77S0 PPVAC PPVAC to "1". Then every time a person transfers or is terminated from a Position, a Vacancy is created. The Vacancy is tied to the Position via IT1007 and all other relationships with the Position, such as Job and Organizational Assignment are maintained. The Vacancy is maintained in table T750X which sets up the interface to Recruitment.

Paul

[Former Member]

SELECT * INTO IT_HRP1001 FROM HRP1001 WHERE OBJID = pb4002-objjid AND OTYPE = 'S' AND RSIGN = 'B' AND RELAT = '007'

AND SCLAS = 'C'.

SELECT * FROM HRP1001 WHERE OBJID = IT_HRP1001-SOBID AND OTYPE = 'C' AND RSIGN = 'A' AND RELAT = '031' AND SCLAS = Q.

If HRP1001-PRIOX = 1.

i_TAB-quali = HRP1001-SOBID.

i_TAB-required = 'X'.

APPEND i_TAB.

CLEAR i_TAB.

ELSE.

i_TAB-quali = HRP1001-SOBID.

i_TAB-required = ' '.

APPEND i_TAB.

CLEAR i_TAB.

ENDIF.

ENDSELECT.

ENDSELECT.

Dilek