C_Insplotmng

Manage Inspection Lots | view: CINSPLOTMNG | Extraction: Not supported | Component: Inspection Lot Worklist

Tables used: QAMV, QALS, AFVC, QAOP, QAMR, QAPP, QAVE, QAVE, QASV, QASR, QMEL, QMFE, JSTO, JEST, PRTE, KNA1, TQ31, TQ31T, TQ30, TQ30T, MARA, MAKT, T001W, PROJ, T024E, TVKO, TVKOT, LFA1, QPCD, QPGR, QPGT, QPCT, PRPS, CRHD

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

Column Name	Description
InspectionLot	Inspection Lot Number

Column Name	Description

Column Name	Description
📏 Base Unit of Measure for Inspection Lot Quantity (InspectionLotQuantityUnit):
InspectionLotQuantity	Inspection Lot Quantity
InspLotQtyToFree	Unrestricted-Use Stock
InspLotQtyToScrap	Scrap Quantity
InspLotQtyToSample	Quantity Posted to Sample
InspLotQtyToBlocked	Blocked Stock
InspLotQtyToReserves	Quantity Posted to Reserves
InspLotQtyToAnotherMaterial	New Material
InspLotQtyReturnedToSupplier	Return to Supplier
InspLotQtyToSpecialStock	Other Quantity
InspLotQtyToOtherStock	Other Quantity 2
InspLotQtyToBePosted	Quantity to Be Posted
InspectionLotActualQuantity	Actual Lot Quantity
InspectionLotDefectiveQuantity	Defective Quantity
📏 Lot Container (InspectionLotContainerUnit):
InspectionLotContainer	QM - No. of Containers
📏 Sample Unit of Measure (InspectionLotSampleUnit):
InspectionLotSampleQuantity	Inspection Sample Size
InspLotSmplQtyForLongTermChar	Long-Term Sample Quantity
InspLotQtyInspected	Inspected Quantity
InspLotQtyDestroyed	Destroyed Quantity

Column Name	Description
InspectionLotEndDate	End Date of Inspection in Local Time Zone
InspectionLotStartDate	Start Date of Inspection in Local Time Zone
InspLotCreatedOnLocalDate	Date in Time Zone Where Lot Created
InspectionLotCreatedOn	System Date on Which Data Record Was Created
InspectionLotChangeDate	System Date on Which Data Record Was Changed
InspectionLotUsageDecidedOn	Date When Usage Decision Was Made
InspLotUsageDecisionChangedOn	Date When Usage Decision Was Changed
InspLotCreatedOnLocalTime	Time in Time Zone Where Lot Created
InspectionLotCreatedOnTime	System Time of Creation
InspectionLotChangeTime	System Time of Change
InspectionLotStartTime	Inspection Started At
InspectionLotEndTime	Inspection Ended At
MatlDocLatestPostgDate	Posting Date in the Document
InspLotUsgeDcsnChangedTime	Time When Usage Decision Was Changed
InspLotUsageDecisionTime	Time When Usage Decision Was Made

Column Name	Description
InspectionLotApproval	Inspection Lot Approval	Show values
InspLotDigitalSgntrInUsgeDcsn	Digital Signature Usage Decision	Show values
InspLotUsageDecisionValuation	Code Valuation	Show values
InspLotRsltRecgStatus	Results Recording Status for an Inspection Lot	Show values
InspLotCompltnStatus	Inspection Lot Status	Show values
InspLotHasSubsets	Inspection with Inspection Points	Show values
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values
InspLotIsSerialNmbrPossible	Serial Numbers Possible	Show values

Column Name	Description	Domain name
InspectionLotOriginText	Inspection Lot Origin Text	QKURZTEXT
InspectionLotApprovalText	Inspection Lot Approval Text	DDTEXT
InspectionLotText	Inspection Lot Text	QKURZTEXT
InspCharcsCompletedInPercent	null
InspCharCount	Rejected / Total Characteristics	VDM_QM_TEXT43
InspCharacteristicCount	Number of Characteristics	VDM_QM_COUNTER
NumberOfDefectsCriticality	null
NumberOfDefects	Defects	VDM_QM_COUNTER
WBSDescription	WBS Element Name	TEXT40
InventorySpclStkSalesDocument	Inventory Special Stock Sales Document	VBELN
InspLotIsAutomUsgeDcsnPossible	Automatic Usage Decision Planned
InspLotIsDocumentationRequired	Documentation Required
InspLotDgtlSgntrInUsgeDcsnTxt	Signature for Inspection Lot When Usage Decision Made Text	DDTEXT
InspLotIsBatchRequired	Batch Required
InspectionLotHasUsageDecision	Usage Decision Made
InspectionLotHasQuantity	Posted to Inspection Stock
InspLotIsStockPostingCompleted	Stock Postings Completed
MaterialDocumentYear	Material Document Year	GJAHR
MaterialDocument	Number of Material Document	BELNR
InspectionLotCreatedBy	Name of User Who Created the Data Record	QAENDERER
InspectionLotChangedBy	Name of User Who Last Changed Data Record	QAENDERER
BatchBySupplier	Supplier Batch Number	LICHN
InspectionLotObjectText	Short Text for Inspection Object	QKURZTEXT
SupplierName	Name of Supplier	TEXT80
ManufacturerName	Name of Supplier	TEXT80
ManufacturerPartNmbrText	Material Description	TEXT40
PurchasingOrganizationName	Purchasing Organization Name	TEXT20
CustomerName	Name of Customer	TEXT80
SalesOrder	Sales Order Number	VBELN
DeliveryDocument	Delivery Document	VBELN
SoldToPartyName	Name of Customer	TEXT80
SalesOrganizationName	Sales Organization Description	TEXT20
MaterialByCustomer	Customer Material	IDNEX
SmplDrwgProcedIsConfRequired	Confirmation Required for Sample Drawing
UsageDecisionCodeCriticality	null
InspLotUsgeDcsnValuationText	Usage Decision Valuation Text	DDTEXT
InspectionLotQualityScore	Quality Score	QKENNZAHL
UsageDecisionCodeGroupText	Text for Code Group	QKURZTEXT
UsageDecisionCodeText	Text for Code	QKURZTEXT
InspectionLotUsageDecidedBy	Usage Decision Made By	QAENDERER
InspLotUsageDecisionChangedBy	Usage Decision Changed By	QAENDERER
MaterialName	Material Description	TEXT40
InspectionLotTypeText	Inspection Type Text	QKURZTEXT
PlantName	Plant Name	TEXT30
InspCharcHasRejection	Rejected Characteristics
InspLotUsgeDcsnIsOverdue	Overdue
InspectionLotIsSkipped	Skip Lot
InspLotIsTaskListRequired	Inspection Plan Required
BillOfOperationsGroup	Inspection Plan Assigned
MaterialRevisionLevel	Revision Level	REVLV
MaterialDocumentItem	Material Document Item	MBLPO
SalesOrderItem	Sales Order Item	NUM06
DeliveryDocumentItem	Delivery Document Item	POSNR
InspLotNmbrOpenLongTermCharc	Open Long-Term Characteristics	INT2
InspectionLotScrapRatio	Share of Scrap in Inspection Lot	QFLTP16
InspLotExternalNumber	Inspection Document Number	QPLEXT_INSP_DOC_NUMBER
InspLotNmbrOpenShortTermCharc	Number of Outstanding Short-Term Chars That Require Confirm.	INT2

Master Data Relations	Join Conditions
Document Type Document Type Client	`C_INSPLOTMNG.ACCOUNTINGDOCUMENTTYPE == T003.BLART` `C_INSPLOTMNG.MANDT == T003.MANDT`
Batch Number Batch Number Material Number Client	`C_INSPLOTMNG.BATCH == MCH1.CHARG` `C_INSPLOTMNG.MATERIAL == MCH1.MATNR` `C_INSPLOTMNG.MANDT == MCH1.MANDT`
Storage Location for Batch Batch Number Material Number Plant Storage Location for Batch Client	`C_INSPLOTMNG.BATCH == MCHB.CHARG` `C_INSPLOTMNG.MATERIAL == MCHB.MATNR` `C_INSPLOTMNG.PLANT == MCHB.WERKS` `C_INSPLOTMNG.BATCHSTORAGELOCATION == MCHB.LGORT` `C_INSPLOTMNG.MANDT == MCHB.MANDT`
Destination Country/Region Destination Country/Region Client	`C_INSPLOTMNG.BILLTOPARTYCOUNTRY == T005.LAND1` `C_INSPLOTMNG.MANDT == T005.MANDT`
Cost Center Cost Center ? ? Client	`C_INSPLOTMNG.COSTCENTER == CSKS.KOSTL` `C_INSPLOTMNG.[column in domain "DATBI"] == CSKS.DATBI` `C_INSPLOTMNG.[column in domain "KOKRS"] == CSKS.KOKRS` `C_INSPLOTMNG.MANDT == CSKS.MANDT`
Customer (Ship-To Party) Customer (Ship-To Party) Client	`C_INSPLOTMNG.CUSTOMER == KNA1.KUNNR` `C_INSPLOTMNG.MANDT == KNA1.MANDT`
Lot Container Lot Container Client	`C_INSPLOTMNG.INSPECTIONLOTCONTAINERUNIT == T006.MSEHI` `C_INSPLOTMNG.MANDT == T006.MANDT`
Inspection Lot Origin	`C_INSPLOTMNG.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Plant for Inspection Lot Plant for Inspection Lot Client	`C_INSPLOTMNG.INSPECTIONLOTPLANT == T001W.WERKS` `C_INSPLOTMNG.MANDT == T001W.MANDT`
Base Unit of Measure for Inspection Lot Quantity Base Unit of Measure for Inspection Lot Quantity Client	`C_INSPLOTMNG.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI` `C_INSPLOTMNG.MANDT == T006.MANDT`
Sample Unit of Measure Sample Unit of Measure Client	`C_INSPLOTMNG.INSPECTIONLOTSAMPLEUNIT == T006.MSEHI` `C_INSPLOTMNG.MANDT == T006.MANDT`
Storage Location for Inspection Lot Stock Storage Location for Inspection Lot Stock Plant for Inspection Lot Client	`C_INSPLOTMNG.INSPECTIONLOTSTORAGELOCATION == T001L.LGORT` `C_INSPLOTMNG.INSPECTIONLOTPLANT == T001L.WERKS` `C_INSPLOTMNG.MANDT == T001L.MANDT`
Inspection Type Inspection Type Client	`C_INSPLOTMNG.INSPECTIONLOTTYPE == TQ30.ART` `C_INSPLOTMNG.MANDT == TQ30.MANDT`
Usage Decision Code Usage Decision Code Group ? ? Client Usage Decision Code	`C_INSPLOTMNG.INSPLOTUSAGEDECISIONCODEGROUP == QPCD.CODEGRUPPE` `C_INSPLOTMNG.[column in domain "QVERSNR"] == QPCD.VERSION` `C_INSPLOTMNG.[column in domain "QKATART"] == QPCD.KATALOGART` `C_INSPLOTMNG.MANDT == QPCD.MANDT` `C_INSPLOTMNG.INSPECTIONLOTUSAGEDECISIONCODE == QPCD.CODE`
Batch Transferred To Batch Transferred To Material Posted To Client	`C_INSPLOTMNG.INSPLOTBATCHTRANSFERREDTO == MCH1.CHARG` `C_INSPLOTMNG.INSPLOTMATERIALPOSTEDTO == MCH1.MATNR` `C_INSPLOTMNG.MANDT == MCH1.MANDT`
Material Posted To Material Posted To Client	`C_INSPLOTMNG.INSPLOTMATERIALPOSTEDTO == MARA.MATNR` `C_INSPLOTMNG.MANDT == MARA.MANDT`
Selection Material Selection Material Client	`C_INSPLOTMNG.INSPLOTSELECTIONMATERIAL == MARA.MATNR` `C_INSPLOTMNG.MANDT == MARA.MANDT`
Usage Decision Code Group Usage Decision Code Group ? Client	`C_INSPLOTMNG.INSPLOTUSAGEDECISIONCODEGROUP == QPGR.CODEGRUPPE` `C_INSPLOTMNG.[column in domain "QKATART"] == QPGR.KATALOGART` `C_INSPLOTMNG.MANDT == QPGR.MANDT`
Follow-Up Action Follow-Up Action Client	`C_INSPLOTMNG.INSPLOTUSGEDCSNFOLLOWUPACTION == TQ07.FOLGEAKTI` `C_INSPLOTMNG.MANDT == TQ07.MANDT`
Selected Set of the Usage Decision ? ? Selected Set of the Usage Decision Client	`C_INSPLOTMNG.[column in domain "QKATART"] == QPAM.KATALOGART` `C_INSPLOTMNG.[column in domain "WERKS_D"] == QPAM.WERKS` `C_INSPLOTMNG.INSPLOTUSGEDCSNSELECTEDSET == QPAM.AUSWAHLMGE` `C_INSPLOTMNG.MANDT == QPAM.MANDT`
Number of Manufacturer Number of Manufacturer Client	`C_INSPLOTMNG.MANUFACTURER == LFA1.LIFNR` `C_INSPLOTMNG.MANDT == LFA1.MANDT`
Manufacturer Material Manufacturer Material Client	`C_INSPLOTMNG.MANUFACTURERPARTNMBR == MARA.MATNR` `C_INSPLOTMNG.MANDT == MARA.MANDT`
Order Number (Production Order) Order Number (Production Order) Client	`C_INSPLOTMNG.MANUFACTURINGORDER == AUFK.AUFNR` `C_INSPLOTMNG.MANDT == AUFK.MANDT`
Material Number Material Number Client	`C_INSPLOTMNG.MATERIAL == MARA.MATNR` `C_INSPLOTMNG.MANDT == MARA.MANDT`
Special Stock Indicator Special Stock Indicator Client	`C_INSPLOTMNG.MATERIALCOMPISSPECIALSTOCK == T148.SOBKZ` `C_INSPLOTMNG.MANDT == T148.MANDT`
Material Authorization Group for Activities in QM Material Authorization Group for Activities in QM Client	`C_INSPLOTMNG.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH` `C_INSPLOTMNG.MANDT == TQ01B.MANDT`
Plant Plant Client	`C_INSPLOTMNG.PLANT == T001W.WERKS` `C_INSPLOTMNG.MANDT == T001W.MANDT`
Production Version Production Version Material Number Plant Client	`C_INSPLOTMNG.PRODUCTIONVERSION == MKAL.VERID` `C_INSPLOTMNG.MATERIAL == MKAL.MATNR` `C_INSPLOTMNG.PLANT == MKAL.WERKS` `C_INSPLOTMNG.MANDT == MKAL.MANDT`
Profit Center ? ? Profit Center Client	`C_INSPLOTMNG.[column in domain "KOKRS"] == CEPC.KOKRS` `C_INSPLOTMNG.[column in domain "DATBI"] == CEPC.DATBI` `C_INSPLOTMNG.PROFITCENTER == CEPC.PRCTR` `C_INSPLOTMNG.MANDT == CEPC.MANDT`
Purchasing Organization Purchasing Organization Client	`C_INSPLOTMNG.PURCHASINGORGANIZATION == T024E.EKORG` `C_INSPLOTMNG.MANDT == T024E.MANDT`
Order Number for Recording Appraisal Costs Order Number for Recording Appraisal Costs Client	`C_INSPLOTMNG.QUALITYCOSTCOLLECTOR == AUFK.AUFNR` `C_INSPLOTMNG.MANDT == AUFK.MANDT`
Production Version Number Run Schedule Header Client	`C_INSPLOTMNG.SALESOPERATIONSPLANNINGORDER == SAFK.AUFNR` `C_INSPLOTMNG.MANDT == SAFK.MANDT`
Sales Organization Sales Organization Client	`C_INSPLOTMNG.SALESORGANIZATION == TVKO.VKORG` `C_INSPLOTMNG.MANDT == TVKO.MANDT`
Serial Number Profile Client Serial Number Profile	`C_INSPLOTMNG.MANDT == T377P.MANDT` `C_INSPLOTMNG.SERIALNUMBERPROFILE == T377P.SERAIL`
Customer (Sold-To Party) Customer (Sold-To Party) Client	`C_INSPLOTMNG.SOLDTOPARTY == KNA1.KUNNR` `C_INSPLOTMNG.MANDT == KNA1.MANDT`
Vendor's account number Vendor's account number Client	`C_INSPLOTMNG.SUPPLIER == LFA1.LIFNR` `C_INSPLOTMNG.MANDT == LFA1.MANDT`