There are 4 roles for this project.
FIRST is Employee - he reports to the manager of his department.
SECOND is the Manager - he keeps record of activities of employees of his department and assess them.
THIRD is Reviewing officer - manager reports to him and the evaluation report is reviewed by him. He checks the report and may mark for some changes.
FOURTH one is the Accepting Officer - he will give the final decision on the evaluation reports whether to accept the report or not. After he finalizes the report, then only employees can view their performance results.
So, accordingly first we need to create four data dictionary tables to store the basic records of the above four roles.
Create an employee table to store the employee details of the company:
Step 1. Go to Transaction SE11.
Step 2. enter table name "ZPROJECT_EMP" and click create. The table name must start with alphabet "Z" and by default the table name will be saved in uppercase.
Step 3. provide short description for the table - "EMPLOYEE TABLE FOR PROJECT EAS ".
Step 4. In 'delivery and maintenance' tab enter value "A" in field delivery class. Select "display/maintenance allowed" in field data browser/table view maint.
Step 5. Select fields tab and define the required fields.
For this project the fields used are:
EMP_ID - employee id. (primary key)
EMP_NAME - employee name
DEPT_NO - department number.
DEPT_NAME - department name.
JOINING_DATE - date of joining the organisation.
TO_DATE - date till the employee is in the organisation.
PASSCODE - password
EMP_PHONE - phone number.
ADDRESS - addressof employee.
MARK - this field is used when a particular row is to be selected from the table in any screen. It is defined here for future references but not used here.
Step 6. Now create entries in the table. Select Utilities -> table contents -> create entries. Following screen appears.:
FIRST is Employee - he reports to the manager of his department.
SECOND is the Manager - he keeps record of activities of employees of his department and assess them.
THIRD is Reviewing officer - manager reports to him and the evaluation report is reviewed by him. He checks the report and may mark for some changes.
FOURTH one is the Accepting Officer - he will give the final decision on the evaluation reports whether to accept the report or not. After he finalizes the report, then only employees can view their performance results.
So, accordingly first we need to create four data dictionary tables to store the basic records of the above four roles.
Create an employee table to store the employee details of the company:
Step 1. Go to Transaction SE11.
Step 2. enter table name "ZPROJECT_EMP" and click create. The table name must start with alphabet "Z" and by default the table name will be saved in uppercase.
Step 3. provide short description for the table - "EMPLOYEE TABLE FOR PROJECT EAS ".
Step 4. In 'delivery and maintenance' tab enter value "A" in field delivery class. Select "display/maintenance allowed" in field data browser/table view maint.
Step 5. Select fields tab and define the required fields.
For this project the fields used are:
EMP_ID - employee id. (primary key)
EMP_NAME - employee name
DEPT_NO - department number.
DEPT_NAME - department name.
JOINING_DATE - date of joining the organisation.
TO_DATE - date till the employee is in the organisation.
PASSCODE - password
EMP_PHONE - phone number.
ADDRESS - addressof employee.
MARK - this field is used when a particular row is to be selected from the table in any screen. It is defined here for future references but not used here.
Step 6. Now create entries in the table. Select Utilities -> table contents -> create entries. Following screen appears.:
enter values in the fields. click on save (floppy icon) and then click on next arrow button to enter new values. Similarly, all the required entries are done.
To display all the entries, select utilities -> table contents -> display entries. if we select all the entries then it is displayed as follows :
