December 2012
Intermediate to advanced
316 pages
6h 51m
English
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:
select-options for taking input of personnel number.Read now
Unlock full access