Convert Lowercase to Uppercase in Transformation

[Former Member]

Hi Guys,

I know there are posts on this topic, but for some reason the code is not working.

My load is failing as some master data objects are coming in lowercase letters. Can anybody let me know exact code to write in Transformation for an infoobject? I don't want to maintain the lowercase at infoobject level in RSD1, I have to do it at transformation level.

When you select Routine instead of direct mapping for an infoobject, you need to code the logic in place of 'RESULT = '.

Please tell me the exact steps, I am not an abaper.

Thanks in adv.

BMW

[former_member182516]

HI

I dont think there is a need to write a routine for this, you can achieve this using the formula.

instead of selecting routine in transformation select formula. there you can find the function "TOUPPER()"

for example you want to convert values for char 0COST_CNTR

TOUPPER( 0COST_CNTR) -

---

save it

it will do the trick for you.

Code

TRANSLATE <IO-Name> to UPPER CASE.

RESULT =< IO-Name>.

Regards

KP

Edited by: prashanthk on Oct 26, 2010 8:46 AM

[Former Member]

you can do it without code as well...in the transformation rule -> make use of the formula to uppercase().

[Former Member]

http://help.sap.com/saphelp_nw04s/helpdata/en/b2/e50138fede083de10000009b38f8cf/frameset.htm

Go to Data Warehousing --> Transformation.

Hope this helps you.

Regards,

Vinay

[Former Member]

In transformations mapping you can create a formula to convert from lower case to upper case.

From the options you can select "TO UPPER"

To Upper(0country).

[MartinMaruskin]

In case your inforobject that you want to convert to upper cases is 0COUNTRY, the code needs to be like:

result = 0COUNTRY.

TRANSLATE result TO UPPER CASE.

[Former Member]

Thanks guys for the quick reply. I already solved the problem.