cancel
Showing results for 
Search instead for 
Did you mean: 

New Field in 0MATERIAL.

0 Kudos

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

View Entire Topic
Former Member
0 Kudos

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.

0 Kudos

Hi Durgesh,

Thank you very much its working, rewarded you with points.

Regards,

vikram