In this recipe, we will create a program that will use a hashed table and a standard table for accessing and displaying employee data from two tables PA0003 and PA0006. There may be many solutions to this requirement. We will use SELECT clause and hashed tables.
In this recipe, we create a program that will take as input personnel number and then print the last payroll run date of the employee (from PA0003) and the permanent residence address (subtype 1) stored in the STRAS field of the table PA0006. For simplicity's sake, only one data field of each table has been shown.
For creating the program, proceed as follows:
We define
select-optionsfor taking input of personnel number.
Next, we define a type
ty_payrollbased on payroll infotype fieldspernrandabrdt. A structure and a hashed table based on this type are also defined. The hashed table has a unique keypernr.
Similarly, an address type
ty_addressis defined, along with...