Question:
Hi ,
In the selection screen there is a field(select-options) which gets text and gets the data from the database table which satisfies the condition . the problem i am facing is ,in the table the data for that field is not in upper case (i.e) Some data's first letter is caps and remaining are small ,some are fully in lower case . so when i enter the input and press enter athe input is converted into UPPERCASE and since it is checking this value with the database value ,i am not getting a match.
Please let me know whether there is any way doing this.
1. when i press enter after giving the input ,it automatically changes to UPPERCASE , is there any way of not letting this to happen (i.e) even if i press enter also the input in the selection screen should remain the same as i entered.
2. is there any way of checking the condition taking the table entries as uppercase.
Thanks in advance.
Thanks & Regards.
Rajanidhi Rajasekeran.
Answer:
the problem i am facing is ,in the table the data for that field is not in upper case
Hi there.
Why don't you download the full table into an internal table (translating the "problematic field" to upper case)?
I don't really know if it'd work, but I guess that it looks fine...
Try with anything like that:
SELECT * FROM EXTERNAL_TABLE INTO working_area.
TRANSLATE working_area-TEXT_FIELD TO UPPER CASE.
APPEND working_area TO AUX_TABLE.
ENDSELECT.
Then, if you want to compare the selection screen entry with the records in your AUX_TABLE, you'll find your text field in UPPER CASE (so, you won't mind if SAP "auto-translates" the field to upper case when you press
the enter key), and you'll have to do nothing but...
READ TABLE AUX_TABLE INTO working_area
WITH KEY TEXT_FIELD = selection_screen_text_field.
or...
LOOP AT AUX_TABLE INTO working_area
WHERE TEXT_FIELD = selection_screen_text_field.
...
...
ENDLOOP.
BE CAREFUL ! ! ! THIS SOLUTION MAY BRING YOU TROUBLES IF YOU HAVE TO FACE THE FOLLOWING SCENARIO:
'Material_100' and 'MATERIAL_100' (or, i.e., 'MaTeRiAl_100') are different records in your external (dictionary) table.
But I guess this is quite unusual in SAP, isn't it?
I hope it helps (let me know if it does).
Greetings from Madrid.
Answer:
... or have a look here
Hope it helps,
mr.
Answer:
Try this :
SELECT-OPTIONS sel FOR f lower case.