C_QltyLvlBySvrty

Quality Levels by Severity for OVP card | view: CQLTYLVLBYSVRTY | Extraction: Not supported | Component: Active Quality Control Worklist
Tables used: QALS, QDQL, QDPS
Column Name Description
Material FK Material Number
Plant FK Plant
BillOfOperationsType FK Task List Type
BillOfOperationsGroup FK Key for Task List Group
BillOfOperationsVariant Group Counter
BOOOperationInternalID Number of Task List Node
Sequence Sequence of Operations Within a Plan
QualityLevelInternalID Sequential Counter for Different Quality Levels
Column Name Description
Column Name Description
Column Name Description
QltyLvlIndirectlyChangedOn Change Date of the Quality Level
QltyLvlManuallyChangedOn Change Date (Manual) of the Quality Level
QualityLevelLastInspectionOn Date of Last Inspection
QualityLevelDeletionOn Deletion Date of the Quality Level
QualityLevelResetOn Reset Date of Quality Level
Column Name Description
InspLotUsageDecisionValuation Valuation (Usage Decision) of the Last Inspection Lot Show values
InspLotUsgeDcsnDynValuation Dynamic Modification Valuation of the Last Inspection Lot Show values
InspResultDynModifValuation Dynamic Modification Valuation (Accept/Reject) of Char. Show values
InspectionValuationResult Valuation of the Characteristic from Results Recording Show values
InspectionLotHasQuantity Checkbox Show values
Column Name Description Domain name
QualityLevelCount Quality Levels
InspectionOperation Operation Number in the Quality Level VORNR
InspectionCharacteristic Characteristic Number in the Quality Level QMERKNRP
QltyLvlIndirectlyChangedBy User who Last Changed the Quality Level QAENDERER
QltyLvlManuallyChangedBy User who Manually Changed the Quality Level QAENDERER
InspectionLot Number of Last Inspection Lot with Usage Decision NUMC12
InspLotsWithoutUsageDecision Number of Inspection Lots Without Usage Decision QDYNANZ2
InspLotsSinceStageChg Number of Inspections Since Inspection Stage Change QDYNANZ2
RjctdInspLotsSinceStgeChg Number of Not-OK Inspections (Rejections) Since Stage Change QDYNANZ2
QualityLevelLastOpenInspLot Number of Last Inspection Lot Without Usage Decision NUMC12
QltyLevelCanceledInspections No. of Cancelled Inspections per Char. Since Last Inspection QDYNANZ2
ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
SkipStatusCount Inspection Lots Skipped
Master Data Relations Join Conditions
Storage Location for Batch
  • Material Number
  • Client
  • ?
  • ?
  • Storage Location for Batch
  • C_QLTYLVLBYSVRTY.MATERIAL == MCHB.MATNR
  • C_QLTYLVLBYSVRTY.MANDT == MCHB.MANDT
  • C_QLTYLVLBYSVRTY.[column in domain "WERKS_D"] == MCHB.WERKS
  • C_QLTYLVLBYSVRTY.[column in domain "CHARG_D"] == MCHB.CHARG
  • C_QLTYLVLBYSVRTY.BATCHSTORAGELOCATION == MCHB.LGORT
Key for Task List Group
  • Key for Task List Group
  • Group Counter
  • Task List Type
  • ?
  • Client
  • C_QLTYLVLBYSVRTY.BILLOFOPERATIONSGROUP == PLKO.PLNNR
  • C_QLTYLVLBYSVRTY.BILLOFOPERATIONSVARIANT == PLKO.PLNAL
  • C_QLTYLVLBYSVRTY.BILLOFOPERATIONSTYPE == PLKO.PLNTY
  • C_QLTYLVLBYSVRTY.[column in domain "CIM_COUNT"] == PLKO.ZAEHL
  • C_QLTYLVLBYSVRTY.MANDT == PLKO.MANDT
Task List Type
  • Task List Type
  • Client
  • C_QLTYLVLBYSVRTY.BILLOFOPERATIONSTYPE == TCA01.PLNTY
  • C_QLTYLVLBYSVRTY.MANDT == TCA01.MANDT
Customer Account Number
  • Customer Account Number
  • Client
  • C_QLTYLVLBYSVRTY.CUSTOMER == KNA1.KUNNR
  • C_QLTYLVLBYSVRTY.MANDT == KNA1.MANDT
Level at Which Dynamic Modification Parameters Are Defined C_QLTYLVLBYSVRTY.INSPECTIONLOTDYNAMICLEVEL == TQ39A.DYNLEVEL
Inspection Lot Origin C_QLTYLVLBYSVRTY.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Type
  • Inspection Type
  • Client
  • C_QLTYLVLBYSVRTY.INSPECTIONLOTTYPE == TQ30.ART
  • C_QLTYLVLBYSVRTY.MANDT == TQ30.MANDT
Inspection Severity
  • Client
  • Inspection Severity
  • C_QLTYLVLBYSVRTY.MANDT == QDEP.MANDT
  • C_QLTYLVLBYSVRTY.INSPECTIONSEVERITY == QDEP.PRSCHAERFE
Dynamic Modification Rule
  • Dynamic Modification Rule
  • Client
  • C_QLTYLVLBYSVRTY.INSPLOTDYNAMICRULE == QDDR.DYNREGEL
  • C_QLTYLVLBYSVRTY.MANDT == QDDR.MANDT
Manufacturer Account Number
  • Manufacturer Account Number
  • Client
  • C_QLTYLVLBYSVRTY.MANUFACTURER == LFA1.LIFNR
  • C_QLTYLVLBYSVRTY.MANDT == LFA1.MANDT
Manufacturer Material
  • Manufacturer Material
  • Client
  • C_QLTYLVLBYSVRTY.MANUFACTURERPARTNMBR == MARA.MATNR
  • C_QLTYLVLBYSVRTY.MANDT == MARA.MANDT
Material Number
  • Material Number
  • Client
  • C_QLTYLVLBYSVRTY.MATERIAL == MARA.MATNR
  • C_QLTYLVLBYSVRTY.MANDT == MARA.MANDT
Material Authorization Group for Activities in QM
  • Material Authorization Group for Activities in QM
  • Client
  • C_QLTYLVLBYSVRTY.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
  • C_QLTYLVLBYSVRTY.MANDT == TQ01B.MANDT
Plant
  • Client
  • Plant
  • C_QLTYLVLBYSVRTY.MANDT == T001W.MANDT
  • C_QLTYLVLBYSVRTY.PLANT == T001W.WERKS
Purchasing Organization
  • Purchasing Organization
  • Client
  • C_QLTYLVLBYSVRTY.PURCHASINGORGANIZATION == T024E.EKORG
  • C_QLTYLVLBYSVRTY.MANDT == T024E.MANDT
Inspection Stage for Next Inspection
  • Inspection Stage for Next Inspection
  • Dynamic Modification Rule
  • Client
  • C_QLTYLVLBYSVRTY.QLTYLEVELNEXTDYNRULESTAGE == QDPS.PRSTUFE
  • C_QLTYLVLBYSVRTY.INSPLOTDYNAMICRULE == QDPS.DYNREGEL
  • C_QLTYLVLBYSVRTY.MANDT == QDPS.MANDT
Sales Organization
  • Client
  • Sales Organization
  • C_QLTYLVLBYSVRTY.MANDT == TVKO.MANDT
  • C_QLTYLVLBYSVRTY.SALESORGANIZATION == TVKO.VKORG
Sampling Procedure
  • Sampling Procedure
  • Client
  • C_QLTYLVLBYSVRTY.SAMPLINGPROCEDURE == QDSV.STICHPRVER
  • C_QLTYLVLBYSVRTY.MANDT == QDSV.MANDT
Customer (Sold-To Party)
  • Customer (Sold-To Party)
  • Client
  • C_QLTYLVLBYSVRTY.SOLDTOPARTY == KNA1.KUNNR
  • C_QLTYLVLBYSVRTY.MANDT == KNA1.MANDT
Supplier Account Number
  • Supplier Account Number
  • Client
  • C_QLTYLVLBYSVRTY.SUPPLIER == LFA1.LIFNR
  • C_QLTYLVLBYSVRTY.MANDT == LFA1.MANDT