cancel
Showing results for 
Search instead for 
Did you mean: 

Master Data Table /BI0/PMATERIAL contains data: Characteristic 0MATERIAL ca

Former Member
0 Kudos

HI

While transporting processs chains from quality to production,I get this error:

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

SID Table /BI0/SMATERIAL contains data: Characteristic 0MATERIAL cannot be activated

Text Table /BI0/TMATERIAL contains data: Characteristic 0MATERIAL cannot be activated

Please help out.Its taking lot of time for us.

Thanks all,

Harika.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Harika,

It seems like you have changed something in 0MATERIAL and you will have to adjust all these tables in SE14.

Regards,

Durgesh.

Former Member
0 Kudos

Thanks Durgesh.

We are not aware of the changes.Client has modified it.

Please list out the steps in detail what to do in SE14.

SE14 tcode inBI production.Right?

Thanks

Edited by: harikag on Oct 28, 2011 1:33 PM

Former Member
0 Kudos

Hi Harika,

You are right, you will have to use SE14 in production system, just check that whether you have authorization to use it or not. If you don't have authorization then you can check with Basis team.

You can execute SE14, then give table name and in the lower part of the screen Click on the option Save and adjust, and activate the table. Once this step is done you can re-import your request.

Make sure that you do not delete data.

Regards,

Durgesh.

Former Member
0 Kudos

Thanks.

I have done activity in SE14.

While remimporting the request,shall i put just 0materail or 0material_Attr,0material_text....

I was dragging 0material alone->only necessary objects->transport.

Is taht correct?

PLease suggest

Former Member
0 Kudos

Hi Harika,

You can ask the basis team to re-import the old request only. No need to create new request. If you are planning to create new request still you can copy paste all the objects from old request to new request.

Regards,

Durgesh.

Former Member
0 Kudos

I got the same error.not resolved.

Any suggestions?

Can i delete the data from S,P,T tables and test the transport request ?

Edited by: harikag on Oct 28, 2011 2:52 PM

former_member200211
Active Participant
0 Kudos

hi Harika,

Can you please try to delete the Master Data from 0Material and re-import the Transport request.

Once the transport request is successfully imported, please execute Full Load to 0Material.

Former Member
0 Kudos

Hi

HOw to delete master data

1.Right click on o0material->Delete master data

2.datasources->Delete all the requests from 0material_Attr and 0materila_text

3.delete data from tables /bio/p0material,/bio/S0material,/bio/T0material

Please help out an appropriate solution..

Answers (2)

Answers (2)

Former Member
0 Kudos

Please check your 0Material is not in $temp package

Regards,

Sushant

Former Member
0 Kudos

Its not in $Temp package

former_member200211
Active Participant
0 Kudos

hi,

Please check the below thread...hope it helps!

Regards

Lavanya