Create MICs based on variable current input

[vivek_tembe]

I need help for the following scenario for my Quality Management SAP project

We have to two constants with us

Current Constant = 3 Amperes

Voltage constant = 200 Volts

I have only one input only which i give to the system

(This changes from time to time (range is vast from 2.1 to 100.9)

Input

Variable current = 4 Amperes

Calculations

Variable Voltage = (3/4)^2 * 200 = 112 Volts

Variable wattage = (3/4)^3 * 200 = 62 W

Output should be in the form of MICs, which should be generated automatically based on variable current input

(and not through QS21)

Tolerance band should be +/- 10%

Output required

MIC1

Name - Variable Voltage

Type - Quantitative

Status - Released

Target Value - 112

Lower limit - 102

Upper limit - 122

MIC2

Name - Variable wattage

Type - Quantitative

Status - Released

Target Value - 62

Lower limit - 56

Upper limit - 68

Please let me know, on how to create the MICs automatically with input of variable current?

Should I use a formula or a user exit and if so, how?

Also, please reply if you need further details

[Former Member · Accepted solution]

Hi Vivek,

I will tell u step by step.

Step No.1: Create Quantitative MIC as usual.

Name of the MIC: VCURRENT (Variable Current)

Step No.2: Create Quantitative Calculative MIC.  VVOLTAGE

In CONTROL INDICATORS - SUB HEADING: FORMULA.

SELECT THE u201CCalc.Charac.u201D RADIO BUTTON.

THIS IS VERY IMPORTANT STEP.

IN QUANTITATIVE DATA MENTION THE LOWER LIMIT AND UPPER LIMIT AS GIVEN BELOW.

Lower specification limit - 102

Upper specification limit u2013 122

PLZ. Note that VVOLTAGE is the Calculative MIC.

Step No. 3 : Go to Routing and select the assignment of MIC.

Step No. 4 : Assign the first MIC VCURRENT

Step No. 5: Assign the second MIC  VVOLTAGE

As soon as u enter the key , the system will take you u201CQUANTITATIVE DATAu201D

U HAVE TO ENTER FORMULA HERE.

(3/C020)(3/C020)200

3 IS CONSTANT CURRENT.

200 IS THE CONSTANT VOLTAGE

C020  IS TO BE RECORDED IN RESULT RECORDING SCREEN

ACTUAL CURRENT OF SPECIFIC MOTOR.

SAVE AND CHECK FOR ERRORS.

System creates Inspection Lot.

Step No. 6.

Do result recording.

Enter the Value for VCURRENT. SAY 4

VALUATE THE MIC.

STATUS WILL BECOME 5.

NOW SELECT THE VVOLTAGE MIC LINE ITEM AND

Click the Calculator Button.

System calculates the voltage as per formula for the input current 4

(3/4) multiplied (3/4) and again multiplied by 200  Net voltage.

Similarly for any number of Calculative MIC can be created as per business requirement.

If u r able to solve, please give me marks.

Otherwise update the SDN Message.

With Best Wishes,

Raghu Sharma

[Former Member]

Hi Vivek,

I hope ur understanding regarding the functionality of Formula Parameter functionality.

It works like this;;

assume; MIC1 line item 0010 having Upper specification limit 100

now for MIC2 line item 0020 we insert formula such as C5010*10 (Where C5 = Upper limit of tolerance range, for MIC 0010 = 100)

So according to this when the result for MIC2 will be calculated, it will give the result as 1000 (C5010=100*10 = 1000) correct.

I hope now that is clear to you and your rest 20% doubt is also cleared!!!

And finally request you to not forget regarding point every time possible for each useful answer, as per its potentiality. It encourage all to come back and past answers to each thread.

Regards,

Shyamal

[vivek_tembe]

Hi,

Thanks for your replies

FIRST MIC.: I have created a MIC u2013 VCURRENT.

I have assigned Fixed sampling Procedure of sample size 1.

SECOND MIC: I have created another CALC.MIC say VVOLTAGE.

I have assigned Fixed sampling Procedure of sample size 1.

SECOND MIC Value is to be calculated by the system using a predefined formula.

One component of the formula is the First MIC.

Up to now, there is no issue. While recording the result recording the SYSTEM

Calculates the value of calculative MIC correctly.

THIRD MIC: I have created a normal MIC.

I have assigned the 100% Sampling procedure to it.

THE LOWER LIMIT OF THIS THIRD MIC HAS TO BE GENERATED

Dynamically using the formula  0.95 multiplied by VALUE OF SECOND

MIC.

THE HIGHER LIMIT OF THIS THIRD MIC HAS TO BE GENERATED

Dynamically using the formula  1.05 multiplied by VALUE OF THIRD MIC.

100 % sampling procedure, is assigned to it .

Say for example for production order of 100, these LL and HL are to copied 100 times.

Is there any function module available to generate the lower limit and upper limit depending upon the recorded result of Previous MIC?

[former_member42744]

Vivek asked:

Is there any function module available to generate the lower limit and upper limit depending upon the recorded result of Previous MIC?

No.

Craig

[Former Member]

Hi,

What i understood from your thread is, the "Variable current " is the only value that will vary, correct? And just because of it the calculations for MIC1 and MIC2 will cahnge correct?

Then it's simple to solve your confusion,

Created one more MIC0 for Vairable Current, input its upper and lower limits as per your requriement (It may be from 2.1 to 100.9).

Now just activate the control indicator Calc.charac. (Calculated Characteristic) in your MIC1 and MIC2.

System will ask you for the formula for these to MICs where you can set the formula as you have mentioned. To learn how to input formula for the MIC press F1 in the formula field.

Best Of Luck!!!

Update us to help you more, Reward points to help you Better!

Regards,

Shyamal

[vivek_tembe]

Hi Shyamal, Jagadish & others

Thanks

i am facing the following situation and problems

Yes, in inspection plan, variable current is the MIC 0 where i have to give input (say 4 amperes)

After that i have defined MIC 1 and MIC 2, which are of calculated characterstic type (control indicator)

MIC 0 - Line item 10 - Variable Current

MIC 1 - Line item 20 - Variable Voltage

MIC 2 - Line item 30 - Variable wattage

Formula for MIC1 -

C010 * 0.75 * 0.75 * 200 (value is 112 w, for input of 4 amperes)

(where C010 is the arithmetic mean of input - variable current)

C510 *0.75 * 0.75 * 200 * 1.10

(where C5 is upper tolerance, upper specification becomes 122)

C610 0.750.75 2000.90

(where C6 is lower tolerance, lower specification limit becomes 102)

so for MIC1, we have

target value - 112, lower specification limit - 102, upper specification limit - 122

Now in results recording, i enter the results of MIC1

if result is 112 - accepted

if result is 123 - rejected

if result is 101 - rejected

Now, i am facing two problems,

1. Formula tab contains space for only two lines for inputting formula. I need three

2. System is not accepting formulas in results recording

[Former Member]

Vivek,,,,

Confusion boss.....trying to resolve it!!!!

From where these C5 and C6 came from????

1st of all if your formula is correct in your tasklist then and then only system will allow you to save. It meanse there should be no any scean in Result Recording screen for not accepting it.

2nd in result recording screen, you will not allowed to enter results for the calculative charecteristics (MIC1 & MIC2), it will get calculated automatically. If you have changed the MIC through QS22/QS23 it would have created a version, have you updated it in your tasklist.Or if you have changed it in your rasklist itself pls keep it in mind it will not work for the Lots you have already statrted Result Recording for, from next lot onwards it will work.

3rd You have demonstrated the fromat in which you have inserted your formula is wrong, the ready made help from SAP field is pasted below. pls do it that way.

Formula Field

Use

To calculate a value for a calculated characteristic, enter a formula in this field. The formula will be evaluated by the SAP formula interpreter in the following places:

In the task list (checked for correct syntax)

The function module CHECK_FORMULA checks whether a formula stored as a literal or as variable has the correct syntax.

In results recording (when the value of the calculated characteristic is to be calculated)

Example

A formula can be structured as follows (with the standard settings):

Characteristic 10 stands for the length and characteristic 20 stands for the width. Characteristic 30 represents the area and is to be calculated from characteristics 10 and 20.

Characteristic 30 is therefore a calculated characteristic with the following formula:

General: Area = Length * Width

Formula interpreter: Area = ppnnnn * ppnnnn

The variable 'pp' defines the formula parameter and 'nnnn' represents the characteristic from which the value of the formula parameter is taken.

*Example: Area = C00010 * C00020*

'C0' stands for the arithmetic mean value and '0010' or '0020' for the respective characteristic.

So as per the scenarion exhibited in your last reply, ther will be only one input processing MIC for you may be for Variable Current only. And the entire scean I can visulize is,

If,

MIC 0 - Line item 10 - Variable Current

MIC 1 - Line item 20 - Variable Voltage

MIC 2 - Line item 30 - Variable wattage

then your formula should be,

For MIC1 C00010 * 0.75 * 0.75 * 200

On more thing there is standard length of 2 line 60 chareecters each is available in SAP, and i think that is enough, atleast in this case particularly!

Correct me if if I m wrong anywhere!!!

Update us to Help you more, Reward points to help you better!!!

Regards,

Shyamal

[Former Member]

Hi Vivek..,

Create a formula Characteristics with lower and upper limits and assign the formula to calculate the output in the inspection plan.

i suppose this will solve the problem. if you need the formula to calculate comeback.

regards.