ESH_N_INSPECTIONLOT

Anchor view -INSPECTIONLOT | view: ESH_L_INSPLOT | TRAN | Extraction: Not supported | Component: Quality Inspection
Tables used: QALS, QALSLTEXT, QAVE, KNA1, TQ31, TQ31T, TQ30, TQ30T, MARA, MAKT, TQ01B, TQ01C, T001W, LFA1, QPCD, QPCT
Column Name Description
INSPECTIONLOT Inspection Lot Number
Column Name Description
Column Name Description
Column Name Description
INSPECTIONLOTUSAGEDECIDEDON Date When Usage Decision Was Made
INSPLOTCREATEDONLOCALDATE Date in Time Zone Where Lot Created
Column Name Description
INSPECTIONLOTHASUSAGEDECISION Usage Decision Made Show values
INSPECTIONSUBSETTYPE Inspection Point Type Show values
INSPLOTUSAGEDECISIONVALUATION Code Valuation Show values
ISBUSINESSPURPOSECOMPLETED Business Purpose Completed Flag Show values
Column Name Description Domain name
INSPECTIONLOTLONGTEXT Long Text
INSPECTIONLOTORIGINTEXT Inspection Lot Origin Text QKURZTEXT
INSPECTIONLOTQUALITYSCORE Quality Score QKENNZAHL
INSPECTIONLOTTEXT Inspection Lot Text QKURZTEXT
INSPECTIONLOTTYPETEXT Inspection Type Text QKURZTEXT
INSPECTIONSUBSETTYPETEXT Short Text for Fixed Values DDTEXT
INSPLOTUSGEDCSNVALUATIONTEXT Usage Decision Valuation Text DDTEXT
MATERIALDOCUMENT Number of Material Document BELNR
MATERIALNAME Material Description TEXT40
MATLQLTYAUTHORIZATIONGRPTEXT Material Authorization Group Text for Activities in QM QKURZTEXT
CUSTOMER_NAME Name 1 NAME
SUPPLIER_NAME Name 1 NAME
PLANTNAME Plant Name TEXT30
USAGEDECISIONCODETEXT Text for Code QKURZTEXT
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Client
  • Material Number
  • ESH_N_INSPECTIONLOT.BATCH == MCH1.CHARG
  • ESH_N_INSPECTIONLOT.MANDT == MCH1.MANDT
  • ESH_N_INSPECTIONLOT.MATERIAL == MCH1.MATNR
Customer (Ship-To Party)
  • Customer (Ship-To Party)
  • Client
  • ESH_N_INSPECTIONLOT.CUSTOMER == KNA1.KUNNR
  • ESH_N_INSPECTIONLOT.MANDT == KNA1.MANDT
Inspection Type
  • Inspection Type
  • Client
  • ESH_N_INSPECTIONLOT.INSPECTIONLOTTYPE == TQ30.ART
  • ESH_N_INSPECTIONLOT.MANDT == TQ30.MANDT
Usage Decision Code
  • Usage Decision Code
  • Client
  • ?
  • ?
  • ?
  • ESH_N_INSPECTIONLOT.INSPECTIONLOTUSAGEDECISIONCODE == QPCD.CODE
  • ESH_N_INSPECTIONLOT.MANDT == QPCD.MANDT
  • ESH_N_INSPECTIONLOT.[column in domain "QKATART"] == QPCD.KATALOGART
  • ESH_N_INSPECTIONLOT.[column in domain "QCODEGRP"] == QPCD.CODEGRUPPE
  • ESH_N_INSPECTIONLOT.[column in domain "QVERSNR"] == QPCD.VERSION
Number of Manufacturer
  • Client
  • Number of Manufacturer
  • ESH_N_INSPECTIONLOT.MANDT == LFA1.MANDT
  • ESH_N_INSPECTIONLOT.MANUFACTURER == LFA1.LIFNR
Order Number (Production Order)
  • Client
  • Order Number (Production Order)
  • ESH_N_INSPECTIONLOT.MANDT == AUFK.MANDT
  • ESH_N_INSPECTIONLOT.MANUFACTURINGORDER == AUFK.AUFNR
Material Number
  • Client
  • Material Number
  • ESH_N_INSPECTIONLOT.MANDT == MARA.MANDT
  • ESH_N_INSPECTIONLOT.MATERIAL == MARA.MATNR
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • ESH_N_INSPECTIONLOT.MANDT == TQ01B.MANDT
  • ESH_N_INSPECTIONLOT.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Client
  • Plant
  • ESH_N_INSPECTIONLOT.MANDT == T001W.MANDT
  • ESH_N_INSPECTIONLOT.PLANT == T001W.WERKS
Vendor's account number
  • Client
  • Vendor's account number
  • ESH_N_INSPECTIONLOT.MANDT == LFA1.MANDT
  • ESH_N_INSPECTIONLOT.SUPPLIER == LFA1.LIFNR