SAP BLOG How to get old value and New value for Inspection characteristics

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,442
Tepki puanı
7
Puanları
6
Purpose:

The Purpose of this blog to provide the information about to how to get the changed the results values for Inspection characteristic for an inspection Plan.This is one of the common business requirements to have report which shows Old value and new value when the user change results for Inspection characteristics from results recording.

Prerequisites:

We get the changed values for any inspection characteristic;we must make the check Mark for “RR Change Docs”.

QS21.png


Due to this setting, System will generate the Change document when the change occurs in results for this MIC. This setting can be done at MIC level or it can be selected in control indicators from Inspection plan. these change documents can be seen in “CDPOS” table.

Now will see how functionality of “RR Change Docs” works.



Step-1: Creation of Inspection lot Manually

T-code: QA01

Path
: SAP Menu – Logistics – Quality Management – Quality Inspection – Inspection Lot – Processing – QA01 – Create

QA01.png


Follow the above path or Enter the T-Code QA01. System will direct below screen. Here Enter Material, Plant and Inspection Lot Origin.

qa01_01.png


After entering the above details press enter or continue then system open the below screen. Here Enter the Batch if the Material is batch managed, Insp.Lot Qty and then Press enter Key.

QA01_02-1.png


Once Press enter Key, System automatically assign the tasks list and calculate the sample Size then save the inspection lot.

Step-2: Results Recording for Inspection lot 890000000153

T-code:
QA32 / QE01

Path: SAP Menu – Logistics – Quality Management – Quality Inspection – Worklist -Inspection Result – For Operation – QE01 – Record.

QE01.png




Enter the Inspection lot number and press enter. System direct to below screen and record the results and save it.

QE01_02.png


Note: Initial result for Length is 4.5



Step-3: Change the value for inspection characteristics in Result recording

T-code:
QA32 / QE02

Path: SAP Menu – Logistics – Quality Management – Quality Inspection – Worklist -Inspection Result – For Operation – QE02 – Change

qe02_01-1.png




Enter the Inspection lot number and press enter. system direct to below screen and change the value to 5.8 by put in process and save the inspection lot.

QE02_02.png


Note: Inspection result for Length entered as 5.8 Now.

As I mentioned, Due to “RR Change docs” indicator selection system will generate the change document with old value and newly updated value for this inspection characteristic.



For Quantitative MIC:

Step:4 Get the inspection characteristic value from QAMR table


To Know the Inspection characteristics which are having changes in their results we have to check in QAMR table through below logic.

Technical Logic:

Pass (Inspection lot) PRUEFLOS_QAMR to QAMR table along with (RR change docs) QAMR_AENDBELEG= X then get the value of QAMR_MERKNR(Characteristic), QAMR_VORGLFNR (Node Number).

As per the above logic, Go to SE16N, Enter Table QAMR and give the inputs i.e Inspection lot i.e890000000153 in the field of inspection lot and select the Inspection lot, Node number, characteristic and change docs fields in QAMR and execute.

qamr_01.png


After execution with above input values, will get the entries for the inspection lot as below.

QAMR_03.png


Here Characteristic 20 having indicator X that means characteristic 20 from the inspection lot 890000000153 result was changed. Since there was change in the value, this X indicator got updated in the table.

QAMR_04N.png




Step:5 Get old value and New value for Inspection characteristics from CDPOS table

To get the old value and New value for inspection characteristic which are having indicator X in QAMR table, we must combine the values of PRUEFLOS (Inspection lot), VORGLFNR (Node number), MERKNR(Characteristic) to get OBJECTID



PRUEFLOS (Inspection lot): 890000000153

VORGLFNR (Node number): 00000001

MERKNR(Characteristic) :0020

Example for OBJECTID: 890000000153000000010020



Technical Logic:

Pass this combined value to OBJECTID_CDPOS field of CDPOS table along with CDPOS_OBJECTCLAS=QAMR, CDPOS_FNAME= ORIGINAL_INPUT and get the value of VALUE_OLD and VALUE_NEW

As per the above logic, Go to SE16N, Enter Table CDPOS and enter the input values as mentioned in the logic and execute.

CDPOS_01.png


Once executed the CDPOS table with given inputs, above results populated by system. From the table results we can see that Old Value is 4.5 and New value is 5.8

CDPOS_02.png


CDPOS_03.png




For Quantitative MIC:


Repeat the step No:1 to 3,



Step:6 Get the Quantitative inspection characteristic value from QAMR table

To Know the Inspection characteristics which are having changes in their results we have to check in QAMR table through below logic.

Technical Logic:

Pass (Inspection lot) PRUEFLOS_QAMR to QAMR table along with (RR change docs) QAMR_AENDBELEG= X then get the value of QAMR_MERKNR(Characteristic), QAMR_VORGLFNR (Node Number), KATALGART1(Catalog Type), GRUPPE1(Code Group) and CODE1(Code)

As per the above logic, Go to SE16N, Enter Table QAMR and give the inputs i.e Inspection lot i.e 890000000153 in the field of inspection lot and select the Inspection lot, Node number, characteristic and change docs fields in QAMR and execute.

QAMR_QL_01.png


After execution with above input values, will get the entries for the inspection lot as below.

QAMR_QL_02.png


Here Characteristic 10 having indicator X that means characteristic 10 from the inspection lot 890000000153 result was changed. Since there was change in the value, this X indicator got updated in the table.

Step:7 Get old value and New value for Inspection characteristics from CDPOS table

To get the old value and New value for inspection characteristic which are having indicator X in QAMR table, we must combine the values of PRUEFLOS (Inspection lot), VORGLFNR (Node number), MERKNR(Characteristic) to get OBJECTID



PRUEFLOS (Inspection lot): 890000000153

VORGLFNR (Node number): 00000001

MERKNR(Characteristic) :0010

Example for OBJECTID: 890000000153000000010010

Technical Logic:

Pass this combined value to OBJECTID_CDPOS field of CDPOS table along with CDPOS_OBJECTCLAS=QAMR, CDPOS_FNAME= CODE1 and get the value of VALUE_OLD and VALUE_NEW

As per the above logic, Go to SE16N, Enter Table CDPOS and enter the input values as mentioned in the logic and execute.

CDPOS_QL_01.png


Once executed the CDPOS table with given inputs, Below results populated by system. From the table results we can see that Old Value is ACCP and New value id REJC

CDPOS_QL_02.png




Step:8 Get short text for Codes for old value and New value from QPCT table.

Pass the VALUE_OLD and VALUE_NEW from CDPOS table to QPCT table along with KATALGART1(Catalog Type), GRUPPE1(Code Group) and CODE1(Code) from Step-6 and execute.

CDPOS_QL_03.png


CDPOS_QL_04.png


From the output of the QPCT table, we can see the values for old value and New value for Qualitative MIC.



Conclusion: By using “RR Change docs” control indicator, we can capture the changed values for inspection characteristics.

Okumaya devam et...
 
Üst