WILD CARD SEARCH

Question: HI SBOB,CHC,EL/ALL

Has any one worked on wild card search in query.

Say for example Variable in query SBOB* should give me all the entries related to SBOB .

Bex or WEB solution anything is fine

Thanks
CSAPBW

Answer:
Hello Community/FORUM

Pliz help me out some one

Thanks

CSAPBW

Answer:
Not that know of, i havent been able to work with wildcards in query.
I do not think it is possible but i may be wrong, would love to know if anyone was able to do this.

Answer:
have you at least tried it???

it works just fine here (3.0B SP12)

El Belgio

Answer:
I think that it is available in service packs higher than SP11, because up to this SP a search for textes wasn't possible at all.

Have a look at the documentation enhancements

Name of the document:
3.0B SP11 Value searches (restricting to key or text)
link:
https://www010.sap-ag.de/~form/sapnet?_SHORTKEY=01100035870000193925&_OBJECT=011000358700001391362003E
_________________
Juergen Limbach

Answer:
Hi El Belgion,JuergenL

I am on SAP BW pack 9
SEM-BW Pack 9
BI-CONT pack 9

But does the search works perfect like
say i give ELBELGIO * does it fetch me all entries of ElBELGIO directly ??

Thanks appreciate for ur help
CSAPBW

Answer:
HI SAPBW,



I am not sure how efficient it is but i guess we can do work around thru USER EXIT in BEx,populating thru variable.


Open for debate.......
Thanks

@ChEtAn...

Answer:
I tested it with a query on sales orders... created by 'DER*' gave me all orders created by users whose userid starts with 'DER'

cheers,

El Belgio

Answer:
Hi El Belgio,

Thanks

Could u mail me or reply with what steps u followed and with what system config.
Also would appreciate the link or document on this.

Thanks again

CSAPBW
Copyright ?2007 - 2008 www.jt77.com