cancel
Showing results for 
Search instead for 
Did you mean: 

Training History in SAP Training & Event Management

Former Member
0 Kudos

Dear Experts,

I have a requirement to get training history from SAP Training & Event Management that describes the Training that employee has completed in a period of time. How do I get it?

Thank you for your kind respond.

Best Regards,

Erli Hartono.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Pavan and Ramya,

Thank you for your respond.

Actually what I need is the table that contains the history of completed training attended by employees. Could you please let me know the specification of table and field to get the completed training?

Thank you.

Best Regards,

Erli Hartono

Former Member
0 Kudos

Hi,

Please check the HRP1000 table and HRP1001 .

If u want to write the query u can use this

Fetch the valid records with the dates.

SELECT objid otype plvar begda endda STEXT FROM hrp1000 INTO TABLE it_objid
WHERE otype = 'E'
AND plvar = '01'
AND begda GE PN-BEGDA
AND endda LE PN-ENDDA.

To get the list of attendees u can use this code.

SELECT objid sobid otype sclas from hrp1001

into table it_pid FOR ALL ENTRIES IN it_objid
WHERE objid = it_objid-objid
AND otype = 'E'
AND RSIGN = 'A'
AND RELAT = '025'.

and also check the table HRPAD34

and the link

http://scn.sap.com/thread/481929

Hope this will be helpful.

Regards,

Ramya Ramasamy

Former Member
0 Kudos

Hi Ramya,

Thank you for your very helpful answer.

Now what I want to ask if The Relationship A 025 between course and person means that the employee has attended the course and not just booked only? I want to make sure that the data I got is the training that has been attended by employee in a period of time. Could you tell me another relationship between Person and Course?

Thank you so much for your kind respond.

Best Regards,

Erli Hartono

Former Member
0 Kudos

Hi Erli,

025 relationship is for those who attended oly. If you have doubt Pls open tcode OOVK. There you can see all the relationships.

Regards,

Ramya Ramasamy

Former Member
0 Kudos

Hi Ramya,

Thank you for your respond.

I think the relationship A 025 can obtain the data that I need. Now I need to get the detail of the course location and vendor/provider of the course. Where could I get it?

Thank you so much.

Best Regards,

Erli Hartono

Former Member
0 Kudos

Hi erli,

You can fetch the Location with this sample code.

  SELECT sobid FROM hrp1001 INTO TABLE it_hr1001a FOR ALL ENTRIES IN it_objid

                                                             WHERE objid = it_objid-objid

                                                             AND otype = it_objid-otype

                                                             AND plvar = it_objid-plvar"'01'

                                                             AND sclas = 'F'

                                                             AND rsign = 'A'

                                                             AND relat = '024'

The same way you have to fetch the organizer with the relationship 36

Otype = E, sclas = 'U'.

Hope this will be helpful.

Regards,

Ramya Ramasamy

Former Member
0 Kudos

Hi Ramya,

Thank you so much for your answer.

Best Regards,

Erli Hartono.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi erli,

These are some of the tcodes.

S_PH9_46000434 - Attendee List

S_PH9_46000433 - Attendance List

S_PH9_46000432 - Employee List

S_AHR_61016215 - Bookings per Attendee

S_PH9_46000431 - Attendee's Training History (Tcode for Your Requirement)

S_PH9_46000426 - Attendees for Rebooking

S_ALR_87014085 - Attendance Statistics

You can find more tcodes

in sap easy access - > Human resources -> Training and event management -> information systems -> reports-> attendances.

Regards,

Ramya Ramasamy

Former Member
0 Kudos

Check this one

http://scn.sap.com/thread/860024

Thanks

Pavan