ESH_S_INSPECTIONLOT

Search view -INSPECTIONLOT | view: ESH_U_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
INSPECTIONLOTQUALITYSCORE Quality Score QKENNZAHL
INSPECTIONLOTTEXT Inspection Lot Text QKURZTEXT
INSPECTIONLOTTYPETEXT Inspection Type Text
INSPECTIONSUBSETTYPETEXT Short Text for Fixed Values DDTEXT
INSPLOTUSGEDCSNVALUATIONTEXT Usage Decision Valuation Text
MATERIALDOCUMENT Number of Material Document BELNR
MATERIALNAME Material Description TEXT40
MATLQLTYAUTHORIZATIONGRPTEXT Material Authorization Group Text for Activities in QM
CUSTOMER_NAME Name 1
SUPPLIER_NAME Name 1
PLANTNAME Plant Name TEXT30
USAGEDECISIONCODETEXT Text for Code
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Client
  • Material Number
  • ESH_S_INSPECTIONLOT.BATCH == MCH1.CHARG
  • ESH_S_INSPECTIONLOT.MANDT == MCH1.MANDT
  • ESH_S_INSPECTIONLOT.MATERIAL == MCH1.MATNR
Customer (Ship-To Party)
  • Customer (Ship-To Party)
  • Client
  • ESH_S_INSPECTIONLOT.CUSTOMER == KNA1.KUNNR
  • ESH_S_INSPECTIONLOT.MANDT == KNA1.MANDT
Inspection Type
  • Inspection Type
  • Client
  • ESH_S_INSPECTIONLOT.INSPECTIONLOTTYPE == TQ30.ART
  • ESH_S_INSPECTIONLOT.MANDT == TQ30.MANDT
Usage Decision Code
  • ?
  • Client
  • Usage Decision Code
  • ?
  • ?
  • ESH_S_INSPECTIONLOT.[column in domain "QCODEGRP"] == QPCD.CODEGRUPPE
  • ESH_S_INSPECTIONLOT.MANDT == QPCD.MANDT
  • ESH_S_INSPECTIONLOT.INSPECTIONLOTUSAGEDECISIONCODE == QPCD.CODE
  • ESH_S_INSPECTIONLOT.[column in domain "QVERSNR"] == QPCD.VERSION
  • ESH_S_INSPECTIONLOT.[column in domain "QKATART"] == QPCD.KATALOGART
Number of Manufacturer
  • Number of Manufacturer
  • Client
  • ESH_S_INSPECTIONLOT.MANUFACTURER == LFA1.LIFNR
  • ESH_S_INSPECTIONLOT.MANDT == LFA1.MANDT
Order Number (Production Order)
  • Order Number (Production Order)
  • Client
  • ESH_S_INSPECTIONLOT.MANUFACTURINGORDER == AUFK.AUFNR
  • ESH_S_INSPECTIONLOT.MANDT == AUFK.MANDT
Material Number
  • Client
  • Material Number
  • ESH_S_INSPECTIONLOT.MANDT == MARA.MANDT
  • ESH_S_INSPECTIONLOT.MATERIAL == MARA.MATNR
Material Authorization Group for Activities in QM
  • Material Authorization Group for Activities in QM
  • Client
  • ESH_S_INSPECTIONLOT.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
  • ESH_S_INSPECTIONLOT.MANDT == TQ01B.MANDT
Plant
  • Plant
  • Client
  • ESH_S_INSPECTIONLOT.PLANT == T001W.WERKS
  • ESH_S_INSPECTIONLOT.MANDT == T001W.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • ESH_S_INSPECTIONLOT.SUPPLIER == LFA1.LIFNR
  • ESH_S_INSPECTIONLOT.MANDT == LFA1.MANDT