SQ01 - can you add in the text behind a record in an infortype?

[Former Member]

We currently have a number of HR Reports in SQ01. When we enter text behind a record in an infortype, we can bringin a column to the SQ01 report that shows there is text behing the record. An example would be the home address, the text being the record showing who the email was from, when it was received etc.

Is there any way rahter than just getting a 'X' on the report to show there is text, to actually being the text into the report. Ok appreciated this may be a very wide column.

[former_member415661]

You can build a new column / field in SQ02 to check for the text using the FM as described by other earlier. Once there is text, pass back to that field "X"

Make that column available from your infoset to the query set and it will be available to use via SQ01

[Former Member]

To clarify further:

When entering data into any HR infotype (say Basic Pay for example), you can add in text behind the record by pressing F9 on your keyboard.

We then use SQ01 for certain reports in HR. We can if we run a Basic pay report see that there is text behind the record by dragging in the column for text which shows an X if there is text, and its blank if there isn't.

What we want to do is to be able to add in the actual text into a report?

Is this possible.

[Former Member]

of course it is possible, if you write your own report.

The text is stored in cluster (table) PCL1, relid = TX

you need to import the cluster data in your report for your records

[shafiq_rehman3]

This definitely clarifies the issue, now as Andy has already mentioned where the texts are stored, he is right.

And you are already displaying it on a SQ01 report, if not then you can create a custom field and use FM READ_TEXT to read the text and put logic if the read text is not null then put an 'X'. In case, you already have some other solution in place to read the text, then you can make use of local fields in SQ01 where you can create a new field and write a formula to put 'X' whenever texts field has some contents. To create a local field go inside your SQ01 query, then follow menu path "Edit" -> "Local Fields" -> "Create".

Hope it helps.

Thanks,

Shafiq.

[shafiq_rehman3]

your question is quite confusing, please rephrase in easy to understand words. I have a feel that it is not a difficult problem.