Versions Compared

Key

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



 

 


Description

BW - QM - Results - Column (Core Query)

Technical Name

BW_QRY_MVQM01_0003 Migrate to

BW_QRY_CPQM02_0005

Application

QM

Info-provider

MVQM01

MVQM01 → CPQM02

Usage type

Direct Execution

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)

V_0BATCH_00010BATCH

Selection Option

No

 


Material (Select option, Optional)V_C_MATNR2_0001C_MATNR2

Selection Option

No

 


Operation (Single Value, Optional)V_C_LTAX1_0001C_LTAX1

Single Value

No

 


Inspection Lot (Select option, Optional)V_0INSP_LOT_00010INSP_LOT

Selection Option

No

 


Date of lot creation (Select Option, Optional)V_C_ENSTEHD_0001C_ENSTEHD

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

 


Task list group (Select. option, Optional)V_0PLNNR_00010PLNNR

Selection Option

No

 

Insp. Char Text (Select Option, Optional)V_C_CHARTXT_0001C_CHARTXT

Selection Option

No

 


Date of Manufacture (Selection Option, Optional)V_C_HSDAT_0001C_HSDAT

Selection Option

No

 

Key Date (Interval / Optional)V_0INSP_LOT__C_KEYDATE_00010INSP_LOT__C_KEYDATEIntervalNo
 

Plant (Authorization with input select option)V_C_PLANT_0012C_PLANT

Authorization with input select option

Yes

 


Variable Sequence

Filters

ObjectFilter ValueExplanation
N/AN/AN/A

Key figures

DescriptionObjectCalculation rule detailText Replacement variableDisplayCurrency ConversionUnit Conversion
Quantitative ResultK_MITTELStandard Key FigureN/ADefaultN/AN/A
 


Characteristics

LocationPositionInfo-object NameInfo-object TextExplanation (if needed)
Free
C_PLANTPlant
 

Column
Column
2C_MATNR2Material
 

Free
0LOT_HERKInspect.Lot Origin
 

Column
Column
10BATCHBatch
 

Free
C_HSDATDate of Manufacture
 

Free
C_VERIDProduction Version
 

Column
Column
30INSP_LOTInspection Lot
 

Free
C_TEXT1Prod Version text
 

Column
Column
4C_ENSTEHDDate of Lot Creation
 

Free
0CO_AREAControlling area
 

Row
Row
1C_LTXA1Operation short text
 

Free
C_WORKCTRWork Center
 

Free
0COSTCENTERCost Center
 

Free
C_PPSORTKKey Field Insp Point
 

Free
C_COSTCENCost Center for QM
 

Row
Row
2C_CHARTXTInsp. char text
 

Free
C_SATZSRes.Rec.Status
 

Free
C_DETAILENumber of the Ind.
 

Free
C_USERC2User Field for 10 Ch
 

Row
Row
30TOLERANCETolerance value
 

Free
C_RESULTResult
 

Free
C_USERC1User Field for 18 Ch
 

Free
C_MRPRMKTShort Text(QAMR)
 

Free
C_SRPRMKTShort Text
 

Free
C_SEPRMKTShort Text
 

Free
C_PMETH2Inspection Method
 

Free
0PMTVERSIONInsp. Meth. Version
 

Free
0PPLANTPlant of Insp. Meth.
 

Free
0MCHAR_PLNTPlant of Charact.
 

Free
0MASTERCHARMaster Insp. Charac.
 

Free
C_VNAMEWho Made Usage Decis
 

Free
C_QZEITVInsp. Starting Time
 

Free
C_PRUETEnd Time of the Insp
 

Free
0PROFIT_CTRProfit Center
 

Free
C_MBETGInsp.Result Val-Glob
 

Free
C_QERGDATResult Origin (Glob)
 

Free
C_VCODEUsage Decision Code
 

Free
C_LSENTSTTime of Lot  QALS
 

Free
C_ATTRIAttribute Res.(Glob)
 

Free
C_PROBENRPartial sample(QASR)
 

Free
C_PRUEFERInspector
 

Free
C_ENTSTEHDate of Inspection P
 

Free
C_PPENTSTTime of Insp.QAPP
 

Free
C_PRUTVStart Time Insp.
 

Free
C_MSEH6Unit of measurement
 

Free
C_USERD1User Field for Date
 

Free
C_USERT1User Field for Time
 

Free
C_DUMMY20Text Line for Additi
 

Free
C_PRUDVInsp. Start Date
 

Free
C_LSPASTDInsp StartDate QMLot
 

Free
C_POSTEGeneral Information
 

Free
C_PRUDTEnd Date of the Insp
 

Free
C_AUFNROrder Number
 

Free
C_VORNROperation number
 

Free
C_VDATUMDate of Code Used fo
 

Free
C_VEZEITETime Usage Deci.QAVE
 

Free
C_KOTEXTTaskList description
 

Free
C_KTEXTProd Recipe text
 

Free
C_PRGRPProduct Family
 

Free
C_DISPOMRP controller
 

Free
C_MARKIndiv Result Marker
 

Free
0PLNNRTask list group
 

Free
C_BISMTOld Material Number
 

Free
C_CUSTIDCustomer
 

Free
C_KURZTXTShort Text for Code
 

Free
C_SRORIGIOrig Val Before(QASR
 

Free
0INSP_LOT__0VENDORVendor
 

Free
C_MKVERS2VersionText Insp Cha
 

Free
0INSP_LOT__C_KEYDATEKey Date
 

Free
0LOGSYSSource 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