C_InspectionSubset

Manage Inspection Point | view: CINSPSUBSET | Extraction: Not supported | Component: Quality Inspection
Tables used: QALS, AFVC, QAOP, QAPP, TQ79, TQ79T, MARA, MAKT, QPCD, QPCT, USR21, CRHD
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
Column Name Description
InspectionSubsetDate User Field for Date
InspectionSubsetTime User Field for Time
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
InspSbstMatlSmplProperty Field Active Show values
InspSbstEquipProperty Field Active Show values
InspSbstFuncnlLocProperty Field Active Show values
InspSbstLongNmbrFldProperty Field Active Show values
InspSbstShrtNmbrFldProperty Field Active Show values
InspSbstLongTxtFldProperty Field Active Show values
InspSbstShrtTxtFldProperty Field Active Show values
InspSbstDateFldProperty Field Active Show values
InspSbstTimeFldProperty Field Active Show values
InspectionSubsetType Inspection Point Type Show values
Column Name Description Domain name
InspectionSubset Inspection Point
InspectionSubsetSortKey Key Field (Sort Field) for Inspection Point QPPSORT
OperationText Operation Short Text TEXT40
InspectionOperation Operation/Activity Number
InspSubsetFldCombinationTxt Short Text QKURZTEXT
WorkCenter Work Center
UsageDecisionCodeText Text for Code QKURZTEXT
InspSbstUsgeValnCriticality null
MaterialName Material Description TEXT40
InspSubsetMaterialSampleName Keyword for User Field QUSRSLW
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
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
CreatedByUserFullName User Description SUIDTECHDESC
LastChangedByUserFullName User Description SUIDTECHDESC
Master Data Relations Join Conditions
Equipment Number
  • Client
  • Equipment Number
  • C_INSPECTIONSUBSET.MANDT == EQUI.MANDT
  • C_INSPECTIONSUBSET.EQUIPMENT == EQUI.EQUNR
Functional Location
  • Client
  • Functional Location
  • C_INSPECTIONSUBSET.MANDT == IFLOT.MANDT
  • C_INSPECTIONSUBSET.FUNCTIONALLOCATION == IFLOT.TPLNR
Inspection Type
  • Client
  • Inspection Type
  • C_INSPECTIONSUBSET.MANDT == TQ30.MANDT
  • C_INSPECTIONSUBSET.INSPECTIONLOTTYPE == TQ30.ART
Inspection Point Identification
  • Identifier for Inspection Point Field Combination
  • Client
  • C_INSPECTIONSUBSET.INSPSUBSETFIELDCOMBINATION == TQ79.SLWBEZ
  • C_INSPECTIONSUBSET.MANDT == TQ79.MANDT
Usage Decision Code
  • Usage Decision Code
  • ?
  • Client
  • Code Group of the Usage Decision
  • ?
  • C_INSPECTIONSUBSET.INSPSUBSETUSAGEDCSNCODE == QPCD.CODE
  • C_INSPECTIONSUBSET.[column in domain "QVERSNR"] == QPCD.VERSION
  • C_INSPECTIONSUBSET.MANDT == QPCD.MANDT
  • C_INSPECTIONSUBSET.INSPSUBSETUSAGEDCSNCODEGROUP == QPCD.CODEGRUPPE
  • C_INSPECTIONSUBSET.[column in domain "QKATART"] == QPCD.KATALOGART
Code Group of the Usage Decision
  • Client
  • Code Group of the Usage Decision
  • ?
  • C_INSPECTIONSUBSET.MANDT == QPGR.MANDT
  • C_INSPECTIONSUBSET.INSPSUBSETUSAGEDCSNCODEGROUP == QPGR.CODEGRUPPE
  • C_INSPECTIONSUBSET.[column in domain "QKATART"] == QPGR.KATALOGART
Material Number
  • Material Number
  • Client
  • C_INSPECTIONSUBSET.MATERIAL == MARA.MATNR
  • C_INSPECTIONSUBSET.MANDT == MARA.MANDT
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • C_INSPECTIONSUBSET.MANDT == TQ01B.MANDT
  • C_INSPECTIONSUBSET.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Plant
  • Client
  • C_INSPECTIONSUBSET.PLANT == T001W.WERKS
  • C_INSPECTIONSUBSET.MANDT == T001W.MANDT
Object ID of the resource
  • Client
  • ?
  • Object ID of the resource
  • C_INSPECTIONSUBSET.MANDT == CRID.MANDT
  • C_INSPECTIONSUBSET.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • C_INSPECTIONSUBSET.WORKCENTERINTERNALID == CRID.OBJID
Plant
  • Client
  • Plant
  • C_INSPECTIONSUBSET.MANDT == T001W.MANDT
  • C_INSPECTIONSUBSET.WORKCENTERPLANT == T001W.WERKS