Problems when actualize 0MATERIAL

[Former Member]

Hi all,

I have problems with an extractor for InfoObject 0MATRIAL.

We have an old material <u>with a blank space at the end of material</u>, for example “103680<u></u> “. The R/3 people create a new material in R/3 but they can’t delete the old one.

The error is in “Processing with errors in the Warehouse”, the process cancels and the material doesn't update, if I see the PSA the error is:

<b>• Value '103680 ' for characteristic 0MATERIAL contains invalid characters.

• “Data record 2881 & with the key '103680 &' is invalid in value '103680 &' of the attribute/characteristic 0MATERIAL”.</b>

Can anybody tell me how can I what and where can I change for solve this without changing things in R/3?

Thanks.

[Former Member]

Thanks for the help

[Former Member]

You can do that as banu said.

The best way is to go with the transfer routine.

Try the below code.

CONDENSE TRAN_STRUCTURE-MATERIAL NO-GAPS.

RESULT = TRAN_STRUCTURE-MATERIAL.

If this doesn't work then you have to loop the material & delete the sapces.

Regards, Siva

[Former Member]

Is correct if I copy this code as a routine in 0MATRIAL object?.

How can I loop the material & delete the spaces?.

Thanks,

Federico.

I'm sorry it's looks like a dummy question but I'm new in BW.

[Former Member]

Try this code first. it should work..

CONDENSE TRAN_STRUCTURE-MATERIAL NO-GAPS.

RESULT = TRAN_STRUCTURE-MATERIAL.

Yes write it as it is.+ Activate + Load the data

if not let us know so that I can give you some sample code for that.

Regards, Siva

[Former Member]

Please send me the code, this going to be my first code and I'm alone here.

Regards, Federico.

[Former Member]

Try this code code first in the transfer rules.

CONDENSE TRAN_STRUCTURE-MATERIAL NO-GAPS.

RESULT = TRAN_STRUCTURE-MATERIAL.

If the above doesnt work then go with the below.

NOTE: THE BELOW CODE IS WRITTEN ASSUMING THAT YOU'LL HAVE ONLY ALPHABETS FROM A TO Z & NUMERICS 0-9.

******************************************************************************

data: temp_mat type /BI0/OIMATERIAL.

data: mat,

count type i,

cnt type i.

clear temp_mat.

count = 0.

cnt = strlen( TRAN_STRUCTURE-MATERIAL ).

do cnt times.

clear mat.

mat = TRAN_STRUCTURE-MATERIAL+count(1).

if mat CA '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ'.

temp_mat+count(1) = mat.

endif.

count = count + 1.

enddo.

RESULT = temp_mat.

**********************************************************************

Assign point if this is useful.

Regards, Siva

[Former Member]

Thanks, I'm going to try it now.

Regards, Federico.

[former_member188975]

Hi federico,

If you have loaded through the PSA then you can edit this record in the PSA to remove the space and then upload the data.

Hope this helps...