Formula for upper and lower limit based on target value

[Former Member]

Dear All

I have to create inspection plan for 25000 material codes. Each material code will have same MIC's assigned but with different target values. Lower limit and upper limit will be +5% and -5% depending on target value. My target values can be changed every 6 months.

Is there any formula for upper limit and lower limit so that it changes automatically with the change of target value. Plz provide the specific / easy way for revising the inspection plans. At present i am deleting all and then creating them again But it takes more than 10 days for completing. Plz provide any shortcut method.

Thanks in advance

[Former Member]

Is there any formula for upper limit and lower limit so that it changes automatically with the change of target value?

Hi,

Please go to the following menu path.

Quality Planning-Basic Data---Inspection Characteristic, Inspection Method--Define Tolerance Keys

In this you can create your own tolerance keys and select the nominal values and start entering the target value, lower limit and upper limit. target value 10,000 lower limit -0,310 upper limit 0,310.

like this you can make n number of entries

In the inspection plan (QP02) you can just assign this tolerance key to the MIC and enter the target value. so that lower limit and upper limit will be picked up automatically.

Else you can assing the tolerance key while creating the MIC (QS21).

Hope your problem will be sorted out.

Regards

Hari

[former_member42743]

See if this link helps you:

http://help.sap.com/saphelp_45b/helpdata/en/2d/351fea448c11d189420000e829fbbd/frameset.htm

Hopefully you don't have one plan per material! You can assign multiple materials to a plan.

For a given test parameter you only need one MIC which I would set up as a full copy model mic.

Then you maintain the target value in each plan.

I would suggest using the inspection plan engineering change workbench for changing you target values. While a little difficult to get use to at first it can greatly help you in doing mass updates to the inspection plans.

FF

[Former Member]

Dear

I cannot assign multiple matreials to a plan, because each matreial will have different target values per MIC.

[former_member42743]

If every material has a different target value and you want to use relative tolerance then you have no choice but to maintain one plan per material. If this is the case, I think you might be better off not using the relative tolerances and using absolute tolerances. You can use classification and material specs so that the spec values come from class via the material via the material spec. Then you make the spec change in the material master in the classification view.

I'm not sure I understand the business process as you seem to indicate that changing these target values, ( hence the spec) happens on a regular basis. Can i ask you to explain your business process a bit more?

FF

[Former Member]

I thing following can be a way to do fast changes.

1.Create a EXECL sheet with target value.

2.Use the formula in Excel sheet so that upper & lower values can be automatically derived.

3.Now in Customization active "change MIC with history ' & " replace MIC"

4.Ask abaper to create a BDC/LSMW which will update MIC in QS23.

5.Every time you can run the BDC/LSMW & make changes which will be applicable to All MIC's.

6.You can maintain MIC & version numbers also in EXCEL for better changes.

This is just a suggestion............I hope it will help !!

..

[Former Member]

Dear

Thanx for your response.

But with this MIC values will not be updated in alreday existing inspection plans. I have delete all inspection plans and reupdate the same. Plz provide the alternative for this.

[Former Member]

That's reason in my earlier reply I mentioned about Now in Customization active "change MIC with history ' & " replace MIC"

Check the client level & plant level basic setting in QCC0

With this option( replace MIC---> setting at client level) you can change the MIC & subsequently make changes in the existing inspection plan. ...........