Loading errors.

[Former Member]

Hi All,

Could you please help in resolving the following errors.

Iam uploading data from ods to cube,but iam getting following error

Characteristic value 99457 of characteristic 'Material' is not ALPHA-converted

Could you please guide me in resolving the error.

Thanks,

Vikram.S.

[Former Member]

Hi Vikram,

Check in transaction OMSL, if the 'Add leading 0's' flag is set.

Also 0Material will have MATN1 as the conversion routine. No need to change it to Alpha.

[Former Member]

Hi Murali,

Sorry the characteristic is customer number not material number.

by the way , i dont have authorization to OMSL .

[Former Member]

OMSL is only for material settings.

Check if you have alpha conversion routine set for customer as mentioned above.

[Former Member]

Hi Murali,

I checked for customer number in general tab, i see the followoing values

Convers. Rout. ALPHA

Output length 10

Thanks,

V.singh.

[Former Member]

If you are working with the 3.x flow, set the 'conversion' flag for customer in the tranfer rules (scroll to the end in transfer rules tab).

If it is transformations, in the rule details for customer, see if ALPHA is set and you have the flag set next to it.

[Former Member]

Hi Murali,

It doesn't work,do you havge any ideas further more..

Thanks,

V.singh.

[Former Member]

1. Check if the DSO is reporting enabled? If the Bex Reporting Flag is not checked, no SIDs are generated

2. Have you tried calling a funciton module at rules & running the load again post activation.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
	EXPORTING
		INPUT = Source_field-/bic/*** " SOURCE
	IMPORTING
		OUTPUT =  RESULT " TARGET

Edited by: Arun Bala G on Feb 14, 2012 10:16 PM

[Former Member]

you can write the routine..

Alpha conversion routine

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = 'XXXX'

IMPORTING

OUTPUT = RESULT.

*result value of the routine

RESULT = RESULT

[Former Member]

Hi Sing,

Your material number length is not matching with the material info object length in BW system.

open your info object in RSA1 --> goto edit mode ---> in general tab, for conversion routine add ALPHA.

what it will do is it will add leading 0 to the existing number.

now activate your info object and do the load again. your load will get successful.

Regards,

Venkatesh