Skip to Content
0
May 24, 2020 at 10:19 AM

SAP SEARCH ID'S MM02 WILDCARD EXCLUDE

138 Views

Hello

Watching movie below doesn't solve my problem listed below. That's why I need your help.

https://m.youtube.com/watch?v=mCm5kM05XCw

Searching id's for transaction MM02 is very hard, because there is no wildcart known for exclusion of unwanted results, which i know. I have search throught internet for wildcart but unsuccessfully, but i faund a wildcart for sql (listed below).

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/wildcard-character-s-not-to-match-transact-sql?view=sql-server-ver15

I need to solve example given below

Example:

1 aaa bb

2 aaa 111

2 aaa bb 1111

3 aaa ccc 555

Input to search field "aaa" with exclude "bb". Wildcard ^ is fictional.

*aaa*bb^ *