Ad hoc query text field reference

[Former Member]

Hi all,

Faily new to all this and wonder if you have any insight on the following:

In ad hoc query I'm adding additional fields to a functional area. They subsequently show up in SQ02 in the left hand pane tree structure for that functional area.

Now, if I double click on one of the additional fields the most central pane shows the details of this field. One of the boxes in there called 'References' contains a field 'Text field' that associates a long text with the code that the field contains.

As a made-up example: the add. field could be Personnel Area, value "XY01", and it is associated with a field Personnel Area Long Text that contains "Xeta Yoyo Regional Office". This is the association shown in 'References' -> 'Text Field'.

My problem is that this 'Text field' field seems to be populated automatically, that is there is some kind of automatic link between the field and the foreign field that contains its associated long text. Also it's greyed out so un-editable.

Does anyone know where this relationship comes from? Does anyone know how to be able to edit this 'Text field' field?

Grateful for help,

Richie

[Former Member]

Hi all,

Faily new to all this and wonder if you have any insight on the following:

In ad hoc query I'm adding additional fields to a functional area. They subsequently show up in SQ02 in the left hand pane tree structure for that functional area.

Now, if I double click on one of the additional fields the most central pane shows the details of this field. One of the boxes in there called 'References' contains a field 'Text field' that associates a long text with the code that the field contains.

As a made-up example: the add. field could be Personnel Area, value "XY01", and it is associated with a field Personnel Area Long Text that contains "Xeta Yoyo Regional Office". This is the association shown in 'References' -> 'Text Field'.

My problem is that this 'Text field' field seems to be populated automatically, that is there is some kind of automatic link between the field and the foreign field that contains its associated long text. Also it's greyed out so un-editable.

Does anyone know where this relationship comes from? Does anyone know how to be able to edit this 'Text field' field?

Grateful for help,

Richie

[andreas_mann3]

Hi Richard,

i can't get it ! what is your problem exactly ?

Andreas

[Former Member]

Ok, I'll try to be a bit clearer.

For infosets in Ad Hoc Query, a field has an option to be related to another, different field that provides the long text version of this. Example: field P1000-OTYPE 'object type' is related to T7770-OTEXT 'object type text'.

This relationship is displayed for each infoset additional field: right click on the add. field -> display/change definition, text identification -> 'Determine LIKE reference using text field' in the pop up window.

Problem is this text field is <b>always</b> greyed out and uneditable. So the question was, how do you set this yourself?

Hope this clarifies stuff, thanks for any help,

Richie

[Former Member]

Hi Richard,

Did you manage to set the text field yourself? I added customer fields to an infotype. Some of these fields have check tables linked to them but the text field does not reference these check tables and I would like add it myself.

Your assistance will be much appreciated.

Kind regards

Liza-Marie

[Former Member]

We created a custom info type - the job number field is stored on the info type - but the job description is in a ZTable that we created. It works fine on the info type - but when we go to AdHoc query - I am not able to pull in the text for every job listed on the info type.

I think if we could create the text field reference - it would work. Did you get resolution to how this works?

Please email me - [email protected]

[Former Member]

Hi Elaine,

I didn't find a way of entering the reference text directly in Ad-hoc query but I've created a search help for the field and since then the texts are picked up in Ad-hoc query. IThe key field and the description fields were defined as export parameters in the search help.

Although there is a check table, the system doesn't seem to be able to determine the description field for display. You can use program RS_TEST_IDENTIFY_TEXT to check if the text of a field will be read and this might help you identify the problem. Refer to OSS Note 491403. The report documentation is also helpful.

Hope this solves your problem.

Regards

Liza-Marie