Tracking, saving and after-the-fact actions of test scores via the Portal to be used by Instructors and Test administrator

Purpose: – SAP LSO is equipped with the ability to track and save the Online Exams via Portal or in ECC. But it does not have the mechanism to track or save the results of the Instructor Led Course Exams. As part of a client’s project requirements, AspireHR designed a Portal-based application and and ECC application. This article is outline of the solution used to track the progress of the Instructor Led Examinations.

Main Components: –

1)      Custom Z table for Initial Entry of Test Scores

2)      Custom Z table for Change of Test Scores

3)      ECC transaction to enter/change test scores

4)      Transactional  iView to enter/change text scores

5)      Imparts Qualifications

Z Tables: – LSO’s standard tables are designed only to handle the online exam test scores – hence two custom tables are created for ILT (Instructor Led Tests) scores. One table is to capture the initial entry of the scores and another for any changes to already entered courses tests. Some tests for some courses can be taken as many times as specified. These tables enable audits effectively.

ECC Transaction: – Test Administrators mostly work with the ECC backend, rather than on the Portal. Test Administrators are the final authority in making decisions regarding the courses, events, and qualifications. In some instances, Instructors pass the exam scoring details to Test Admins to determine if the written exam score meets the appropriate threshold for passing/failing. In this scenario, Test Admins use SAP GUI to enter test scores; to fulfill this requirement, an ECC transaction is created.

Transactional iView: – An Instructor cannot access the SAP backend directly using SAP GUI. An Instructor’s interaction with LSO is via Portal only.  A Transactional iView Portal application is created for Instructors and Supervisors to enter, change, and monitor employee test scores.

Qualifications: – Qualifications determine if an employee has achieved the required training based on validity dates. Each course will impart a qualification based on test scores or  grades. Infotype 0024 will be automatically updated with the appropriate qualifications when these ILT scores are entered either in ECC or on the Portal.

Data Flow Chart: –


Execution and Major Features: –

Below are the execution steps and screenshots of the ECC/Portal applications. Flow logic is same for both the Portal application and ECC application.

Changing the test Scores: –

1)    Select Course Event and exam and execute.

2)    Select the row to change the available fields (Date, Score, Result, etc..).

3)    Display previous entries non-modifiable for review.

4)    Use the back button returns the user to the previous screen for modifications before Saving.

5)   Click the Save button to executes Qualification Processing.

6)    Qualification Processing:-

7)    If entry is changed from “Fail” to “Pass”:

  • Impart Qualification with BEGDA equaling entered Date.

If entry is changed from “Pass” to “Failed”

  • Check if learner has an existing qualification.
  • If learner has the qualification, set end date of relationship to Date entered.

If a record is deleted:

  • If Pass/Fail entry is “Pass”
    • Delete the entries for the newly imparted record and retain the original start and end dates.

Entering the Test Scores: –

1)    Select Course Event and exam and execute.

2)    Enter the details (Date, Score, Result, etc.)

3)    Qualification Process: –

If entry is “Pass”:

Appropriate Qualification is imparts with begin date as entered date.

If entry is “Failed”:

No qualifications are imparted.

Screen Shots: –

Step 1: Enter the Course Event and the Exam.


Step 2: Screen displays all the participants with details below.


Step 3: If the user does not select the row and clicks the CHANGE button, then pop-up message will be displayed.


Step 4:  Select the row and click the Delete button . It deletes the newly imparted record and restore the original Qual end date.



Step 5: Select the row and click the CHANGE button.


Step 6: Selected row details will be shown in the next screen with exam date, score, and result fields enabled.


Step 7: If score is not entered and the user clicks the review button, then an error message will be displayed.


Step 8: If the result is blank and the user clicks the Review button, then following error message will be displayed.


Step 9: If Exam Date is left blank and the user clicks the Review button, then following error message will be displayed.


Step 10: When the user clicks the Review button, a new screen is displayed with the changed fields for confirmation in display mode.


Step 11: When the SAVE button is clicked, it asks for confirmation to proceed with saving the data into the Z-Table.



This entry was posted in Talk Techie to Me and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s