ESH_N_INSPECTIONOPERATION

Anchor view -INSPECTIONOPERATION | view: ESH_L_INSPOPER | Extraction: Not supported | Component: Quality Inspection
Tables used: QALSAFVCQAOPQAVEKNA1TQ31TQ31TTQ30TQ30TMARAMAKTT001WCRTXLFA1QPCDQPCTCRHD
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 QKURZTEXT
INSPECTIONOPERATION Operation/Activity Number VORNR
INSPLOTUSGEDCSNVALUATIONTEXT Usage Decision Valuation Text DDTEXT
MATERIALNAME Material Description TEXT40
OPERATIONTEXT Operation Short Text TEXT40
CUSTOMER_NAME1 Name 1 NAME
ORGANIZATIONBPNAME1 Name 1 NAME
PLANTNAME Plant Name TEXT30
USAGEDECISIONCODE Code QCODE
USAGEDECISIONCODETEXT Text for Code QKURZTEXT
WORKCENTER Work Center ARBPL
WORKCENTERTEXT Work Center Text TEXT40
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Client
  • Material Number
  • ESH_N_INSPECTIONOPERATION.BATCH == MCH1.CHARG
  • ESH_N_INSPECTIONOPERATION.MANDT == MCH1.MANDT
  • ESH_N_INSPECTIONOPERATION.MATERIAL == MCH1.MATNR
Customer (Ship-To Party)
  • Customer (Ship-To Party)
  • Client
  • ESH_N_INSPECTIONOPERATION.CUSTOMER == KNA1.KUNNR
  • ESH_N_INSPECTIONOPERATION.MANDT == KNA1.MANDT
Inspection Lot Origin ESH_N_INSPECTIONOPERATION.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Base Unit of Measure for Inspection Lot Quantity
  • Client
  • Base Unit of Measure for Inspection Lot Quantity
  • ESH_N_INSPECTIONOPERATION.MANDT == T006.MANDT
  • ESH_N_INSPECTIONOPERATION.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI
Inspection Type
  • Inspection Type
  • Client
  • ESH_N_INSPECTIONOPERATION.INSPECTIONLOTTYPE == TQ30.ART
  • ESH_N_INSPECTIONOPERATION.MANDT == TQ30.MANDT
Plant
  • Client
  • Plant
  • ESH_N_INSPECTIONOPERATION.MANDT == T001W.MANDT
  • ESH_N_INSPECTIONOPERATION.INSPECTIONOPERATIONPLANT == T001W.WERKS
Material Number
  • Client
  • Material Number
  • ESH_N_INSPECTIONOPERATION.MANDT == MARA.MANDT
  • ESH_N_INSPECTIONOPERATION.MATERIAL == MARA.MATNR
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • ESH_N_INSPECTIONOPERATION.MANDT == TQ01B.MANDT
  • ESH_N_INSPECTIONOPERATION.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Client
  • Plant
  • ESH_N_INSPECTIONOPERATION.MANDT == T001W.MANDT
  • ESH_N_INSPECTIONOPERATION.PLANT == T001W.WERKS
Vendor's account number
  • Client
  • Vendor's account number
  • ESH_N_INSPECTIONOPERATION.MANDT == LFA1.MANDT
  • ESH_N_INSPECTIONOPERATION.SUPPLIER == LFA1.LIFNR