master data loading error(urgent)

[Former Member]

hi all,

when i am loading master data by using 0INFO_REC_ATTR data source i am getting error"Value 'CV14AL1BM ' for characteristic 0MATERIAL is in external format ".AND

"Record 1 :0MATERIAL : Data record 1 ('5300000000 '): Version 'CV14AL1BM ' is not valid "

please any one help me.

Thanks

sada.k

Message was edited by: sadasivarao kotaru

[ralph_richter]

Hello Sadasivarao,

I do not know if You did You customization for Material Number Format. SAP Note 871803 will guide You.

Please also keep in mind to use our SAP Service Marketplace to look after solutions for Your problems.

Kind Regards

Ralph Richter

[Former Member]

Hi Ralph,

Thanks for ur reply.i selected leading zeroes in OMSL transaction for both BW and source system(r3).

but in r3 we are using only alpha conversions. Is this reason for problem?

please give me solution.

Thanks

sada.k

[ralph_richter]

Hello Sada,

this could be check Your conversions and otherwise open up an OSS Message to get help.

Kind Regards

Ralph

[Former Member]

Hi Ralph,

thanks for ur reply.in transactional data only some materials are problem and for same material one record is in red and one record is in green(for diffrent transactions).

when i am testing the CONVERSION_EXIT_MATN1_INPUT in se37 and i enter the input material number but i did'nt get any out put but i got error message"The material number is longer than the length set".

please give me solution.

Thnks

SADA.K

[Former Member]

Hi guys,

According to the original post

“when i am loading master data by using 0INFO_REC_ATTR data source i am getting error"Value 'CV14AL1BM ' for characteristic 0MATERIAL is in external format ".AND

"Record 1 :0MATERIAL : Data record 1 ('5300000000 '): Version 'CV14AL1BM ' is not valid "”

I think that 'CV14AL1BM ' is an attribute value of 0MATERIAL. Is it right? What the attribute name?

And the error related to 0MATERIAL is this:

Data record 1 ('5300000000 '): … is not valid "

To get rid of the last error I would delete MATN1 conversion from 0MATERIAL and insert ALPHA conversion instead.

Best regards,

Eugene

[Former Member]

Hi Sada,

There is special character in that value (special character is single space' ' at the end of the value).

Then change the request in to red and delete that request from data mart and edit that value at PSA Level and reschedule it from PSA to data mart.

Regards,

PRK

Message was edited by: PRK

[Former Member]

Hi,

Pl. give me error message details more not only in details tab I want in error message in status tab.

Thanks,

Venkat.

[Former Member]

Hi Sada,

this is caused by the conversion exit for 0material. You need to change this just to alpha or you need to set the flag for conversion in the transfer rules.

regards

Siggi

[Former Member]

hi all,

Thanks for reply.in transfer rules the conversion check box is in disable mode how can i select that one.

please tell me as early as posible.

Thanks

sada.k

[Former Member]

Hi,

if this is the case you cannot switch conversion on at this place. You need to change the conversion exit in the maintenance of 0material or another option is to create a little routine in your transfer rules containing the code:

call function 'CONVERSION_EXIT_XXXX_INPUT'

exporting input = tran_structure-matnr

importing output = result.

(XXXX = Name of the conversion exit given in the maintenance of 0material).

regards

Siggi

[Former Member]

Hi Sadasivarao,

The data u r getting is in external format(It may contains invalid or improper data). I think u already loaded data before.

If you are getting this problem for some recoreds(1 or 2), Just go to PSA, edit record and load manually for time being. U can find out which record is problem from monitor.

If you are having same proble for more records try to load some code to fix.

Srini.

[Former Member]

hi Siggi,

Thanks for ur reply. i have one doubt when we changed the conversion exit is there any effect on other objects(where ever its(omaterial) used. plese give a solution.

Thanks

sada.k

[Former Member]

hi Siggi,

already we have the transaction data.is there any problem to change the conversion exit.

sada

[Former Member]

Hi Sada,

I think there will be no issue. At least the system will tell you if it can change the data to the new conversion or not. If not, you might have to go with the routine.

regards

Siggi

[Former Member]

HI SIGGI,

Thanls for ur reply.i write same code in my transfer structure what u given but i get same error."the material number longer than the length set".

please give detail code i am new to abap.

this is my transfer stracture

FORM STARTROUTINE

USING G_S_MINFO TYPE RSSM_S_MINFO

CHANGING DATAPAK type TAB_TRANSTRU

G_T_ERRORLOG TYPE rssm_t_errorlog_int

ABORT LIKE SY-SUBRC. "set ABORT <> 0 to cancel datapackage

$$ begin of routine - insert your code only below this line -

DATA: l_s_datapak_line type TRANSFER_STRUCTURE,

0MATERIAL TYPE TRANSFER_STRUCTURE-MATNR.

• l_s_errorlog TYPE rssm_s_errorlog_int.

please give solution.

Thanks

sada.

[Former Member]

Hi Sadasivarao,

Use these function modules for material conversion.

CONVERSION_EXIT_MATN1_INPUT Material number conversion (INPUT)

CONVERSION_EXIT_MATN1_OUTPUT Material number conversion (OUTPUT)

Srini.

[Former Member]

hi srini

Thanks for ur reply.please give detailed code.i am new to abap.where i can use u gaven above.

Thanks

sada.k

Message was edited by: sadasivarao kotaru

[edwin_harpino]

hi sada. k,

that's function module used for 0material conversion routine (delivered by business content), you may check with transaction rsd1 if your 'convers. rout.' for 0material is MATN1.

to view the code of that mentioned function module, you may use transaction se37.

hope this helps.

[Former Member]

hi A.H.P,

Thanks for reply.still have same error please give solution.

Regards

sada.k

Message was edited by: sadasivarao kotaru

[Former Member]

HI,

could it be that the last digit is blanc ? 'CV14AL1BM '

/manfred

[Former Member]

Hi sada,

if you will put your code in the start routine of the transfer rules, just put this piece of code in there:

FORM STARTROUTINE

USING G_S_MINFO TYPE RSSM_S_MINFO

CHANGING DATAPAK type TAB_TRANSTRU

G_T_ERRORLOG TYPE rssm_t_errorlog_int

ABORT LIKE SY-SUBRC. "set ABORT <> 0 to cancel datapackage

$$ begin of routine - insert your code only below this line -

• DATA: l_s_datapak_line type TRANSFER_STRUCTURE,

• l_s_errorlog TYPE rssm_s_errorlog_int.

call function 'CONVERSION_EXIT_XXXX_INPUT'

exporting input = datapak-matnr

importing output = datapak-matnr.

• abort <> 0 means skip whole data package !!!

ABORT = 0.

$$ end of routine - insert your code only before this line -

ENDFORM.

This should really solve your issue.You only have to make sure that XXXX is the name of the conversion exit for 0material in the maintenance screen for 0material.

Siggi

[Former Member]

Hi siggi,

Thanks for reply.i copied what u have written but i got this error " E:"DATAPAK" is a table without a header line and therefore has no component called "MATNR" " after compilation.

please give solution as early as possible.

Regards

sada.k

[Former Member]

Hi Sada,

Please put this one 'l_s_datapak_line-matnr' in place of datapak.

Hope there is special characteristic (space) in that material value. Add the space value at this T.code RSKC (maintain special characters allowed)

Regards,

PRK

Message was edited by: PRK

[Former Member]

Hi,

excuse me, here again.

$$ begin of routine - insert your code only below this line -

DATA: l_s_datapak_line type TRANSFER_STRUCTURE,

l_index type i.

• l_s_errorlog TYPE rssm_s_errorlog_int.

loop at datapak into l_s_datapak.

l_index = sy-tabix.

call function 'CONVERSION_EXIT_XXXX_INPUT'

exporting input = l_s_datapak-matnr

importing output = l_s_datapak-matnr.

modify datapak from l_s_datapak index l_index.

endloop.

• abort <> 0 means skip whole data package !!!

ABORT = 0.

$$ end of

regards

Siggi

[Former Member]

Hi siggi,

Thanks for ur reply.i put the same code what u have given .when i run the ip it will take morethan 2 hours just for 600 records and it is not over still it is running.

give me some solution.

Regards

sada.k

[Former Member]

Hi Sada,

please check out sm21 or st22 if there are any log entries or dumps in the system for the load. Let us know the details.

Additionally, did you check Eugene's comments?

regards

Siggi

[Former Member]

Hi Siggi,

i got same error when i am loading transactional data by using 2LIS_02_ITM.erorr is" Value 'WAX-B02I ' for characteristic 0MATERIAL is in external format" and " 0MATERIAL : Data record 2 ('004300000200001020050726 '): Version 'WAX-B02----I ' is not valid".

please give me solution.

Thanks

sada.k

[Former Member]

well I guess you have to implement the same logic. Did you check the syslog and/or the dump overview?

regards

Siggi

[Former Member]

Hi Siegfried

Thanks for ur reply.i got bellow logs in sm21

1. Short Text

Perform rollback

An error has causes an SAP rollback. All database updates are reset.

and in st22" GETWA_NOT_ASSIGNED " i got this runtime error.

please give me solution.

Thanks

sada.k

[former_member183777]

Check Material Number Conversion Setting in transaction OMSL(View V_TMCNV) in BW. There should be an entry for MATCONV and the setting should match R/3.

Seems like a long shot, but worth a try.

Thanks

Vineet

[Former Member]

hi all,

please any one give me solution for my problem.

Thanks

sada.k

[Former Member]

Hi Vineet,

We had the same error and the solution suggested by you works.

Thanks a lot!

Venkat

[Former Member]

Hi Sadasivarao,

Please check your conversion routine, which you had used at 0material.

Regards,

Phani

[Former Member]

Go to the transfer rules and for the 0MATERIAL info-object check the check-box for Conversion. Then retry the load.

Hope it helps.

Regards