Versions Compared

Old Version 4

changes.mady.by.user Thibaud ROYET-EXT

Saved on

compared with

New Version Current

changes.mady.by.user Anon, Kasemvilas

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.



 

 


Description

BW - QM - Inspection Results by Lot (Core Query)

Technical Name

BW_QRY_MVQM01_

0001

0002 Migrate to

BW_QRY_CPQM02_0011

Application

QM

Info-provider

MVQM01

Usage type

Direct Execution

/ Workbook


Expected users



Table of Contents
maxLevel3

Workbook/Query General Description

This query is a simple view of QM Inspection Results general and quantitative data. It is however used in the worbook MiniTab. 

General parameters

Global properties

TabScreenshotComment
Display
Image Modified
 

Rows/Columns
Image Modified
 

Value Display
Image Modified
 

Planning
Image Modified
 

Extended
Image Modified
 

Variables

Definitions

Variable Description

Variable NameInfo-object

Selection Type

Required

Description/Explanation

Batch (Selection Option, Optional)
Task list typeV_
0BATCH_00010BATCH

Selection Option

No

 Date of lot creation (Select Option, Optional)V_C_ENSTEHD
0PLAN_TYPE_0001
C
0PLAN_
ENSTEHD
TYPE

Selection Option

No

 


Material (
Select option
Interval, Optional)V_C_MATNR2_
0001
0002C_MATNR2
Selection Option

Interval

No

 

Vendor (Select Option, Optional)

V_0INSP_LOT__0VENDOR_00010INSP_LOT__0VENDOR

Selection Option

No

 MRP controller (Selection Option, Optional)V_C_DISPO

Equipment

V_C_EQUIPMT_0001C_
DISPO
EQUIPMT

Selection Option

No

 Operation (Single Value, Optional)

Group Counter

V_C_

LTAX1Inspection Lot (Select option, Optional)V_0INSP_LOT_00010INSP_LOT

Selection Option

No

 Inspection Lot Origin (Selection Option, Optional)V_0INSP_LOT__0LOT_HERK_00010INSP_LOT__0LOT_HERK

Selection Option

No

 Insp Start Date QM Lot (Select Option, Optional)V_C_LSPASTD_0001C_LSPASTD

Selection Option

No

 Insp Start Dat- Glob (Select Option, Optional)V_C_PRUDV_0001C_PRUDV

Selection Option

No

 End date of insp (Select Option, Optional)V_C_PRUDT_0001C_PRUDT

Selection Option

No

 Date Usage Decision (Selection Option, Optional)V_C_VDATUM_0001C_VDATUM

Selection Option

No

 Attribut Res. (Glob) (Select Option, Optional)V_C_ATTRI_001C_ATTRI

Selection Option

No

 Origin of Results Data (Glob) (Select Option, Optional)V_C_QERGDAT_001C_QERGDAT

Selection Option

No

 

PLNAL2_0001

C_
LTAX1

Single Value

No

 
PLNAL2

Selection Option

No


Task list group (Select. option, Optional)V_0PLNNR_00010PLNNR

Selection Option

No

 Insp. Char Text (Select Option, Optional)

Inspection DateV_
C
0CALDAY_
CHARTXT_0001
00070CALDAYIntervalNo
Inspection Lot (Single value
C_CHARTXT

Selection Option

No

 Master Insp CharactV_0MASTERCHAR_00010MASTERCHAR

Selection Option

No

 Date of Manufacture (Selection Option
, Optional)V_
C
0INSP_
HSDAT
LOT_
0001
0002
C
0INSP_
HSDAT
LOT
Selection Option

Single value

No

 


Plant (Authorization with input select option)V_C_PLANT_0012C_PLANT

Authorization with input select option

Yes

 

Variable Sequence

Image RemovedImage Added

Filters

ObjectFilter ValueExplanation
N/AN/A
C_DETAILE= #
C_LREC= X
N/A

Key figures

DescriptionObjectCalculation rule detailText Replacement variableDisplayCurrency ConversionUnit Conversion
Quantitative ResultK_MITTEL
No. of values0NO_OF_VALSStandard Key FigureN/ADefaultN/AN/A
Lower tol. limit0LWR_LIMITStandard Key FigureN/ANumber of Decimal Places: 0.0000N/AN/AUpper tol. limit0UPPR_LIMITStandard Key FigureN/ANumber of Decimal Places: 0.0000N/A
Samples O.K.0SAMPS_OKStandard Key FigureN/A
Lower Plausibility LK_PLAUSIUStandard Key FigureN/A
DefaultN/AN/A
Upper Plausibility LK_PLAUSIO
Rejected samples0SAMPS_BADStandard Key FigureN/ADefaultN/AN/A
First Lower SpecificK_GRENZN1Standard Key FigureN/ADefaultN/AN/AFirst Upper SpecificK_GRENZB1
Sum single vals0SUM_OF_XStandard Key FigureN/A
Default
Number of Decimal Places: 0.0000N/AN/A
Second
Lower
Specifi
tol. limit
K
0LWR_
GRENZEU
LIMITStandard Key FigureN/A
Default
Number of Decimal Places: 0.0000N/AN/A
Second
Upper
Specifi
tol. limit
K
0UPPR_
GRENZEO
LIMITStandard Key FigureN/A
DefaultN/AN/ASum of Target Values0SUMSOLLWStandard Key Figure
Number of Decimal Places: 0.0000N/A
Default
N/A
N/AClassChar LowerLimitK_LWRLIMStandard Key FigureN/ADefaultN/AN/AClassChar UpperLimitK_UPPRLIMStandard Key FigureN/ADefaultN/AN/A

 


Characteristics

LocationPositionInfo-object NameInfo-object TextExplanation (if needed)
Free
Row
C_PLANT
1
Plant
0PLNNR
 
Task list group
Row

Free
C_MATNR2Material
 Free
0LOT_HERKInspect.Lot Origin 

Row2
Row0BATCHBatch Row
C_
HSDATDate of Manufacture FreeC_VERIDProduction Version Row0INSP_LOTInspection Lot FreeC_TEXT1Prod Version text RowC_ENSTEHDDate of Lot Creation Free0CO_AREAControlling area RowC_LTXA1Operation short text 
PLANNODNode Operation
Free
C_
WORKCTRFree0COSTCENTERCost Center RowC_PPSORTKKey Field Insp Point FreeC_COSTCENCost Center for QM Row
EQUIPMT
Work Center 
Equipment
Row3
C_CHARTXTInsp. Charact.
char text
Text
 

Free
C_SATZS

0PMTVERSION
Res
Insp.
Rec
Meth.
Status 
Version
Row
C_DETAILENumber of the Ind. FreeC_USERC2User Field for 10 Ch
60BATCHBatch
 

Row
0TOLERANCE
4
Tolerance value
0CALDAY
 FreeC_USERC1User Field for 18 Ch FreeC_MRPRMKTShort Text(QAMR) FreeC_SRPRMKTShort Text FreeC_SEPRMKTShort Text FreeC_PMETH2Inspection Method Free0PMTVERSIONInsp. Meth. Version Free
Calendar Day
Row
C_RESULTResult 
50INSP_LOTInspection Lot
Free
0PPLANTPlant of Insp. Meth.
 

Free
0MCHAR

C_
PLNT
PMETH2Inspection Method
Plant of Charact. 

Free
0MASTERCHAR
Master Insp. Charac. 

C_INSP_CHInsp. Charact. Numb
FreeC_VNAMEWho Made Usage Decis FreeC_QZEITVInsp. Starting Time 

Free
C_
PRUET 
DETAILE
End Time of the Insp Free0PROFIT_CTRProfit Center FreeC_MBETGInsp.Result Val-Glob
Number of the Ind.
Free
C_
QERGDAT
LRECLast Record
Result Origin (Glob) 

Free
C_
VCODE
PLNAL2Group counter
Row9
Usage Decision Code Free
C_
LSENTST
RESULTResult
Row80ICHAR_UOMUnit of measurement
Free
0LOGSYSSource System
Row70INSP_LOT__C_BATCH2Batch
Free
0INSP_LOT__C_MATNR2Material
Time of Lot  QALS FreeC_ATTRIAttribute Res.(Glob) FreeC_PROBENRPartial sample(QASR) FreeC_PRUEFERInspector FreeC_ENTSTEHDate of Inspection P FreeC_PPENTSTTime of Insp.QAPP FreeC_PRUTVStart Time Insp. FreeC_MSEH6Unit of measurement FreeC_USERD1User Field for Date FreeC_USERT1User Field for Time FreeC_DUMMY20Text Line for Additi FreeC_PRUDVInsp. Start Date FreeC_LSPASTDInsp StartDate QMLot FreeC_POSTEGeneral Information FreeC_PRUDTEnd Date of the Insp FreeC_AUFNROrder Number FreeC_VORNROperation number FreeC_VDATUMDate of Code Used fo FreeC_VEZEITETime Usage Deci.QAVE FreeC_KOTEXTTaskList description FreeC_KTEXTProd Recipe text FreeC_PRGRPProduct Family FreeC_DISPOMRP controller FreeC_MARKIndiv Result Marker Free0PLNNRTask list group FreeC_BISMTOld Material Number FreeC_CUSTIDCustomer FreeC_KURZTXTShort Text for Code FreeC_SRORIGIOrig Val Before(QASR Row0INSP_LOT__0VENDORVendor FreeC_MKVERS2VersionText Insp Cha Free0LOGSYSSource System 

Free
0INFOPROVInfoProvider
 

Cells

Conditions

Condition Name

Active

By default

Key Figure

(Structure)

OperatorValueCharacteristic Assignement
      






Exceptions

Exception Name

Active

By default

Alert Level

OperatorValue

Other parameters

(if different from default)

Yes/No