C_QltyLvlByChar

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