cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with Lower case letters

former_member210253
Contributor
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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
Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
Contributor
0 Kudos

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
Active Contributor
0 Kudos

Hi babu ,

Writing a small code will not impact any loading performance.

Regards,

RaviChandra

former_member210253
Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
Contributor
0 Kudos

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.