cancel
Showing results for 
Search instead for 
Did you mean: 

Can anyone explain the Purpose of Alpha conversion routine in InfoObjects.

Former Member
0 Kudos

Can anyone explain the Purpose of Alpha conversion routine in InfoObjects.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

A characteristic in SAP NetWeaver BI can use a conversion routine like the conversion routine called ALPHA. A conversion routine converts data that a user enters (in so called external format) to an internal format before it is stored on the data base.

The most important conversion routine - due to its common use - is the ALPHA routine that converts purely numeric user input like '4711' into '004711' (assuming that the characteristic value is 6 characters long). If a value is not purely numeric like '4711A' it is left unchanged.

We have found out that in customers systems there are quite often characteristics using a conversion routine like ALPHA that have values on the data base which are not in internal format, e.g. one might find '4711' instead of '004711' on the data base. It could even happen that there is also a value '04711', or ' 4711' (leading space).

This possibly results in data inconsistencies, also for query selection; i.e. if you select '4711', this is converted into '004711', so '04711' won't be selected.

Check this link.

http://help.sap.com/saphelp_nw70/helpdata/en/2b/e9a20d3347b340946c32331c96a64e/frameset.htm

Regards,

Aravind.

Former Member
0 Kudos

Hi Preethi,

If incoming characters are numeric values it adds '0' in prefix according to the length of the characteristic.

For example, If char is of length 8 then,

abcd->abcd

1234->00001234.