Variable for part of infoobject text

[Former Member]

Hi Experts,

I need to create a variable (manual input) in one of my reports where the user wants to restrict the query to parts of the text of an infoobject.

An example of what I am trying to achive here

Item Item description (text of infoobject item)

123456 Buyed BFOU9940

456789 Buyed RFOU 0,6

789191 Produced BFOU 89,33

111213 Produced RFOU 77

The user wants to enter i.e. BFOU which restricts the query to item 123456 and 789191.

How can achieve this in BEX?

Help will be appreciated.

[yogesh8984 · Accepted solution]

Hi,

As Naveen said, this is the only way to restrict the text. You have to specify the pattern in the restrictions and select all the values coming for such a pattern.

However this will degrade the performance dramatically. Having a restriction on texts and that to with so many texts under restrictions will definitely result into much lowered performance.

Regards,

Yogesh.

[Former Member]

I dont know, if this can be an acceptable one. I am not going to say anything new, but the search method in SAP.

Mention the required text within ** and then you will get the required hits. Select all of them and run the report.

Naveen.A