0material conversion problem in bw

[Former Member]

Dear all,

Problem with 0material. In r3 side, my colleagues has written a conversion routine for material number.

Now in bw side in 0material, i see conversion routine "alpha", and in reporting i can see material number with internal number only.

do i have to write same conv. routine in bw side or what i need to do?

thanks

[Former Member · Accepted solution]

hi,

if the data fetched in the datasource is same as that of the output of ur conversion routine, then simply use the same instead of using the alpha conversion.

this can be chked in RSA3 in R3 for ur datasource.

Ramesh

[Former Member]

when i check RSA3 in r/3 side, material number is displayed as required. However when i upload that data in BW, it shows with internal number.

i have tested deleting Alpha routine, it does not work.

in datasource i have selected mat number as external, it does not work?

what else can be the solution?

thanks

[former_member184494]

John,

ALPHA conversion just adds leading zeroes....

As for conversion routine - what is does is this :

the data is stored in the tables in a different format and the display is in a different format.

For example

Calmonth - the format in which data is stored is different and the format in which data is loaded is mmyyyy - same holds for calday as well/.

What you need to do is to have the conversion routine created in BIW and assign it to the material infoobject.

Arun

[Former Member]

Hi,

Use MATN1 (Function Module for Material Number Conversion (INPUT)) in the Conversion routine in 0Material instead of ALPHA.

Use of MATN1 Conversion Routine :

This conversion routine changes internal material numbers, stored in the system, into the external material numbers displayed in the interface and vice versa, according to settings in transaction OMSL.

Hope this will resolve your issue.

Thanks & Regards,

Suchitra.

[Former Member]

First, check what data is coming in RSA3. If you want the output in this format only, then dont use any conversion routine in the BW side.

Thanks..

Shambhu

[Former Member]

Hi,

In ur Data source' Fileds' tab use Format as ' External ' instead of ' internal '. This will store the data in BW as it comes From R/3.

Regards,

VJ.

[former_member345199]

Hi,

Try removing the Alpha routine in BW and see how it works.

Hope this helps.

Thanks,

JituK