Skip to Content
avatar image
Former Member

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?

Thanks,

Vaishali

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 26, 2011 at 03:33 PM

    Hi

    In Mantain InfoSet, go to extras, white page icon (create) and select additional field. I use to populate the field 'LIKE reference' (for instance, LIKE vbrp-sgtxt, ie: a char lengh 50), I set a long text and a text to see it in the header of columns. After, go to the icon for coding (coding for addition) and write the ABAP where you populate the field. Write a coment and search it in the coding for the ABAP report that this tool built. The sequence is a kind of sort of this extras. The purpose is that this assistant knows the order in that it must sort this additional coding. Remember that in the query definition in SQ01 you can change this texts (selection screen, header, etc..)

    I hope this helps you

    Regards

    Eduardo

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Eduardo

      Thank you for your, I tried this method, and I can display both code and text in output.

      But the user is not interested in the code but only wants to see the text - the code needs to used for selection.

      hence looks like there is no option but to create two separate fields.

      Edited by: Vaishali Patwa on Oct 12, 2011 12:21 PM