I_InspectionSubsetTP_2

Inspection Subset 2 | view: IINSPSUBSETTP2 | TRAN | Extraction: Not supported | Component: Quality Inspection
Tables used: QALS, AFVC, QAOP, QAPP, CRHD
Column Name Description
InspectionLot FK Inspection Lot Number
InspPlanOperationInternalID Current Node Number from Order Counter
InspectionSubsetInternalID FK Sample Number (Based on an Inspection Point)
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
InspSubsetUsageDcsnValuation Code Valuation Show values
InspSbstEquipProperty Field Active Show values
InspSbstFuncnlLocProperty Field Active Show values
InspSbstMatlSmplProperty Field Active 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
InspectionSubsetType Inspection Point Type Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
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
InspectionSubsetSortKey Key Field (Sort Field) for Inspection Point QPPSORT
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
WorkCenter Work Center ARBPL
Master Data Relations Join Conditions
Equipment Number
  • Equipment Number
  • Client
  • I_INSPECTIONSUBSETTP_2.EQUIPMENT == EQUI.EQUNR
  • I_INSPECTIONSUBSETTP_2.MANDT == EQUI.MANDT
Functional Location
  • Client
  • Functional Location
  • I_INSPECTIONSUBSETTP_2.MANDT == IFLOT.MANDT
  • I_INSPECTIONSUBSETTP_2.FUNCTIONALLOCATION == IFLOT.TPLNR
Inspection Type
  • Client
  • Inspection Type
  • I_INSPECTIONSUBSETTP_2.MANDT == TQ30.MANDT
  • I_INSPECTIONSUBSETTP_2.INSPECTIONLOTTYPE == TQ30.ART
Unit of measure
  • Client
  • Unit of Measure for the Inspection Point
  • I_INSPECTIONSUBSETTP_2.MANDT == T006.MANDT
  • I_INSPECTIONSUBSETTP_2.INSPECTIONSUBSETQTYUNIT == T006.MSEHI
Usage Decision Code
  • ?
  • Usage Decision Code
  • Client
  • Code Group of the Usage Decision
  • ?
  • I_INSPECTIONSUBSETTP_2.[column in domain "QVERSNR"] == QPCD.VERSION
  • I_INSPECTIONSUBSETTP_2.INSPSUBSETUSAGEDCSNCODE == QPCD.CODE
  • I_INSPECTIONSUBSETTP_2.MANDT == QPCD.MANDT
  • I_INSPECTIONSUBSETTP_2.INSPSUBSETUSAGEDCSNCODEGROUP == QPCD.CODEGRUPPE
  • I_INSPECTIONSUBSETTP_2.[column in domain "QKATART"] == QPCD.KATALOGART
Code Group of the Usage Decision
  • Client
  • Code Group of the Usage Decision
  • ?
  • I_INSPECTIONSUBSETTP_2.MANDT == QPGR.MANDT
  • I_INSPECTIONSUBSETTP_2.INSPSUBSETUSAGEDCSNCODEGROUP == QPGR.CODEGRUPPE
  • I_INSPECTIONSUBSETTP_2.[column in domain "QKATART"] == QPGR.KATALOGART
Material Authorization Group for Activities in QM
  • Material Authorization Group for Activities in QM
  • Client
  • I_INSPECTIONSUBSETTP_2.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
  • I_INSPECTIONSUBSETTP_2.MANDT == TQ01B.MANDT
Plant
  • Plant
  • Client
  • I_INSPECTIONSUBSETTP_2.PLANT == T001W.WERKS
  • I_INSPECTIONSUBSETTP_2.MANDT == T001W.MANDT
Selected Set of the Usage Decision
  • Selected Set of the Usage Decision
  • Client
  • ?
  • Plant
  • I_INSPECTIONSUBSETTP_2.SELECTEDCODESET == QPAM.AUSWAHLMGE
  • I_INSPECTIONSUBSETTP_2.MANDT == QPAM.MANDT
  • I_INSPECTIONSUBSETTP_2.[column in domain "QKATART"] == QPAM.KATALOGART
  • I_INSPECTIONSUBSETTP_2.SELECTEDCODESETPLANT == QPAM.WERKS
Plant
  • Client
  • Plant
  • I_INSPECTIONSUBSETTP_2.MANDT == T001W.MANDT
  • I_INSPECTIONSUBSETTP_2.SELECTEDCODESETPLANT == T001W.WERKS