Currently iam using the following SELECT query,
SELECT bktxt FROM BKPF into g_bktxt
WHERE BKTXT IN s_bktxt.
Here, the issue is - in SE11 for BKPF-BKTXT they maintain different combinations of BKTXT values like : WA, wa, Wa, wA.
Now, when an user gives 'wa' in select options (s_bktxt) then i need to pull all (WA, wa, Wa, wA) combinations from database - irrespective of Case ( Case Insensitve or Ignore Case ) at the input select-option - s_bktxt.
How to achieve this...?
Any suggesstions / Ideas will be of great help.