cancel
Showing results for 
Search instead for 
Did you mean: 

Error in Loading data to 0Material

Former Member
0 Kudos

Hi Experts,

I am facing problem in uploading the data for 0MATERIAL from its DataSource.

For few materials i am getting this error:

0MATERIAL : Data record 22324 ('  A46203A0079 '): Version '  A46203A0079 ' is not valid

Diagnosis

Data record 22324 & with the key '  A46203A0079 &' is invalid in value

'  A46203A0079 &' of the attribute/characteristic 0MATERIAL &.

System Response

The system has recognized that the value mentioned above is invalid, and

has processed this general error message. A subsequent message may give

you more information on the error. This message refers to the same

value, even though it does not state this explicitly.

not getting where the problem is, i have maintined all the special characters in RSKC, written a routine to remove the leading & trailing blanks in transformation.

If i look up in the datasource for this material there is no problem in there no special characters, its just A46203A0079 and same in r/3.

Cany anybody please help, its urgent!!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

go to the respective infopackage, select error handling, select the third option and schedule the data...

erroroneous data would get displayed.....try to correct them

Regards

Former Member
0 Kudos

That option i already have selected and from there itself i am checking for that error !

Former Member
0 Kudos

else write a formula in transfer rules...

regards

Former Member
0 Kudos

I am using BI7, unfortunately none of the option seems to work

Former Member
0 Kudos

the below code works in bi 7

RESULT = comm_structure-/BIC/ZCONTRTD.

while RESULT ca '#'.

RESULT+sy-fdpos(1) = ' '.

endwhile.

if RESULT(1) = '!'.

RESULT(1) = ' '.

endif.

TRANSLATE RESULT TO upper case.

IF G_ALLOWED_CHAR IS INITIAL.

CALL FUNCTION 'RSKC_ALLOWED_CHAR_GET'

IMPORTING

E_ALLOWED_CHAR = G_ALLOWED_CHAR.

ENDIF.

CHECK G_ALLOWED_CHAR NE 'ALL_CAPITAL'.

do.

if not RESULT co g_allowed_char.

shift RESULT+sy-fdpos left.

else.

exit.

endif.

enddo.

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi ,

try masterdata check and repair in RSRV for 0material

( ' ~ ' ),

Swapna.G

Former Member
0 Kudos

hi dipika,

follow all the steps in the blog.....

/people/sap.user72/blog/2006/07/23/invalid-characters-in-sap-bw-3x-myths-and-reality-part-2

if it still doesnt work, let me know

Regards

Former Member
0 Kudos

Hi Sanju,

According to this blog, i have maintined all the special characters in RSKC. And as i told that if i look up at the data in R/3 or DS there is no special character in there. But i am still confused why i am getting this error !!

Former Member
0 Kudos

Hi,

If you are loading this data through PSA, then goto PSA -> select the data packet which is having error record -> in bottom give the no.of records and select only error records -> display copy the line and paste into Excel or notepad, here you can see the invalid chars. correct it n load the data.

Regards

Sankar

Former Member
0 Kudos

Dipika,

It must be because of the Invalid charecteristics or else just check out whether are there any values in lower case...

Regards,

Gattu

Former Member
0 Kudos

No special characters are there, matnr is maintined with upper case letter in the r/3.

And for the special characters already maintained them in RSKC.