Skip to Content

Adding Employee Status description field to TREX

Hello Experts,

I'm new to TREX config. I've read Chris McNarney's great blog on adding fields to TREX [] and I've managed to do so. Now one of the requirements is to add in the display results of the extended search, the employee status description (active, inactive, retiree, etc).

I've already included the employee status (PA0000-STAT2) field in HRTMC_PERSON and this works.

For the employee status description, I created a new node and entered in the data source table T529U. As a foreign key relation, I entered T529U_STATV = PA0000_STAT2 along with SPRSL = E and STATN = 2.

I then added the field in HRTMC_CENTRALPERSON (SAP_TALENT template).

I'm unsure on what I need to enter for the step 'Define Search Models and Change Pointers'. Is there an existing extraction class that can be used to read from the table? It's this part that is troubling me. The define search requests & search field names along with define search configurations steps should not be an issue as I've already done it for other fields.

Thank you

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on May 13, 2012 at 08:38 PM

    Hi George,

    I think if you look at some of the other Objects then you will see that none of the text ables are included here, yet the text values are used. I think you can skip this from this step.

    How far ahve you got and have you tried it yet?

    Best regards,


    Add a comment
    10|10000 characters needed characters exceeded

    • Hi George,

      Is this still an issue? If so, can you add a screenshot from this step in ESH_COCKPIT:

      2) Created a new Node with Data Source to table PA0000. I then selected the fields required from the table.

      And from this in IMG:

      2) Define Search Requests and Search Field Names -> I added the new field within HRTMC_CENTRALPERSON, reference table PA0000, reference field STAT2. Node name and object type I left blank.

      Best regards,


  • author's profile photo Former Member
    Former Member
    Posted on May 14, 2012 at 06:09 AM

    Hello George,

    You need to define the employment status in search profile and further stps in that. You need to define the attributes of Employment Status. Please check in the spro for information. After that you should be able to see the field in search, and would be able to search with Employment Status.

    Best Regards,


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.