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 a structure and internal table.
- We then write two
selectstatements. The first readsPA0003for all personnel numbers specified and the date of last payroll run (abrdt). The secondselectstatement is used to read all thestrasaddresses corresponding to permanent address type (subty=1) valid at the system date.
- Finally, a loop is run on the addresses internal table
it_address. Within the loop, theread tablestatement is used for reading the payroll tableit_payroll(the hashed table) for each of the personnel number processed. Within the loop, the personnel number,abrdtdate, and the address fieldstrasare displayed. We have used field symbols instead of work areas, in conjunction withloopandreadstatements for better performance.
Two internal tables it_address and it_payroll are defined. it_payroll is a hashed table. We read data from both the database tables PA0003 and PA0006 into the internal tables it_payroll and it_address respectively. We need to print each employee number and the corresponding data from each of the two tables.
Therefore, a loop is carried out on the internal table it_adrress and within the loop, a read table is used to read the hashed table, the row corresponding to the employee number in question. Since it is a single entry access from the internal table it_payroll which is a hashed table with the value corresponding to the hash key (pernr) being passed, the read statement is very quick. All the values that we need are there within the
loop after the read statement. These values are then outputted using a write statement.