Description

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

Applies To

Studio

Solution/Immediate Workaround

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.