SQ02 - Ad Hoc Query - Custom additional fields
I am working additional fields in SQ02 .
I added a new additional field for an info type in SQ02.
Issue is when I right click on my additional field I can see options 'Only value' but for other fields I can see ' only value ' , 'only text' and ' value and text' .
When creating the new field in SQ02, the check box "Determine LIKE reference using text field" is disabled.
Is there is configuration somewhere or any other way, where I can also get the text for the custom additional field?
I can see that this question has been asked earlier, but there are no responses.
Also on SAP documentation, this field is shown as enabled.
But I cant get the text for a additional field working. Please coyu post your suggestions?
Create an addition field for instance, COUNTRY_KEY_NAME , 'country (key and name)', for instance like BKPF-SGTXT (char, lenght 50). Add the tables T005, T005T in the infoset. In the additional coding write:
DATA: name_country LIKE t005t-landx50. CLEAR name_country. country_key_name(3) = p0001-land1. SELECT SINGLE landx50 INTO name_country FROM t005t WHERE spras = sy-langu AND land1 = p0001-land1. country_key_name+4(46) = name_country(46).
Check the coding, save, activate and check that you can see it in the query (SQ01)
I hope this helps you