To find the latest record of an employee - HR

[Former Member]

Hi All,

How would you identify the latest record of an employee ?

There could be multiple records existing in PA 30 -

Actions Infotype.

How would you identify the latest action ?

Thanks in advance,

Archana

[ssimsekler]

Hi Archana

Infotype records are time dependent and this time dependency depends on three policies adjusted by customization. The guaranteed way to retrieve valid record for a given period contains the condition:

begda LE <selection_period_end_date> AND
endda GE <selection_period_begin_date>

However, infotypes which let overlapping records need another key field, namely "seqnr" to be considered.

Regards

*--Serdar <a href="https://www.sdn.sap.com:443http://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.sdn.businesscard.sdnbusinesscard?u=qbk%2bsag%2bjiw%3d">[ BC ]</a>

[Former Member]

Hi Archana!

For each action there must be a record in action infotype and corresponding Begda and Endda.

Go to the PA20.select action infotype for particular employee and press overview button, then u will get all records corresponding to each action type.U can find out the latest one from begda and endda.

Otherwise use the macro - RP-PROVIDE-FROM-LAST to get latest record as of Begda and Endda pa0000.

Regards,

Vijayakumar

[Former Member]

Hi Archana,

Please a make select based on the end date = 31.12.9999.

Hope it works

Regards

Satish Nair