Certificates with inspection results in one plant but shipped from another plant

[former_member665800]

Hi,

I need to create a certificate which is inspected in one plant and shipped from another.

Business case:

The product is produced in plant 1, then shipped with stock transport order to plant 2 which is a warehouse managed by an external partner.

The product is shipped with outbound delivery from plant 2 to the customer.

The product is batch managed.

I transfer the inspection results in plant 1 to batch classification (class 023 which is client specific).

Problem:

I can create a certificate for the batch in plant 2 using transaction QC22 which displays all values from the batch classification. However, when i create a certificate for delivery using transaction QC20, the value are not dispalyed.

Any tips of how to get this to work?

Best regards

Eva

[busyaban7]

Hi Eva,

I think, for your STO process, QC22 is the right transaction to create a COA.

I believe, you are not really following any SD process like Sales Order, delivery creation, isn't it? If so, QC20 may not provide you the output as it's linked to SD flows, like SD configuration for output types, maintenance of access sequence,  output determination procedure, etc.

Please can you check below threads and take clues form them -

http://scn.sap.com/thread/1325348

https://scn.sap.com/thread/714189

http://scn.sap.com/thread/2124442

Thanks to all original contributors for above threads!!

Thanks,

Arijit

[former_member665800]

Hi Arijit,

Thanks for the quick response. Please let me clarify the process.

1. Process order using 04 inspection in plant 1

2. Usage decision transfers inspection results to batch classification (client specific)

3. Stock transport order is created between plant 1 and 2

4. Outbound delivery with reference to stock transport order in plant 1

5. Goods receipt in plant 2

6. Sales order with outbound delivery in plant 2 with automatic creation of certificate when posting goods issue for delivery. Certificate produced for delivery does not contain batch classification values.

However, if I use t-code QC22 (certificate for batch) classification values are displayed.

I have set up the profile to use results origin for batch classification and not inspection results. I have also tried to pull result from the production chain and activated stock transfers.

All with the same result, no batch classification values in certificate for delivery.

I hope this clarifies further.

Best regards

Eva

[former_member42743]

Eva,

Can you provide a screen shot of the settings used in the Cert profile for the characteristics?

I suspect you have some incorrect settings in that.

Craig

[nitin_jinagal]

In addition to screenshot, please check if there is any message displayed when you put delivery number to the certificate view in the certificate profile.

And might be silly to ask, but did you check if the delivery number is correct or it contains the required batch ??

NJ

[former_member665800]

HI Craig,

Thanks for your interest, it is much appreciated.

I have tried two different methods apart from trying to pull values directly from the batch classification in plant 2.

Certificate profile test 1:

Batch classification

Data origin: Not maintained

Characteristic category: Class characteristic

Batch characteristics

Results origin: Batch classification

Inspection specificaitons: Batch classificatoin

Certificate profile test 2:

Inspection results from the production chain (inspected in plant 1, but shipped from plant 2)

Data origin from characteristics from inspections: material number and plant 1 with sort number 10

Stock transfer: Transfer postings and stock transport orders

Characteristic category: Master inspection characteristics

Plant: plant 1

Master inspection characteristics

Results origin: Inspection batch from the production chain

Inspection specificaitons: Mateial spec from the production chain

Material sort number: 10 - Material in plant 1

Certificate profile test 3:

Inspection results from the production chain (inspected in plant 1, but shipped from plant 2)

Data origin from characteristics from batches: material number and plant 1 with sort number 10

Stock transfer: Transfer postings and stock transport orders

Characteristic category: Class characteristic

Batch characteristics

Results origin: Inspection batch from the production chain

Inspection specificaitons: Mateial spec from the production chain

Material sort number: 10 - Material in plant 1

All of the above display the following message when attempting to produce a certificate either from QC02 or through QC20:

"No lot was found for cert. profile".

The batch specified in the delivery has both inspection results in plant 1 as well as batch classificaiton values which are client specific.

Best regards

Eva

[former_member665800]

Hi Nitin,

Please see my reply to Craig above.

when I check the batch I can see the following:

1. Batch is inspected in plant 1 and inspection has a UD,

2. Correct batch is assigned to the delivery

3. The batch-where-used list contains the trace from the batch in plant 2 to plant 1 where I can also see the inspection lot in plant 1.

When I use batch classification in the certificate profile, I can produce a certificate with batch classification values displayed using t-code QC22 but the value are not displayed when using t-code QC20.

Best regards

Eva

[former_member42743]

In a sandbox, try creating and processing a manual inspection lot in the delivering plant of the same type as in the original plant.  You might find it might now work.

I don't believe you'll find that the standard SAP program will go back to the original plant, even with a batch-where used list.

QC22 works because it is utilizing the batch for all the values.

QC20 doesn't because it doesn't find an inspection lot in the plant making the delivery.

To get the values from the batch, try the following values:

CHAR: 2 Class characteristic

Characteristic Name:   xxxxxxxxxxxxx

Result origin: 02 Batch classification

Short text orign: 02 Class Characteristic

Insp. spec origin: 02 Batch specification

Strategy for skip: 02 Batch charactersitic value

Use whatever is appropriate in the fields to the right of Strategy for skip.

Do not make any entries in any fields to the left if not mentioned above.

Let us know the resutls.

Craig

[former_member665800]

Hi Craig,

For my client it was not an option to create another inspection lot in the delivering plant.

However, we have solved the problem by using a customer exit in the print program.

The solution is as following:

1. We created a Z-table containing the fields Delivering plant and Inspection plant

2. We incorporated the logic in the customer exit as follows:

If the delivering plant is maintained in the Z-table, read the entry in the inspection plant. Then go search for inspection lot in the inspection plant instead of the delivering plant.

This is tested this morning and works like a treat!

We are aware that this logic only works if all inspections are executed in the inspection plant and that we may have to enhance the logic if the delivering plant also inspects. However, this is not an issue at the moment, but you never know what lies ahead in new process design or acquisition of new companies.

@Craig and all who has come with advice - a great thank you!

Best regards

Eva

[former_member42743]

Check my blogs out concerning COA programs.  The creating of an inspection lot was only for a test, not a suggestion as a solution.

I would suggest at some point, instead of program changes, you look at creating a FM for getting the necessary results.  The FM is configured in as a new choice for "orign of inspection results".  You might also need one for "origin of specifications" as well.  These are then selected in the COA profile when the profiles are set up.

What you put in the FM would be up to you but I would normally first look for results in the delivering plant.  If none where found, then go back to the orginal plant or production plant looking for a valid inspection lot.  No real need for a Z-table by doing that.

If you wanted to get real specific, you can even set up multiple FM's, one for each potential source plant.  I.e. choice X1 would look an inspection lot in plant A.  X2 in plant B, X3 in plant C, etc...

Or you can set up one that checks through all the plants.

Or design it to check a material class characterisitc to determine which plant(s) and in which order to search.  That makes the choice very flexiable on a material by material basis. 

There are lots of ways to design it when doing it this way.

Craig

[former_member665800]

HI Craig,

Apologies for the long response time.

I also had in my mind to create a new function module, but the developer wanted to go the other way with the customer exit.

However, we have removed the customer exit and have no entries in the table we created.

Strange thing - it is working according to the testing scenario 2 futher up in this thread.

These are the settings:

Inspection results from the production chain (produced inspected in plant 1, but shipped from plant 2)

Certificate profile is assigned to material without plant specification.

Data origin from characteristics from inspections: material number with sort number 10

Stock transfer: Transfer postings and stock transport orders

Characteristic category: Master inspection characteristics

Plant: Plant 1

Master inspection characteristics

Results origin: 03 Inspection batch from the production chain

Inspection specificaitons: 03 Mateial spec from the production chain

Material sort number: 10

When producing a certificate for a delivery the message that a inspection lot does not exit - just confirm and display. The inspection results are displayed correctly on the certificate, in VL02n, QC21 and in QC02 when displaying a certificate for delivery.

One of lifes great mysteries - we tested a lot before.

Best regards

Eva

[Former Member]

Dear Eva,

Could you please help me with the detailed steps if above approch worked. I have a similer requirment with my client.

Thanks,

Srini

[Former Member]

Eva,  I also have a similar requirement from my client.  I would also ask if you could give a detailed description of your solution.  I have tried making similar settings and it is not working yet.

Thank you,

Bruce