ESH_S_INSPECTIONOPERATION

Search view -INSPECTIONOPERATION | view: ESH_U_INSPOPER | Extraction: Not supported | Component: Quality Inspection
Tables used: QALS, AFVC, QAOP, QAVE, KNA1, TQ31, TQ31T, TQ30, TQ30T, MARA, MAKT, T001W, CRTX, LFA1, QPCD, QPCT, CRHD
Column Name Description
INSPECTIONLOT Inspection Lot Number
INSPPLANOPERATIONINTERNALID Current Node Number from Order Counter
Column Name Description
Column Name Description
📏 Base Unit of Measure for Inspection Lot Quantity (INSPECTIONLOTQUANTITYUNIT):
INSPECTIONLOTQUANTITY Inspection Lot Quantity
Column Name Description
Column Name Description
INSPLOTUSAGEDECISIONVALUATION Code Valuation Show values
ISBUSINESSPURPOSECOMPLETED Business Purpose Completed Flag Show values
Column Name Description Domain name
INSPECTIONLOTORIGINTEXT Inspection Lot Origin Text QKURZTEXT
INSPECTIONLOTQUALITYSCORE Quality Score QKENNZAHL
INSPECTIONLOTTEXT Inspection Lot Text QKURZTEXT
INSPECTIONLOTTYPETEXT Inspection Type Text
INSPECTIONOPERATION Operation/Activity Number VORNR
INSPLOTUSGEDCSNVALUATIONTEXT Usage Decision Valuation Text DDTEXT
MATERIALNAME Material Description TEXT40
OPERATIONTEXT Operation Short Text TEXT40
CUSTOMER_NAME1 Name 1
ORGANIZATIONBPNAME1 Name 1
PLANTNAME Plant Name TEXT30
USAGEDECISIONCODE Code
USAGEDECISIONCODETEXT Text for Code QKURZTEXT
WORKCENTER Work Center ARBPL
WORKCENTERTEXT Work Center Text TEXT40
Master Data Relations Join Conditions
Batch Number
  • Client
  • Material Number
  • Batch Number
  • ESH_S_INSPECTIONOPERATION.MANDT == MCH1.MANDT
  • ESH_S_INSPECTIONOPERATION.MATERIAL == MCH1.MATNR
  • ESH_S_INSPECTIONOPERATION.BATCH == MCH1.CHARG
Customer (Ship-To Party)
  • Customer (Ship-To Party)
  • Client
  • ESH_S_INSPECTIONOPERATION.CUSTOMER == KNA1.KUNNR
  • ESH_S_INSPECTIONOPERATION.MANDT == KNA1.MANDT
Inspection Lot Origin ESH_S_INSPECTIONOPERATION.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Base Unit of Measure for Inspection Lot Quantity
  • Client
  • Base Unit of Measure for Inspection Lot Quantity
  • ESH_S_INSPECTIONOPERATION.MANDT == T006.MANDT
  • ESH_S_INSPECTIONOPERATION.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI
Inspection Type
  • Client
  • Inspection Type
  • ESH_S_INSPECTIONOPERATION.MANDT == TQ30.MANDT
  • ESH_S_INSPECTIONOPERATION.INSPECTIONLOTTYPE == TQ30.ART
Plant
  • Client
  • Plant
  • ESH_S_INSPECTIONOPERATION.MANDT == T001W.MANDT
  • ESH_S_INSPECTIONOPERATION.INSPECTIONOPERATIONPLANT == T001W.WERKS
Material Number
  • Client
  • Material Number
  • ESH_S_INSPECTIONOPERATION.MANDT == MARA.MANDT
  • ESH_S_INSPECTIONOPERATION.MATERIAL == MARA.MATNR
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • ESH_S_INSPECTIONOPERATION.MANDT == TQ01B.MANDT
  • ESH_S_INSPECTIONOPERATION.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Client
  • Plant
  • ESH_S_INSPECTIONOPERATION.MANDT == T001W.MANDT
  • ESH_S_INSPECTIONOPERATION.PLANT == T001W.WERKS
Vendor's account number
  • Client
  • Vendor's account number
  • ESH_S_INSPECTIONOPERATION.MANDT == LFA1.MANDT
  • ESH_S_INSPECTIONOPERATION.SUPPLIER == LFA1.LIFNR