Skip to Content
avatar image
Former Member

Formula for upper and lower limit based on target value

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Feb 23, 2011 at 12:13 PM

    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 !!

    ..

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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. ...........

  • Feb 23, 2011 at 01:55 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Feb 26, 2011 at 05:36 AM

    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

    Add comment
    10|10000 characters needed characters exceeded