C_InspLotRsltRec

Insp. Points Rslt. Rec.: Inspection Lots | view: CINSPLOTRR | Extraction: Not supported | Component: Inspection Lot Worklist
Tables used: QALS, AFVC, QAOP, QAVE, JSTO, JEST, TQ79, MARA, MAKT, CRHD
Column Name Description
InspectionLot Inspection Lot Number
InspectionOperations null
Column Name Description
Column Name Description
📏 Base Unit of Measure for Inspection Lot Quantity (InspectionLotQuantityUnit):
InspectionLotQuantity Inspection Lot Quantity
Column Name Description
InspectionLotStartDate Start Date of Inspection in Local Time Zone
InspectionLotEndDate End Date of Inspection in Local Time Zone
InspLotCreatedOnLocalDate Date in Time Zone Where Lot Created
InspLotCreatedOnLocalTime Time in Time Zone Where Lot Created
InspectionLotCreatedOn System Date on Which Data Record Was Created
InspectionLotCreatedOnTime System Time of Creation
InspectionLotChangeDate System Date on Which Data Record Was Changed
InspectionLotChangeTime System Time of Change
Column Name Description
InspLotIsSerialNmbrPossible Serial Numbers Possible Show values
InspSbstIsTimeRelated Interval = Time (Time-Related) Show values
InspSbstHasNoTimeOrQuantity Interval Without Reference to Time or Quantity Show values
InspSbstDateFldProperty Field Active Show values
InspSbstTimeFldProperty Field Active Show values
InspectionLotHasUsageDecision Usage Decision Made Show values
InspectionSubsetType Inspection Point Type Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
InspLotHasSubsets Inspection with Inspection Points Show values
Column Name Description Domain name
InspPlanOperationInternalID Current Node Number from Order Counter KNTNR
InspWorkCenters null
OrderInternalBillOfOperations Routing number of operations in the order AUFPL
InspectionLotText Inspection Lot Text
InspectionOperation Operation/Activity Number
OperationText Operation Short Text
WorkCenter Work Center
MaterialName Material Description
MaterialIsBatchManaged Batch Required
InspectionLotObjectText Short Text for Inspection Object
InspLotRsltRecgStatus null
InspLotNmbrAddlRecordedCharc Number of Characteristics Recorded Additionally
InspLotNmbrOpenShortTermCharc Number of Outstanding Short-Term Chars That Require Confirm.
InspLotNmbrOpenLongTermCharc Open Long-Term Characteristics
InspLotDigitalSgntrInUsgeDcsn Digital Signature Usage Decision
InspLotDigitalSgntrResultsRecg Digital Signature for Insp. Lot in Results Recording
InspectionLotCreatedBy Name of User Who Created the Data Record
InspectionLotChangedBy Name of User Who Last Changed Data Record
ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Batch Number
  • Client
  • Material Number
  • Material Number
  • Batch Number
  • C_INSPLOTRSLTREC.MANDT == MCH1.MANDT
  • C_INSPLOTRSLTREC.MATERIAL == MCH1.MATNR
  • C_INSPLOTRSLTREC.MATERIALDESCRIPTION == MCH1.MATNR
  • C_INSPLOTRSLTREC.BATCH == MCH1.CHARG
Bill of Operations Type
  • Client
  • Bill of Operations Type
  • C_INSPLOTRSLTREC.MANDT == TCA01.MANDT
  • C_INSPLOTRSLTREC.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Inspection Lot Origin C_INSPLOTRSLTREC.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Base Unit of Measure for Inspection Lot Quantity
  • Client
  • Base Unit of Measure for Inspection Lot Quantity
  • C_INSPLOTRSLTREC.MANDT == T006.MANDT
  • C_INSPLOTRSLTREC.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI
Inspection Type
  • Client
  • Inspection Type
  • C_INSPLOTRSLTREC.MANDT == TQ30.MANDT
  • C_INSPLOTRSLTREC.INSPECTIONLOTTYPE == TQ30.ART
Inspection Point Identification
  • Client
  • Identifier for Inspection Point Field Combination
  • C_INSPLOTRSLTREC.MANDT == TQ79.MANDT
  • C_INSPLOTRSLTREC.INSPSUBSETFIELDCOMBINATION == TQ79.SLWBEZ
Order Number (Production Order)
  • Order Number (Production Order)
  • Client
  • C_INSPLOTRSLTREC.MANUFACTURINGORDER == AUFK.AUFNR
  • C_INSPLOTRSLTREC.MANDT == AUFK.MANDT
Material Number
  • Client
  • Material Number
  • Material Number
  • C_INSPLOTRSLTREC.MANDT == MARA.MANDT
  • C_INSPLOTRSLTREC.MATERIAL == MARA.MATNR
  • C_INSPLOTRSLTREC.MATERIALDESCRIPTION == MARA.MATNR
Material Number
  • Client
  • Material Number
  • Material Number
  • C_INSPLOTRSLTREC.MANDT == MARA.MANDT
  • C_INSPLOTRSLTREC.MATERIAL == MARA.MATNR
  • C_INSPLOTRSLTREC.MATERIALDESCRIPTION == MARA.MATNR
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • C_INSPLOTRSLTREC.MANDT == TQ01B.MANDT
  • C_INSPLOTRSLTREC.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Client
  • Plant
  • C_INSPLOTRSLTREC.MANDT == T001W.MANDT
  • C_INSPLOTRSLTREC.PLANT == T001W.WERKS
Production Version
  • Client
  • Material Number
  • Material Number
  • Plant
  • Production Version
  • C_INSPLOTRSLTREC.MANDT == MKAL.MANDT
  • C_INSPLOTRSLTREC.MATERIAL == MKAL.MATNR
  • C_INSPLOTRSLTREC.MATERIALDESCRIPTION == MKAL.MATNR
  • C_INSPLOTRSLTREC.PLANT == MKAL.WERKS
  • C_INSPLOTRSLTREC.PRODUCTIONVERSION == MKAL.VERID
Selected Set for Inspection Point Valuation
  • ?
  • Client
  • Selected Set for Inspection Point Valuation
  • Plant of Selected Set for Inspection Point Valuation
  • C_INSPLOTRSLTREC.[column in domain "QKATART"] == QPAM.KATALOGART
  • C_INSPLOTRSLTREC.MANDT == QPAM.MANDT
  • C_INSPLOTRSLTREC.SELECTEDCODESET == QPAM.AUSWAHLMGE
  • C_INSPLOTRSLTREC.SELECTEDCODESETPLANT == QPAM.WERKS
Plant of Selected Set for Inspection Point Valuation
  • Client
  • Plant of Selected Set for Inspection Point Valuation
  • C_INSPLOTRSLTREC.MANDT == T001W.MANDT
  • C_INSPLOTRSLTREC.SELECTEDCODESETPLANT == T001W.WERKS
Serial Number Profile
  • Client
  • Serial Number Profile
  • C_INSPLOTRSLTREC.MANDT == T377P.MANDT
  • C_INSPLOTRSLTREC.SERIALNUMBERPROFILE == T377P.SERAIL
Object ID of the resource
  • Client
  • Object ID of the resource
  • ?
  • C_INSPLOTRSLTREC.MANDT == CRID.MANDT
  • C_INSPLOTRSLTREC.WORKCENTERINTERNALID == CRID.OBJID
  • C_INSPLOTRSLTREC.[column in domain "CR_OBJTY"] == CRID.OBJTY