on 2005 Nov 23 6:52 PM
Hi All,
I have the following dilemma: I have data coming from R/3 for account numbers that have zeroes in first and second characters. Like for example 01234567 or 00123456.
I want those zeroes to remain the same in BW. The infoobject is defined as a characteristic with length 8.
Is there a routine where I can keep the zeroes in front.
Thanks,
Ashmith Roy
hi Ashmith Roy,
and make sure your account number infoobject has Convers. Rou 'ALPHA' in infoobject maintenance.
if the checkbox isn't available you may try following code
data : lv_acc_no (8) value '00000000',
lv_length type I.
RESULT = TRAN_STRUCTURE-/BIC/ZACC_NO.
lv_length = 8 - strlen( RESULT ).
if lv_length > 0 and lv_length < 9 and RESULT(1) <> '0'.
shift RESULT right by lv_length places.
RESULT(lv_length) = lv_acc_no(lv_length).
endif.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ashmit,
if you need to do some coding use the standard fm for conversion instead of doing it by your own. Check out the fm 'CONVERSION_EXIT_ALPHA_INPUT' --> puts the leading zeroes in front of a value and checks whether a value is numeric or not.
So in a routine you will have the following:
call function 'CONVERSION_EXIT_ALPHA_INPUT'
exporting input = <your field>
importing output = result.
That's all.
regards
Siggi
Hi,
Select the check box 'Conversion Exit' in transfer rules against your account number .
Hope it works ...
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
57 | |
11 | |
7 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.