ESH_N_INSPECTIONSUBSETSFI

Anchor view -INSPECTIONSUBSETSFI | view: ESH_L_INSPSUBS4 | TRAN | Extraction: Not supported | Component: Quality Inspection
Tables used: QALSAFVCQAOPQAPPTQ30TQ30TTQ79TQ79TMARAMAKTCRTXMPE_SFIQPCDQPCTCRHD
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
CREATIONDATE System Date on Which Data Record Was Created
CREATIONTIME System Time at Which Data Record Was Created
INSPECTIONSUBSETDATE User Field for Date
INSPECTIONSUBSETTIME User Field for Time
Column Name Description
INSPECTIONSUBSETTYPE Inspection Point Type Show values
INSPSUBSETUSAGEDCSNVALUATION Code Valuation Show values
ISBUSINESSPURPOSECOMPLETED Business Purpose Completed Flag Show values
Column Name Description Domain name
INSPECTIONLOTTYPETEXT Inspection Type Text QKURZTEXT
INSPECTIONOPERATION Operation/Activity Number VORNR
INSPECTIONSUBSETLONGCHARKEY User Field for 18 Characters QUSRCHAR18
INSPECTIONSUBSETSHORTCHARKEY User Field for 10 Characters QUSRCHAR10
INSPECTIONSUBSETSORTKEY Key Field (Sort Field) for Inspection Point QPPSORT
INSPLOTUSGEDCSNVALUATIONTEXT Short Text for Fixed Values DDTEXT
INSPSUBSETDATEFIELDNAME Keyword for User Field QUSRSLW
INSPSUBSETFIELDCOMBINATION Identifier for Inspection Point Field Combination QSLWBEZ
INSPSUBSETFLDCOMBINATIONTXT Short Text QKURZTEXT
INSPSUBSETLONGTXTFIELDNAME Keyword for User Field QUSRSLW
INSPSUBSETSHORTTXTFIELDNAME Keyword for User Field QUSRSLW
INSPSUBSETTIMEFIELDNAME Keyword for User Field QUSRSLW
MATERIAL Material Number MATNR
MATERIALNAME Material Description TEXT40
OPERATIONTEXT Operation Short Text TEXT40
SHOPFLOORITEM ID of Serialized Material
USAGEDECISIONCODE Code QCODE
USAGEDECISIONCODETEXT Text for Code QKURZTEXT
WORKCENTER Work Center ARBPL
WORKCENTERTEXT Work Center Text TEXT40
Master Data Relations Join Conditions
Inspection Type
  • Inspection Type
  • Client
  • ESH_N_INSPECTIONSUBSETSFI.INSPECTIONLOTTYPE == TQ30.ART
  • ESH_N_INSPECTIONSUBSETSFI.MANDT == TQ30.MANDT
Material Authorization Group for Activities in QM
  • Material Authorization Group for Activities in QM
  • Client
  • ESH_N_INSPECTIONSUBSETSFI.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
  • ESH_N_INSPECTIONSUBSETSFI.MANDT == TQ01B.MANDT
Plant
  • Plant
  • Client
  • ESH_N_INSPECTIONSUBSETSFI.PLANT == T001W.WERKS
  • ESH_N_INSPECTIONSUBSETSFI.MANDT == T001W.MANDT