LSO course completion table

[Former Member]

Hello All,

I need to rebook employees in a course that an employee has taken and it's qualification is expiring.

But I am not able to figure where this information is stored that the course has been completed.

Based on which I can rebook the employee to that course if the qualification is about to expire.

Thanks,

Ritika 

[former_member201275]

check below tables.

LSOLEARNING_C (Course Completion)

LSOTACLRNASSRES  (obsolete in LSO200: Test Completion -Test Results)

HRPAD34 ( Additional Data for Relationship 'has attended')

HRPAD25  (Additional data PAD25)

HRP1001  ( Infotype 1001 DB Table)

[Former Member]

HI Ritika,

Table "LSOLEARNING_C" can be used for checking first and last date of the course conducted.

In Case if you are looking whether the participants attended / completed the course you can check below logic and modify it as per your requirement.

      SELECT * FROM hrp1001 INTO TABLE it_hrp1001

                                 WHERE otype = 'E' AND
                                               objid = wa_part-eveid AND
                                               plvar = '01' AND
                                               relat = '025' AND
                                               sclas = 'P' .

      IF sy-subrc = 0 .
        SELECT SINGLE delet FROM hrp1026
                                              INTO lv_delete
                                              WHERE plvar = '01' AND
                                                            otype = 'E' AND
                                                            objid = wa_part-eveid AND
                                                            delet = 'X' .

        IF sy-subrc = 0 .
          * Participants has completed the course
        ENDIF.
      ENDIF.

-Swet Bhushan