I_InspectionSubset

Inspection Point of Inspection Operation | view: IINSPSUBSET | TRAN | Extraction: Not supported | Component: Quality Inspection
Tables used: QAPP
Column Name Description
InspectionLot FK Inspection Lot Number
InspectionSubsetInternalID FK Sample Number (Based on an Inspection Point)
InspPlanOperationInternalID Current Node Number from Order Counter
Column Name Description
Column Name Description
📏 Unit of Measure for the Inspection Point (InspectionSubsetQtyUnit):
InspectionSubsetYieldQty Inspection Point Yield
InspectionSubsetScrapQty Scrap for Inspection Point
InspectionSubsetReworkQty Rework Quantity for Inspection Point
Column Name Description
InspectionSubsetTime User Field for Time
InspectionSubsetDate User Field for Date
CreationDate System Date on Which Data Record Was Created
CreationTime System Time at Which Data Record Was Created
LastChangeDate System Date on Which Data Record Was Changed
LastChangeTime System Time at Which Data Record Was Changed
Column Name Description
InspSbstMatlSmplProperty Field Active Show values
InspSbstEquipProperty Field Active Show values
InspSbstFuncnlLocProperty Field Active Show values
InspSubsetUsageDcsnValuation Code Valuation Show values
InspSbstTimeFldProperty Field Active Show values
InspSbstDateFldProperty Field Active Show values
InspSbstLongNmbrFldProperty Field Active Show values
InspSbstShrtNmbrFldProperty Field Active Show values
InspSbstLongTxtFldProperty Field Active Show values
InspSbstShrtTxtFldProperty Field Active Show values
Column Name Description Domain name
InspectionSubsetSortKey Key Field (Sort Field) for Inspection Point QPPSORT
ShopFloorItem ID of Serialized Material
InspSubsetLongNumericKey User Field for 10 Digits QUSRNUMC10
InspSubsetShortNumericKey User Field for 3 Digits QUSRNUMC3
InspectionSubsetLongCharKey User Field for 18 Characters QUSRCHAR18
InspectionSubsetShortCharKey User Field for 10 Characters QUSRCHAR10
Inspector Name of Inspector QPRUEFER
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Equipment Number
  • Client
  • Equipment Number
  • I_INSPECTIONSUBSET.MANDT == EQUI.MANDT
  • I_INSPECTIONSUBSET.EQUIPMENT == EQUI.EQUNR
Functional Location
  • Client
  • Functional Location
  • I_INSPECTIONSUBSET.MANDT == IFLOT.MANDT
  • I_INSPECTIONSUBSET.FUNCTIONALLOCATION == IFLOT.TPLNR
Unit of measure
  • Client
  • Unit of Measure for the Inspection Point
  • I_INSPECTIONSUBSET.MANDT == T006.MANDT
  • I_INSPECTIONSUBSET.INSPECTIONSUBSETQTYUNIT == T006.MSEHI
Usage Decision Code
  • ?
  • Client
  • Usage Decision Code
  • ?
  • Code Group of the Usage Decision
  • I_INSPECTIONSUBSET.[column in domain "QVERSNR"] == QPCD.VERSION
  • I_INSPECTIONSUBSET.MANDT == QPCD.MANDT
  • I_INSPECTIONSUBSET.INSPSUBSETUSAGEDCSNCODE == QPCD.CODE
  • I_INSPECTIONSUBSET.[column in domain "QKATART"] == QPCD.KATALOGART
  • I_INSPECTIONSUBSET.INSPSUBSETUSAGEDCSNCODEGROUP == QPCD.CODEGRUPPE
Code Group of the Usage Decision
  • Client
  • ?
  • Code Group of the Usage Decision
  • I_INSPECTIONSUBSET.MANDT == QPGR.MANDT
  • I_INSPECTIONSUBSET.[column in domain "QKATART"] == QPGR.KATALOGART
  • I_INSPECTIONSUBSET.INSPSUBSETUSAGEDCSNCODEGROUP == QPGR.CODEGRUPPE
Selected Set of the Usage Decision
  • Plant
  • Client
  • ?
  • Selected Set of the Usage Decision
  • I_INSPECTIONSUBSET.SELECTEDCODESETPLANT == QPAM.WERKS
  • I_INSPECTIONSUBSET.MANDT == QPAM.MANDT
  • I_INSPECTIONSUBSET.[column in domain "QKATART"] == QPAM.KATALOGART
  • I_INSPECTIONSUBSET.SELECTEDCODESET == QPAM.AUSWAHLMGE
Plant
  • Plant
  • Client
  • I_INSPECTIONSUBSET.SELECTEDCODESETPLANT == T001W.WERKS
  • I_INSPECTIONSUBSET.MANDT == T001W.MANDT