Question:
Hi Fans,
Is there a standard conversion routine - to convert lower case data to UPPER CASE data.
When we are extracting master data, one of the arributes have data in the lower case lettlers.
Please advise if there is a std. conv. routine that we can use which will convert the lower case letters to upper case letters.
Also, we cannot turn on "Loer case " flag on the infoobject, because, we want to search on it using a variable.
Thanks
- Gary
Answer:
Hi Gary,
In BW 3.x, you can use the TOUPPER transformation in Transfer Rules to do this. Edit the Transfer Rules for the InfoObject and choose Formula.
Regards,
MAP
Answer:
Use the tranlate ABAP keyword... I tend to use ABAP vs. transformation tool because there is a certain amount of overhead involved with the tool.
Example:
SHIFT RESULT LEFT DELETING LEADING SPACE.
TRANSLATE RESULT TO UPPER CASE.
Answer:
Put the following sentence.
"Translate result o upper case"
This will take care of your result..