Enabling Lower Case on an in-use infoObject

[Former Member]

Hi,

We have 0DOC_NUMBER infoObject which extracts in Sales Document Info from R/3.

In R/3 , we have Sales Document 'CREATED BY' Value in lower case.

When its extracted into odoc_number, there is an error message of invalid character in field 0CREATEDBY.

This infoObjects is not Lower case enabled.

Can we change the infoObject to enable lower case now ?

The master data had been loaded for many years now.Is there any steps that we have to watch out for when we enable the lower case in a in-use infoObject.

Appreciate if someone who is familiar in this help out.

Thank you.

Regards,

Maili

[Former Member · Accepted solution]

Yes, you can allow lower case letter in BI.

Go to info object maintenance tab...General and check allow lower case letter.

Regards,

Raj

[Former Member · Accepted solution]

Hi M,

Its actually data issue from R/3. When i check in VBAK table in R/3 , the ERNAM (Created field) had been captured as small letter too. It was created in 2006 and these UserName no longer exist in the system. Thus , cant seem to fix it as R/3 side.

You've mentioned that we can use a routine to convert it.

We are on BW ver 3.5.

Can we write it at the Transfer Rule in BW side at infoObject CREATEDBY?

Thank you.

Regards,

Maili

[former_member186445 · Accepted solution]

yes. in the transfer rule to 0DOC_NUMBER.

for the mapping of 0CREATEDBY, you can use abap routine :

translate tranfield-createdby to uppercase (something like this)

or use a predifined formula...

M.

[Former Member]

Hi Maili,

Making changes to the standard objects is not recomended. If it was a Z object you could have checked that "Lower Case" Check box. You can try to include ALL_CAPITAL in RSKC tran & see if it works. If not try to write a rule level routine to convert Lower case letters to Upper case & assign it to Traget object.

Hope it helps!

Regards,

Pavan

[Former Member]

HI All,

Thanks a lot for your help

I've created a formula TOUPPER in the infoObject to convert it to uppercase. The load is not failing anymore.

Appreciate all your help!

Thanks.

Regards,

Maili

[Former Member]

HI Maili,

Can you explain steap by steap procedure to convert lower case to upper case?

[former_member186445]

you can do this, but it's not recommended, as it's a standard infoobject and moreover it's supposed to come in upper case.

the correct way to handle this issue is : check in r/3 if there's a data quality issue, and if this is the case, somebody should correct this. if it's not possible to change in r/3, you can create a field routine to translate the incoming text to uppercase, you can use a formula for this.

M.

Edited by: M Tibollo on Mar 14, 2011 9:29 AM