Table for storing Pre-Selection Activities

[Former Member]

I want to run a report to display candidate names who have have received the activity Management Ranking.

What table are the activities stored in?

[NicoleGeischnek]

Hi Jenny,

see thread http://scn.sap.com/thread/1963851

Regards,

Nicole

[romanweise]

Linking to a thread which is again linking to an outdated data model, buhhh - just kidding , please don't be mad at me Nicole

In addition to the link provided by Nicole,

activities are stored in infotypes. Which infotype is used is depending on the category assignment to the activity type. The process(es) the activity type is assigned to does not matter.

Infotype	Database table	Activity category Id	Activity category description
5135	HRP5135	01	Simple Activity
5136	HRP5136	02	Simple Correspondence
5137	HRP5137	03	Qualifying Event
5138	HRP5138	04	Invitation
5139	HRP5139	05	Status Change
5140	HRP5140	06	Data Transfer
5141	HRP5141	07	Questionnaire
5142	HRP5142	08	Classification (=Ranking)
5143	HRP5143	09	Confirmation
5144	HRP5144	10	Background Check
5145	HRP5145	11	Parsing

The information which activity type is assigned to which activity category can be taken from table T77RCF_ACT_TYPE.

Kind Regards

Roman

[Former Member]

Roman, thank you for your assistance with this.