User-Defined Code and Secure Query

Question

I have created two new code tables that show up in a drop down in one of my custom pages. Each code has the code and then a description. 
 
 My problem is hen I run a secure query to pull a report that will show these two new code tables the report shows only the Code and not the Description. Is this a possibility?

Lynn C · Accepted Answer

The User Defined codes that are selected on the employee's custom pages are stored in the custom detail table. Hrtkpers for single record custom pages and TKMULXXX for multi-record custom pages. The description of codes for the HR module are stored in hrtables. To have the description of User Defined codes appearing on a report, you will need to create a report using SAP Crystal Reports and use hrtables and link it to the custom table (hrtkpers or tkmulxxx). The field fdesc in hrtables contains the description. You will need to filter the Crystal Report by Company, frule, and ftable, possibly by Employer, otherwise codes and descriptions from other code tables will appear. 
 If you are not familiar with Crystal Reports, you may want to reach out to Support or your channel partner.

Sage HRMS

User-Defined Code and Secure Query

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING