Pulling Job short text in Ad Hoc query

[Former Member]

Hi All,

I want to pull the 'short text' field defined in Job into my ad-hoc query. If we select the Output as 'Text only' for Job in IT0001 the output is always the long text e.g. Director of Human Resource. I want to output the short text e.g. DIRHR in my ad hoc query. Both short text and long texts are defined in IT1000 while creating a new Job however the queries from infoset PNPCE only pulls the long text. I can pull the short text in ad hoc query from a OM infoset but for the business requirements we have to use PNPCE. Is there a way to achieve this?

Thanks for your help.

Sanghamitra

[Former Member]

You have to create a custom field and can fetch the short text in the output selection.

By having short text in Output selection will not make any changes to your original infoset.

[Shafiq_Rehman]

This field's text is not available in PNPCE based infosets, you have to create a custom field and write a select statement to fetch the data from table HRP1000. You can find the steps on [how to create custom fields here|/people/shafiq.rehman3/blog/2008/06/16/sap-adhoc-query-sq01-sq02-sq03]:

[AsAlKa]

Hallo Shafiq, the link is not working. I need the information to add the short text of org.unit in Ad Hoc Query. I would appreicate it if you could give the current link. Regards, Asli