on 2012 Jan 10 5:10 AM
Hi All,
Iu2019ve added a Z field (CHAR 30) in 0MATERIAL and I am passing characteristics value as 123,456,789.1234 from R/3 and it is coming as 123.456.789,1234 in BW.
so I've added some code in Transfer Rules of the 0MATERIAL in BW and everything is working fine, but because of this the performance problems came, initially all the material was loaded in 1 hour but now it is taking 7 hours.
My Code in Transfer rules:
l_outin = TRAN_STRUCTURE-zzoutdia_in.
REPLACE ALL OCCURRENCES OF '.' IN l_outin WITH ','.
l_len = STRLEN( l_outin ).
l_len = l_len - 5.
IF l_outin+l_len(1) = ','.
l_outin+l_len(1) = '.'.
ENDIF.
Please suggest me how can i solve this.
Thanks in Advance,
MJ Vikram
Hi Vikram,
Instead of using such a big logic put below code, it might solve your problem.
l_outin = TRAN_STRUCTURE-zzoutdia_in.
REPLACE ALL OCCURRENCES OF '.' IN l_outin WITH 'X'. "You can put any third character of your own choice.
REPLACE ALL OCCURRENCES OF ',' IN l_outin WITH '.'.
REPLACE ALL OCCURRENCES OF 'X' IN l_outin WITH ','.
After the assign the final value to result and you are done. Just check how much it will help of improve the perfrmance.
Regards,
Durgesh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Why do you want to convert like this?
This is how it is stored in BW.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Have you tried data type "NUMC"?
Regards,
Venkatesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vikram,
You do not need to apply any code changes in transformation routine. Just go to user profile from SU01 transaction or from SAP Menu and change the decimal settings from Own Data option.
System----> User Profiles -
> Own Data. Change the decimal point setting and get the required thousand separator.
Regards,
Durgesh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.