How to use Query Script that criteria are not case sensitive?
If I will search for name "Test", it will only display exact match and not include "test". Thank you
In SAP There are certain tables where the code is written to accept only the Upper Case Letters or Lower case letters; In these scenarios Winshuttle Query will be have similar way.
It is a SAP limitation where even a native SAP query is case sensitive. To bypass this problem SAP provides certain fields for some tables to store a fully uppercase version of name for example Customer name in KNA1 is stored in full caps in field MCOD.
For example in below request need to search the Business Partner ; directly in SAP it takes the name as it is .
Please see first screenshot where I searched using Partner which provided me name of Organisation.
If I search using STIHL only it doesnt fetch me any data
IF I search with Exact Upper Case and data it searches data; ask customer to perform these steps directly in SAP.
Please sign in to leave a comment.