on 2015 Feb 24 2:24 PM
Dear All,
When material no. is more than 18 character then in BI conversion Routine is not working means it is putting as "!" whereas in R/3 for same datasource in RSA3 it is showing correct material no. Due to this the user is not able to see the correct material code in the report. Also in OMSL length given as 18 char.
DS: 0MATERIAL_ATTR
R/3 RSA3 O/p:
DS PSA Maintenance:
Could anyone please suggest that what can be done.
.
Regards,
Abhishek Jain
Dear All,
We have solved the issue by enhancing the datasource 0material_attr by the field created in ECC after business function applied. Then we have used custom field in the 0material. Now we are getting correct data.
Thanks for all your valuable inputs and suggestion which made to achieve the target.
Hence closing the thread.
Regards,
Abhishek Jain
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Abhishek,
and also check in the transformation generated/activated program whether the conversion function code is available for the specific field as a standard.
We are also facing similar issue in 3.x flow. In our case there is no conversion function for the field though we created IO with conversion routine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Abhishek,
can you check whether the field in Data source is internal or external format.
If it is set to internal, no conversion exit has to be considered.
Regards,
Prakasha A
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Praku,
The field in Data Source as internal format and custom IO which I have created, used the conversion routine as MATNL same as in ECC.
When I do the check in RSRV, the error message appears as "SID table contains values with wrong internal format". If I do not use the conversion routine then in the Bex reporting the material codes appears leading with Zeros. Now I am wondering that is OMSL playing any role.
Please suggest.
Regards,
Abhishek Jain
Abhishek,As you mentioned that in ECC OMSL tcode the length is 40 which is by default should be 18.So i believe they have get it changed through modification kit available.You can also check with the functional team regarding this information.
Can you also check the entry in the table TMCNV in source system and see what value has been mentioned there.
Also check this note 83020.
Regards,
AL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Abhishek,
Please check that the Material Number Format (t/code OMSL) in source system and BW correspond. Also make sure that conversion routine MATN1 is used in Characteristic 0MATERIAL.
Best regards,
Sander
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Abhishek,
Normally Material Number in the ECC system is defined as CHAR18 (i.e. Domain MATNR). It also has Conversion Routine MATN1.
During maintenance in t/code OMSL a check is built in to validate the length you input here. If the length is greater than the length of Material Number (i.e. 18 in a standard case), then it gives you an error message.
In BW a similar check is applicable in t/code OMSL. Then Characteristic 0MATERIAL will be leading I expect.
It might be that in your ECC source system the length of Material is specified as 40. Can you please check that (e.g. via t/code SE11, table MARA, double click on Data Element MATNR and then on Domain MATNR).
If in your source system the length is extended to 40, then you will also have to do that in BW.
Last but not least, please also have a look at the discussion which might be helpful.
Best regards,
Sander
Dear Sander,
Mara also has defined as 18 char.
I believe the problem with the conversion routine MATN1. As in ECC the MATN1 use the FM CONVERSION_EXIT_MATN1_OUTPUT to give the more than 18 char value for the material. But when I check same in BW, it is doing nothing. Please find below screenshot.
This is becoming big issue for me. Really difficult to handle the user.
Regards,
Abhishek Jain
Hi Abhishek,
I did some research and found information on "long material number" and how to deal with it in BW. Please have a look at the following SAP Notes:
The last two SAP Notes describe how to deal with long material numbers in BW.
Best regards,
Sander
Dear Sander,
Your suggestions helped me a lot. As I have mentioned the in ECC there is business function activated. So I found that the table is MATERIALID contains the both 18 and 40 char material codes. Now I have done the datasource enhancement for Material_attr with the field MATNR_EXT which has 40 char. The data is pulling correctly into BI and created one custom IO with the 40 char. and selected conversion routine as MATNL then loaded into the 0Material. Till here it is working fine but the issue comes in Bex analyzer that when I use this field into my report the value is coming as "#" whereas in IO it is loaded correctly.
Please find the below screenshots and suggest valuable suggestion because I am just one step to behind to finish this issue.
Material Master IO:
Bex Analyzer:
Regards,
Abhishek Jain
Hi Abhishek,
Good to hear the progress that you made. We are indeed very close to the finish.
As you added a new Navigational Attribute, I expect that the Attribute SID table might not be up-to-date. If you go to InfoObject maintenance (t/code RSD1), then you can find the function via menu Extras > Database tables > Fill Attribute SID Table > Direct Processing.
Alternatively, you can also find several checks in t/code RSRV, e.g. SID Values in X and Y Tables or Values Available in Navigation Attributes.
Best regards,
Sander
Hi Sander,
You are rightly said that the SID table not maintained for new custom field. When I try to fill the SID table then Direct processing and in background is disabled. Also when I do checks in RSRV then it through errors as "SID table contains values with wrong internal format". I guess it is not allowing to store values greater than 18 char.
Please suggest.
Regards,
Abhishek jain
Hi Sander,
Finally the custom object is working fine in the Quality system but when I do transport into the production server, it through error as "the object name is not allowed to be empty". I had deleted the SID and master data table before transporting the TR but still I am getting error. Due to this master data is not getting activated.
Have you encountered this type of errors. I have read many threads but nothing working here.
Please suggest.
Regards,
Abhishek Jain
Hi Abhishek,
Please check SAP Note 1760444 - Transport failure: The object name is not allowed to be empty (R7105).
Best regards,
Sander
Hi Abhi,
0MATERIAL/MATNR length is 18 only. if your material value is more than 18 then how will it shown at RSA3 as well.
At info object level - have your conversion routine as MATN1?
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Abhishek,
0MATERIAL has only 18, if material length more than 18 it will truncate and update the data
Ex
Actual Material : AL_STR410_150X150X10_16
After updating in BW : AL_STR410_150X150X so its natural behavior conversion working as expected, if would like to maintain entire "AL_STR410_150X150X10_16", value, you have to increase length of 0MATERIAL infoobject.
Thank you,
Nanda
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.