Issue with Lower case letters

[former_member210253]

Hi All,

we are getting load failure due to lower case letters.

This flow is the generic extraction from table,( Full load)

1. So whin  I checked in the source table it is showing as upper case letters only.But when I checked in the RSA3 it is showing Lowercase letters for our field.

2. When I debugged the DS, In the Internal table having lower case lettes for my field.

this is my issue, how to resolve this in R3 side itself not in BI side.

Regards,

Babu

[Former Member]

Hi Babu,

Not so sure but I think you may check whether your field is using conversion routine in R/3 side by following way.

Go to table -> double click on your field-> in the pop up window which comes up there will be Domain name -> double click on it->then go to definition tab ,here you can see conv.routine used .

Regards,

Sreeja

[former_member210253]

Thanks Sreeja,

I have already checked out, There is no conversion Routine for that field.

Note: Not for all values only for 5 values(small letters)

For Instance,

Field1  Field2 ..

M1      A01

M2       A03

M4       A04

M5       a06

M6       a07

M7        A09

M9        A10

And this is Master data only Full update.(Generic Extraction from Table)

Regards,

Babu.

[former_member188080]

Hi,

see if you can use FM to convert it

http://scn.sap.com/thread/313281

I think if description itself contains in R/3 data fields yiu shd not and you can not moodify it directly in source system and otherwise also it is not good practice to modify the data on R/3 side..

You can use FM to convert while loading within BW or you can also check the lower case box in BW IOBJ so it can accept all the lower/upper case letter data..

Thanks and regards

Kiran

[former_member210253]

Hi Kiran,

Writing any simple ABAP code will degrade the performance. So I need to find out the Root cause for this issue.Why Its automatically  changing to lower case while table maintains Upper case ?

Regards,

Babu.

[ravi_chandra3]

Hi babu ,

Writing a small code will not impact any loading performance.

Regards,

RaviChandra

[former_member210253]

Hi Ravi,

Instead of writing code Its better to find the root cause, Table showing capital letters but why they are coming  as small to RSA3 and BW for particular values ?

Regards,

Babu.

[jagadeesh_mandepudi2]

Hi

Check with if there are any conversion routies for those fileds in ECC side, if there remove them and use flat objects.

Jagadeesh.M

[former_member210253]

Hi jagadheesh,

Where we can find conversion routines in R3 side ?

We dont have any Infoobjects at R3 side for having Conversion routines, and  we have fields at R3 side.

Regards,

Babu.