Master Data Table /BI0/PMATERIAL contains data: Characteristic 0MATERIAL cannot be activated

[burns_sh]

Hi all,

we are on BW4HANA 2.0 , and I have added a navi attribute to 0MATERIAL and when I transport to our test it goes in with a RC4 as expected because it deactivates the associated transformations and DTP's.

However, when the same transport is moved to the UAT system it gives an RC8 with errors as per below;

• Lower Case was changed from X to
• Characteristic 0MATERIAL: Lower case is no longer permitted
• Master Data Table /BI0/PMATERIAL contains data: Characteristic 0MATERIAL cannot be activated SID Table
• /BI0/SMATERIAL contains data: Characteristic 0MATERIAL cannot be activated

There was no change to lower case, I only added a new navigational attribute to 0MATERIAL.

I cannot work out why it is having a different outcome in our test environment compared to our UAT environment.

0MATERIAL is used extensively across our entire model, so deleting the transaction data in order to delete the master data will take a huge amount of time and effort, as there is a large amount of transaction data.

Has anyone come across a similar situation, and if so how did you resolve?

Thanks,

Shane.

[Abhishek_Hazra]

Hi Shane,

Just wondering if your new attribute is visible in your UAT system already in the modified version of 0MATERIAL?
Also, can you perform an RSRV check on overall 0MATERIAL to see what are the inconsistencies? If there are certain erroneous records causing the block you can identify & fix it from RSRV. Once this is done can you reimport the transport request or use the program RSDG_IOBJ_ACTIVATE to activate the infoobject (if your changes are visible in modified version already)?

Best Regards,

Abhi

[burns_sh]

Hi Abhi,

many thanks for your suggestions.

Looking at 0MATERIAL in UAT I can see the new navi attribute.

However, when I open the active version, the Case-Sensitive box is checked!!!

I do not understand how, as it is not marked in Dev, Test or Production.

I tried RSRV > All Combined Tests > Master Data > Check Master Data for Characteristic for 0MATERIAL.

This returned all greens, (I did try it earlier and there was some reds so I repaired and now it is green).

Using RSDG_IOBJ_ACTIVATE still gives the same error, which seems to be caused by the active version having the Case-Sensitive box checked.

Only thing I can think of is it must have been changed directly in UAT at some stage.

Thanks,

Shane.

[Abhishek_Hazra]

Alright, that’s the reason then. Then please reimport the transport request with overwrite original option checked & it should be imported with the box unchecked for lowercase acceptance as you say it’s not checked in original TR.

Best Regards,

Abhi

[burns_sh]

Hi Abhi,

I already tried to re-import with overwrite originals.

Was giving the same issue because of the master data tables containing data.

I suppose there is no way round it, I will have to delete the transaction data and master data in order to get the change in.

Many thanks for your help.

Thanks,

Shane.