Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQ02 - Ad Hoc Query - Custom additional fields

HI experts

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?



Former Member
Former Member replied

Hi Vaslhali,

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



0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question