C_QltyLvlByInspLot

Quality Level for Inspection Lot | view: CQLTYLVLINSPLOT | Extraction: Not supported | Component: Active Quality Control Worklist

Tables used: QALS, QDQL, QDPS

🔑 Keys (8)
💰 Amounts
∑ Quantities
📅 Dates
☰ Categorical (1)
Other (6)
🔗 Relations (18)

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

Column Name	Description
InspectionLotHasQuantity	Checkbox	Show values

Column Name	Description	Domain name
QualityLevelLastOpenInspLot	Number of Last Inspection Lot Without Usage Decision	NUMC12
IsInspectionLotSkippedText	Short Text for Fixed Values	DDTEXT
InspectionLotIsSkipped	Checkbox
SkipStatusCount	Inspection Lots Skipped
QualityLevelCount	Quality Levels
InspectionLot	Number of Last Inspection Lot with Usage Decision	NUMC12

Master Data Relations	Join Conditions
Storage Location for Batch Client Material Number ? Storage Location for Batch ?	`C_QLTYLVLBYINSPLOT.MANDT == MCHB.MANDT` `C_QLTYLVLBYINSPLOT.MATERIAL == MCHB.MATNR` `C_QLTYLVLBYINSPLOT.[column in domain "CHARG_D"] == MCHB.CHARG` `C_QLTYLVLBYINSPLOT.BATCHSTORAGELOCATION == MCHB.LGORT` `C_QLTYLVLBYINSPLOT.[column in domain "WERKS_D"] == MCHB.WERKS`
Key for Task List Group Client Group Counter ? Task List Type Key for Task List Group	`C_QLTYLVLBYINSPLOT.MANDT == PLKO.MANDT` `C_QLTYLVLBYINSPLOT.BILLOFOPERATIONSVARIANT == PLKO.PLNAL` `C_QLTYLVLBYINSPLOT.[column in domain "CIM_COUNT"] == PLKO.ZAEHL` `C_QLTYLVLBYINSPLOT.BILLOFOPERATIONSTYPE == PLKO.PLNTY` `C_QLTYLVLBYINSPLOT.BILLOFOPERATIONSGROUP == PLKO.PLNNR`
Task List Type Client Task List Type	`C_QLTYLVLBYINSPLOT.MANDT == TCA01.MANDT` `C_QLTYLVLBYINSPLOT.BILLOFOPERATIONSTYPE == TCA01.PLNTY`
Customer Account Number Customer Account Number Client	`C_QLTYLVLBYINSPLOT.CUSTOMER == KNA1.KUNNR` `C_QLTYLVLBYINSPLOT.MANDT == KNA1.MANDT`
Level at Which Dynamic Modification Parameters Are Defined	`C_QLTYLVLBYINSPLOT.INSPECTIONLOTDYNAMICLEVEL == TQ39A.DYNLEVEL`
Inspection Lot Origin	`C_QLTYLVLBYINSPLOT.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Inspection Type Client Inspection Type	`C_QLTYLVLBYINSPLOT.MANDT == TQ30.MANDT` `C_QLTYLVLBYINSPLOT.INSPECTIONLOTTYPE == TQ30.ART`
Dynamic Modification Rule Dynamic Modification Rule Client	`C_QLTYLVLBYINSPLOT.INSPLOTDYNAMICRULE == QDDR.DYNREGEL` `C_QLTYLVLBYINSPLOT.MANDT == QDDR.MANDT`
Manufacturer Account Number Manufacturer Account Number Client	`C_QLTYLVLBYINSPLOT.MANUFACTURER == LFA1.LIFNR` `C_QLTYLVLBYINSPLOT.MANDT == LFA1.MANDT`
Manufacturer Material Client Manufacturer Material	`C_QLTYLVLBYINSPLOT.MANDT == MARA.MANDT` `C_QLTYLVLBYINSPLOT.MANUFACTURERPARTNMBR == MARA.MATNR`
Material Number Client Material Number	`C_QLTYLVLBYINSPLOT.MANDT == MARA.MANDT` `C_QLTYLVLBYINSPLOT.MATERIAL == MARA.MATNR`
Material Authorization Group for Activities in QM Client Material Authorization Group for Activities in QM	`C_QLTYLVLBYINSPLOT.MANDT == TQ01B.MANDT` `C_QLTYLVLBYINSPLOT.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH`
Plant Client Plant	`C_QLTYLVLBYINSPLOT.MANDT == T001W.MANDT` `C_QLTYLVLBYINSPLOT.PLANT == T001W.WERKS`
Purchasing Organization Client Purchasing Organization	`C_QLTYLVLBYINSPLOT.MANDT == T024E.MANDT` `C_QLTYLVLBYINSPLOT.PURCHASINGORGANIZATION == T024E.EKORG`
Inspection Stage for Next Inspection Dynamic Modification Rule Client Inspection Stage for Next Inspection	`C_QLTYLVLBYINSPLOT.INSPLOTDYNAMICRULE == QDPS.DYNREGEL` `C_QLTYLVLBYINSPLOT.MANDT == QDPS.MANDT` `C_QLTYLVLBYINSPLOT.QLTYLEVELNEXTDYNRULESTAGE == QDPS.PRSTUFE`
Sales Organization Client Sales Organization	`C_QLTYLVLBYINSPLOT.MANDT == TVKO.MANDT` `C_QLTYLVLBYINSPLOT.SALESORGANIZATION == TVKO.VKORG`
Customer (Sold-To Party) Client Customer (Sold-To Party)	`C_QLTYLVLBYINSPLOT.MANDT == KNA1.MANDT` `C_QLTYLVLBYINSPLOT.SOLDTOPARTY == KNA1.KUNNR`
Supplier Account Number Client Supplier Account Number	`C_QLTYLVLBYINSPLOT.MANDT == LFA1.MANDT` `C_QLTYLVLBYINSPLOT.SUPPLIER == LFA1.LIFNR`