C_InspUsgDescMng

Manage Usage Decision List | view: CINSPUSGDESCMNG | Extraction: Not supported | Component: Inspection Lot Worklist

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

🔑 Keys (1)
💰 Amounts
∑ Quantities (19)
📅 Dates (14)
☰ Categorical (25)
Other (59)
🔗 Relations (41)

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
InspLotStkQtyPosted	Total Quantity
InspLotStkQtyToBePosted	Remaining Inspection Lot Quantity
InspLotQtyToBePosted	Quantity to Be Posted
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
InspectionLotActualQuantity	Actual Lot Quantity
InspectionLotDefectiveQuantity	Defective Quantity
📏 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
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
InspLotUsgeDcsnChangedTime	Time When Usage Decision Was Changed
InspLotUsageDecisionTime	Time When Usage Decision Was Made
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

Column Name	Description
InspectionLotHasUsageDecision	Usage Decision Made	Show values
InspLotRsltRecgStatus	Results Recording Status for an Inspection Lot	Show values
InspLotCompltnStatus	Inspection Lot Status	Show values
InspLotIsAutomUsgeDcsnPossible	Automatic Usage Decision Planned	Show values
InspLotIsDocumentationRequired	Documentation Required	Show values
InspectionLotApproval	Inspection Lot Approval	Show values
InspLotDigitalSgntrInUsgeDcsn	Digital Signature Usage Decision	Show values
MaterialIsBatchManaged	Batch Required	Show values
InspectionLotHasQuantity	Posted to Inspection Stock	Show values
InspLotIsStockPostingCompleted	Stock Postings Completed	Show values
InspLotHasDeviations	Inspection Lot Has Deviations	Show values
SmplDrwgProcedIsConfRequired	Confirmation Required for Sample Drawing	Show values
InspCharcHasRejection	Rejected Characteristics	Show values
InspLotUsgeDcsnIsOverdue	Overdue	Show values
InspectionLotIsSkipped	Skip Lot	Show values
InspLotIsTaskListRequired	Inspection Plan Required	Show values
InspLotStatusCanceled	Inspection Lot Canceled	Show values
InspectionLotStatusReleased	Inspection Lot Released	Show values
InspLotHasSubsets	Checkbox	Show values
InspectionSubsetType	Inspection Point Type	Show values
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values
InspLotUsageDecisionValuation	Code Valuation	Show values
InspLotHasSrlNmbr	Has Serial Numbers	Show values
InspLotIsSerialNmbrPossible	Serial Numbers Possible	Show values
InspUsgeDcsnDgtlSgntrType	Signature Type: Inspection Lot Usage Decision	Show values

Column Name	Description	Domain name
InspectionLotText	Inspection Lot Text	QKURZTEXT
InspectionLotTypeText	Inspection Type Text	QKURZTEXT
PlantName	Plant Name	TEXT30
MaterialName	Material Description	TEXT40
InspCharacteristicCount	Number of Characteristics	VDM_QM_COUNTER
InspCharCount	Rejected / Total Characteristics	VDM_QM_TEXT43
UsageDecisionCodeText	Text for Code	QKURZTEXT
UsageDecisionCodeCriticality	null
NumberOfDefects	Defects	VDM_QM_COUNTER
NumberOfDefectsCriticality	null
InspectionLotOriginText	Inspection Lot Origin Text	QKURZTEXT
WBSDescription	WBS Element Name	TEXT40
InventorySpclStkSalesDocument	Inventory Special Stock Sales Document	VBELN
InspectionLotApprovalText	Inspection Lot Approval Text	DDTEXT
InspLotDgtlSgntrInUsgeDcsnTxt	Signature for Inspection Lot When Usage Decision Made Text	DDTEXT
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
InspectionLotQualityScore	Quality Score	QKENNZAHL
UsageDecisionCodeGroupText	Text for Code Group	QKURZTEXT
InspectionLotUsageDecidedBy	Usage Decision Made By	QAENDERER
InspLotUsageDecisionChangedBy	Usage Decision Changed By	QAENDERER
ConcatenatedActiveSystStsName	System Statuses	VDM_QM_TEXT224
InspLotUsageDecisionLongText	Inspection Lot Usage Decision Long Text	VDM_QM_TEXT1333
InspCharRejectedCount	No. of Rejected Characteristics	VDM_QM_COUNTER
InspCharRejectedCriticality	null
InspCharOpenCount	No. of Open Characteristics	VDM_QM_COUNTER
InspLotNmbrOpenLongTermCharc	Open Long-Term Characteristics	INT2
InspCharcsCompletedInPercent	null
BillOfOperationsGroup	Bill of Operations Group	PLNNR
MaterialRevisionLevel	Revision Level	REVLV
MaterialDocumentItem	Material Document Item	MBLPO
SalesOrderItem	Sales Order Item	NUM06
DeliveryDocumentItem	Delivery Document Item	POSNR
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
InspCharIsVisible	null
InspCharSubsetIsVisible	null
InspSubsetIsVisible	null
InspStockPostingIsVisible	null
InspLotIsCompletionForced	null
IsCloudSystem	null
IsAttachmentsEnabled	null
InspUsgeDcsnDgtlSgntrStrgy	Signature Strategy with Individual Signature: Usage Decision	SIGNSTRAT
ApplicationObjectSignKey	DS Enhancement: Draft Signature ID	DS_ENH_D_DRAFT_SIGN_ID

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