Sample drawing procedure Square root n+1

[subramanian_subramanian]

Hi,

Pls guide on how to approach this scenario.

1. Sampling drawing procedure as fixed until 5 container.

2. Sampling drawing procedure as Square root N+1 if more than 5 containers.

Thanks in advance

Regards

Subbu.

[former_member211618 · Accepted solution]

Plz go through the below link may useful to your requirement.

[subramanian_subramanian · Accepted solution]

Hi,

Thanks for your reply, If anybody could share their similar experience and solution, it would be great to the forum as well as to me. the thread attached shows more on customizing with ABAPer. is it not possible on standard.

Regards

Subbu.

[former_member211618 · Accepted solution]

Plz search in Google you will get no.of threads for your requirement.

[subramanian_subramanian · Accepted solution]

Thanks for your reply, If you give us the procedure how to maintain this scenario in system step by step, it would be helpful for us. I have googled it it show the formula TRUNC(SQRT(P2)+1), but how to use this formula for the below requirement.

1. Sampling drawing procedure as fixed until 5 container.

2. Sampling drawing procedure as Square root N+1 if more than 5 containers.

BR

Subbu.

[former_member211618 · Accepted solution]

If u press F1 u will get below help,it suite your requirement.  

Formula Field for the Number of Samples

Use

Enter a formula in this field, to calculate the number of samples. The formula is evaluated in the following places using the SAP formula interpreter:

• In the sample-drawing procedure at syntactical correctness

• At lot creation, if the number of physical samples has to be calculated

The following formula parameters are available:

• P1   Lot quantity

• P2   Number of containers

• P3   Number of primary samples

You can only use formula parameter P3 in a formula to calculate the number of pooled samples.

Example

The number of primary samples results, for example, from the proportion of whole numbers (square root of the number of containers + 1)

The formula can (using the standard settings) be built up then, for example, in the following way:

FORMULA = TRUNC(SQRT(P2)+1)

For example, with 10 containers there are 4 primary samples.

[Former Member]

Hi,

You can use the below formula for your requirement.

IF P2=<5 THEN P2 ELSE TRUNC(SQRT(P2)+1)

CSN

[subramanian_subramanian]

Thank you very much Sreenath,

Pls can you suggest what other fields i need to fill in.

one more point,

Even we take samples from multiple containers based on root n+1, it will made as a single pooled sample and RR and UD for single sample (just for an note-but the sampled label will be affixed to all the sampled container).

BR

Subbu.

[Former Member]

Hi,

Labels can be printed only for the containers based on root n+1 in the standard system.

For Ex: You got 100 containers and as per the formula you will get 11 containers to be sampled.

In this case you have to develop an ABAP program to print the labels.From QPR4 transaction you

can print only 11 labels.

In lot container field you have to enter BAG and while doing GR BAG has to be entered.

If you need container then you have to enter CAN in drawing procedure and in GR also enter CAN.

If there is a mismatch in drawing procedure and GR system will not assign inspection plan

automatically.

CSN

[subramanian_subramanian]

Hi Sreenath,

Thank you very much,

Pls can you suggest what other fields i need to fill in QPR1

Even we take samples from multiple containers based on root n+1, it will made as a single pooled sample and RR and UD for single sample. Pls can you explain what other fileds to be filled in this transaction apart from this formula.

BR

Subbu.