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.

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
 

Column2C_MATNR2Material
 

Free
 

0LOT_HERKInspect.Lot Origin
 

Column10BATCHBatch
 

Free
 

C_HSDATDate of Manufacture
 

Free
 

C_VERIDProduction Version
 

Column30INSP_LOTInspection Lot
 

Free
 

C_TEXT1Prod Version text
 

Column4C_ENSTEHDDate of Lot Creation
 

Free
 

0CO_AREAControlling area
 

Row1C_LTXA1Operation short text
 

Free
 

C_WORKCTRWork Center
 

Free
 

0COSTCENTERCost Center
 

Free
 

C_PPSORTKKey Field Insp Point
 

Free
 

C_COSTCENCost Center for QM
 

Row2C_CHARTXTInsp. char text
 

Free
 

C_SATZSRes.Rec.Status
 

Free
 

C_DETAILENumber of the Ind.
 

Free
 

C_USERC2User Field for 10 Ch
 

Row30TOLERANCETolerance 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