Data Load error from Flat File to DSO for 0MATERIAL at CONVERSION_EXIT_MATN

[Former Member]

Hi all,

I am trying to load data into a DSO from a flat file which has the sample data as follows.

0DOC_NUMBER 0CALDAY 0CUSTOMER 0MATERIAL 0SALESORG 0DISTR_CHAN 0DIVISION

1000 20110301 1000 MAT1 1000 10 10

I am getting below error.

Error 'The material number is longer than the length s...' at conversion exit CONVERSION_EXIT_MATN1_INPUT (field MATERIAL record 1, value MAT1)

Can anybody help me resolve the issue.

Thanks

Naren

[Former Member]

Hi,

What infobject have you mapped the Material in datasource? is it 0MATERIAL?

You will have to use FM CONVERSION_EXIT_MATN1_OUTPUT in transformation to convert value MAT1 in accepted format.

Edited by: Parth Kulkarni on May 26, 2011 8:47 AM

[Former Member]

Hi Parth Kulkarni ,

Yes, I have mapped to 0MATERIAL.

I did not get your point "You will have to use FM CONVERSION_EXIT_MATN1_OUTPUT in transformation to convert value MAT1 in accepted format.".

I am a noob in SAP BW, can you explain in little more detail

Thanks

Naren

[Former Member]

Hi,

Check if the length is entered as 18 in transaction OMSL. Flag the check box for add leading zeros.

[Former Member]

Hi Murali,

Thanks I could see that in OMSL the length is 1, I changed it to 18. I do not have much idea about 0MSL can you point me to a resource for more information on OMSL.

Now I get one more error

Error 'Unit USD is not created in language EN...' at conversion exit CONVERSION_EXIT_CUNIT_INPUT (field UNIT record 1, value USD)

Appreciate if you can provide some inputs on this as well

Thanks,

Naren

[Former Member]

Hi,

Sorry, I do not have any document on the setting. The length should be the same for material in ECC (if your source system is ECC, same tran OMSL there as well), in BW (tran OMSL) and length of infoobject 0MATERIAL.

For the unit error, goto source systems in the admin workbench, right click on the R/3 source system, choose transfer global settings, flag all checkboxes and choose radio button update tables and execute.

[Former Member]

Murali,

I am trying to load data into DSO from Flat File Source system. eI hope I am correct in specifying the Source System as Flat File Source System for the Data Source. In this case of Flat File Source System how do I manage the OMSL as I think there will be no OMSL as it is Flat File Source system.

I checked OMSL in both ECC and BW and the Material No Length is 18.

One caveat is after doing the transfer global setting, I am getting the error again

Error 'The material number is longer than the length s...' at conversion exit CONVERSION_EXIT_MATN1_INPUT (field MATERIAL record 1, value MAT1)

Regards,

naren

[Former Member]

Hi,

As you are loading from Flat File, Material value is not MAT1 compatible.

In transformation, call FM ONVERSION_EXIT_MATN1_OUTPUT to do so. When loading from R3 it isnt a problem, because values are refined.

[Former Member]

Hi Parth Kulkarni,

I did not get the transformation you are refering to. I get the error when I am trying to preview data in the data source.

I am not aware of how to define the transformation you are refering to.

Appreciate if you can throw some light.

Regards,

naren

[Former Member]

Hi Murali,

After doing the step mentioned by you to transfer global settings, still I get the error.

Error 'Unit USD is not created in language EN...' at conversion exit CONVERSION_EXIT_CUNIT_INPUT (field UNIT record 1, value USD)

I checked the contents of T006A and I could not find USD there.

Regards,

Naren

[Former Member]

Oh, you said dataload error right? Are u using BW 3.5? Update Rules?

If 3.5, then right below in tranfer rules.

call function 'CONVERSION_EXIT_ALPHA_INPUT'

exporting

input = L_S_SELECTION-LOW

importing

output = l_temp_matnr.

Also, you can try using a custom field of CHAR 18 in the Flat File datasource. So that Conversion Exit do not come into play.

Below is gud document

saptechsolutions.com/pdf/MaterialNumberRangesAndFormatting.pdf

[Former Member]

Hi Naren,

in BW, tran SPRO, SAP Netweaver --> Gen Settings --> Currencies --> Check curr codes.

Update the below entry if it does not exist. You should have tables TCUR and TCURT having an entry for USD.

Curr -

---

Long text -

---

short text -

---

iso code

USD--United States Dollar

---

US Dollar--

---

USD

[Former Member]

Hi Murali,

I could see the USD in TCUR and TCURT tables . I also checked SPRO and could see that USD is enabled.

But still I get the same error. Please let me know if there are any specific format for the csv file.

Regards,

Naren

[Former Member]

hi,

Change the format of the Material column to "Text", save the file and close it and try to load.

Don't reopen the CSV file as the formatting are overwritten every time you open the file.

regards,

Arvind.