Text field in Query is not shown

[Former Member]

Hi experts,

When we create an Infoset query with tcode SQ01 the text of the field "Key for the contribution group" is not shown in the result output.

In the infotype 0061it shows the code and the text, but int the query although it is selected "Value and text" for this field it only shows the code and the text is blank.

Kind Regards,

Julian.

[Former Member]

Hi Julian,

this is the case because SAP query is not capable of determining the text easily.

FYI, this is done in class CL_HR_TEXT_IDENTIFIER, method FIND_POTENTIAL_TEXTSOURCES

The field 'key for contribution group' => the text table is T5E4JT

In this table, one of the key fields is TPCCC (Contribution Account Code type), this field however is not part of table PA0061 so the query can not determine its value and not select from the text table.

Hope this helps,

Tom

[Former Member]

Thanks Tom,

Then what should I do?

Modify the infoset with the class you told me?

Kind regards,

Julian.

[Former Member]

Hi Julian,

I wouldn't modify the class.

what you can do is to is to add a calculated field in which you apply the same logic as in the infotype.

On SDN you can find some threads on how to do this.

e.g.

http://scn.sap.com/thread/1699872

http://scn.sap.com/thread/1453987

Another option (but I haven't don this yet, so to be tested carefully since this is used outside of SQ01 as well) is to configure an exception for the field in table TEXC_FLD_C).  In this table you can enter a function module that you'll use to determine the text values.

Mucho suerte 🙂

Kr,

Tom

[Former Member]

Thanks Tom,

I have found the note 491403.

Kind regards,

Julian.

[Former Member]

Thanks for sharing the note Julian

no worries

kg

[Former Member]

Hi Julian,

indeed, thx for sharing.

I reached about the same conclusion with some debugging 🙂

Kr,

Tom