I_InspLotUsgeDcsnCodes

Usage Decision Codes for Inspection Lot | view: IINSPLOTUDCODES | Extraction: Not supported | Component: Quality Inspection
Tables used: QALS, TQ30, QPAC, QPCD, TQSS1_AVE
Column Name Description
InspectionLot Inspection Lot Number
SelectedCodeSetPlant FK Plant
SelectedCodeSet FK Selected Set
UsageDecisionCodeGroup FK Code Group
UsageDecisionCode FK Code
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
CodeIsInactive Field Not Used as of 3.0 Field Reserved for SAP CHAR1
Master Data Relations Join Conditions
Inspection Type
  • Inspection Type
  • Client
  • I_INSPLOTUSGEDCSNCODES.INSPECTIONLOTTYPE == TQ30.ART
  • I_INSPLOTUSGEDCSNCODES.MANDT == TQ30.MANDT
Material Authorization Group for Activities in QM
  • Material Authorization Group for Activities in QM
  • Client
  • I_INSPLOTUSGEDCSNCODES.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
  • I_INSPLOTUSGEDCSNCODES.MANDT == TQ01B.MANDT
Plant
  • Plant
  • Client
  • I_INSPLOTUSGEDCSNCODES.PLANT == T001W.WERKS
  • I_INSPLOTUSGEDCSNCODES.MANDT == T001W.MANDT
Selected Set
  • Plant
  • ?
  • Client
  • Selected Set
  • I_INSPLOTUSGEDCSNCODES.SELECTEDCODESETPLANT == QPAM.WERKS
  • I_INSPLOTUSGEDCSNCODES.[column in domain "QKATART"] == QPAM.KATALOGART
  • I_INSPLOTUSGEDCSNCODES.MANDT == QPAM.MANDT
  • I_INSPLOTUSGEDCSNCODES.SELECTEDCODESET == QPAM.AUSWAHLMGE
Plant
  • Plant
  • Client
  • I_INSPLOTUSGEDCSNCODES.SELECTEDCODESETPLANT == T001W.WERKS
  • I_INSPLOTUSGEDCSNCODES.MANDT == T001W.MANDT
Code
  • Code
  • ?
  • Client
  • ?
  • Code Group
  • I_INSPLOTUSGEDCSNCODES.USAGEDECISIONCODE == QPCD.CODE
  • I_INSPLOTUSGEDCSNCODES.[column in domain "QKATART"] == QPCD.KATALOGART
  • I_INSPLOTUSGEDCSNCODES.MANDT == QPCD.MANDT
  • I_INSPLOTUSGEDCSNCODES.[column in domain "QVERSNR"] == QPCD.VERSION
  • I_INSPLOTUSGEDCSNCODES.USAGEDECISIONCODEGROUP == QPCD.CODEGRUPPE
Code Group
  • ?
  • Client
  • Code Group
  • I_INSPLOTUSGEDCSNCODES.[column in domain "QKATART"] == QPGR.KATALOGART
  • I_INSPLOTUSGEDCSNCODES.MANDT == QPGR.MANDT
  • I_INSPLOTUSGEDCSNCODES.USAGEDECISIONCODEGROUP == QPGR.CODEGRUPPE