cancel
Showing results for 
Search instead for 
Did you mean: 

ALPHA conversion: BI 7: Not returning the correct value

Former Member
0 Kudos

Good day.

BI 7. Datasource with DB Connect.

Please assist with the following? I did check SDN, but could not find a solution to my problem (forgive me if I missed it)

I have a master data InfoObject, with 'data type' = CHAR, length = 5, with ALPHA conv = APLHA.

The field in db = 00013, when I upload to PSA it = 00013 (correct), when using DTP to MD infoObject it returns '13' (incorrect). I want '00013' to display in the master data IO. What do I do to get this right?

Thanks in advance... again.

Cj

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Thank you guys!!!! I do appreciate your quick response. I removed "ALPHA" and field displays "0" correctly.

Have a nice day.

Cj

Former Member
0 Kudos

Hi,

Remove alpha conversion option from the infoobject if the source is already padding up the values with 0.

Thanks

Ajeet

Former Member
0 Kudos

Hi,

when Alpha conversion is defined then when u display the value's it will display withot the Zero's or Blank spaces at the front.

But at Database level it will save as ur 5 Char. length.

REDDY