Certificate Content - Result of Summary & Results of Partial Lots

[Former Member]

Hello QM-Gurus,

I need your help.

I have a material which requires batches.

The delivery with batch split is made and in the Background an inspection lot is created with 2 partial lots (QE51n).

The Usage Decision is made successfully.

Now I have values for

•   Partial Lot 000001
•   Partial Lot 000002
•   and Lot 100000000203

In the certificate the values display from Partial Lot 000001 and 000002.

But I would like see the values from Lot 100000000203 additional.

How can I do this?

Can anyone help?

Example:

measured values:

Partial Lot 000001:   ParamXYZ UoM mm Value 5

Partial Lot 000002:   ParamXYZ UoM mm Value 7

Inspection Lot 100000000203: ParamXYZ UoM mm Value 6 (average from PL 000001 & PL 000002)

SPRO Define Data Origin / Origin of characteristic values

If the Option "Read insp.lots" activated, than the values from the Batch Lots.

Certificate:

Partial Lot 000001:   ParamXYZ UoM mm Value 5

Partial Lot 000002:   ParamXYZ UoM mm Value 7

If this Option deactivated, than in the certificate the values from the InspectionLot.

Certificate:

Partial Lot 000001:   ParamXYZ UoM mm Value 6

Partial Lot 000002:   ParamXYZ UoM mm Value 6

I need this form in the Certificate:

Certificate:
Inspection Lot 100000000203: ParamXYZ UoM mm Value 6

Partial Lot 000001:   ParamXYZ UoM mm Value 5

Partial Lot 000002:   ParamXYZ UoM mm Value 7

Ulrike

[former_member42743]

I don't think the form is set up to give the summarized batch results and the values of the individual partial lots.

I wouldn't fool around with the standard SAP provided values in config.  (i.e. the "origin of results" FM's).  You can create you own, new origin of results (Z1 for instance), and write your own FM's to go into it or use an SAP provided one.

You'll also have to modify the form to work with any new functional modules you create.  Changing the underlying COA program is definitely not recommended.

Your new FM will need to pull both the summrized and partial lot values from SAP.  You than modif the form to print them.

You might have to set it up as two passes almost for printing.  In the top section print all the summarized values.  Then in a section below that, print all the partial lot info.  Basically making two passes with the progam.

Craig

[Former Member]

Hi Craig,

thank you for your response.

I think, a new FM is not the simple solution.

I have created a delivery with 2 batches.

In the certificate the values displayed to the 2 batches.

The structure in the certificate is here:

Batch 112233

characteristic 010      7,5 %

Batch 332211

characteristic 010      13,5 %

I need this structure:

InspectionLot XYZ

characteristic 010

10,5 %

Batch 112233

characteristic 010      7,5 %

Batch 332211

characteristic 010     13,5 %

In the moment the structure has only 2 data records, but I need 3.

Can you understand me?

Sorry for my late reply - I was on holiday.

Thanks,

Ulrike

[Former Member]

Hello,

I have an solution for my problem.

I copied the program RQCAAP00.

In the new program "ZRQCAAP00_SUM_DET" I changed the include ZAAP00F02 on following places:

FORM batch_level

ORIGINAL:      LOOP AT tvbdpl WHERE uecha EQ g_vbdpl-posnr.

NEW:               LOOP AT tvbdpl.

ORIGINAL:     * Split item found?
                       IF g_chargen_exist EQ c_kreuz.
                       REFRESH g_mchar_tab.
                       *   Read batch master record for obtaining more information
                       LOOP AT g_charg_pos_tab.
                         CLEAR g_mchar_line.
                         PERFORM material_charge_lesen
                             USING    g_charg_pos_tab-matnr
                                            g_charg_pos_tab-werks
                                            g_charg_pos_tab-charg
                            CHANGING g_mchar_line.
                         APPEND g_mchar_line TO g_mchar_tab.
                     ENDLOOP.                           " g_charg_pos_tab

NEW:              * Split item found?
                       IF g_chargen_exist EQ c_kreuz.
                       REFRESH g_mchar_tab.
                       *   Read batch master record for obtaining more information
                       LOOP AT g_charg_pos_tab.
                         CLEAR g_mchar_line.
                         PERFORM material_charge_lesen
                             USING    g_charg_pos_tab-matnr
                                            g_charg_pos_tab-werks
                                            g_charg_pos_tab-charg
                            CHANGING g_mchar_line.
                         IF g_charg_pos_tab-charg IS INITIAL.
                           g_mchar_line-matnr = g_charg_pos_tab-matnr.
                           g_mchar_line-werks = g_charg_pos_tab-werks.
                         ENDIF.
                         APPEND g_mchar_line TO g_mchar_tab.
                     ENDLOOP.                           " g_charg_pos_tab

FORM lot_level

ORIGINAL:     *       Only last lot which corresponds
                       *       to all the other selection criteria
                       PERFORM lots_sort.

                     MOVE g_lot_line-qals TO l_lot-qals.
                     MOVE g_lot_line-qalt TO l_lot-qalt.
                     MOVE g_lot_line-qave TO l_lot-qave.
                     MOVE c_kreuz         TO l_lot-kzlot.

NEW:              *       Only last lot which corresponds
                       *       to all the other selection criteria
                       PERFORM lots_sort.

                       IF l_batch-vbdpl-charg IS INITIAL.
                          g_lot_line-qalt-TEILLOS = '000000'.
                          data objectnr TYPE STRING.
                          CONCATENATE 'QT' g_lot_line-qalt-PRUEFLOS

                              g_lot_line-qalt-TEILLOS INTO objectnr.
                          g_lot_line-qalt-OBJNR = objectnr.
                          g_lot_line-qalt-LS_POSNR = l_batch-vbdpl-posnr.
                          g_lot_line-qalt-MENGE = l_batch-vbdpl-KCMENG.
                          g_lot_line-qalt-MENGEIST = l_batch-vbdpl-KCMENG.
                          g_lot_line-qalt-CHARG = l_batch-vbdpl-charg.

                          g_lot_line-qave-TEILLOS = '000000'.
                       ENDIF.

                     MOVE g_lot_line-qals TO l_lot-qals.
                     MOVE g_lot_line-qalt TO l_lot-qalt.
                     MOVE g_lot_line-qave TO l_lot-qave.
                     MOVE c_kreuz         TO l_lot-kzlot.

The new program "ZRQCAAP00_SUM_DET" I have assigned to Print output (Transaction V/34)

Perhaps this also helps someone other...

Ulrike