I_MaintOrderInspectionLot

Maintenance Order Inspection Lot | view: IMAINTORDINSPLOT | TRAN | Extraction: Not supported | Component: Checklist
Tables used: QALS, AFIH, AFKO, EQUI, EQUZ, EAM_CLOBJ, AUFK
Column Name Description
MaintenanceOrder FK Order Number
InspectionLot Inspection Lot Number
Column Name Description
Column Name Description
Column Name Description
InspLotCreatedOnLocalDate Date in Time Zone Where Lot Created
InspLotCreatedOnLocalTime Time in Time Zone Where Lot Created
InspectionLotCreatedOn System Date on Which Data Record Was Created
InspectionLotCreatedOnTime System Time of Creation
InspectionLotChangeDate System Date on Which Data Record Was Changed
InspectionLotChangeTime System Time of Change
InspectionLotStartDate Start Date of Inspection in Local Time Zone
InspectionLotStartTime Inspection Started At
InspectionLotEndDate End Date of Inspection in Local Time Zone
InspectionLotEndTime Inspection Ended At
InspLotSelectionValidFromDate Key Date for Selecting Records or Changing Task Lists
Column Name Description
InspectionLotIsSkipped Skip Lot Show values
InspLotUsageDecisionTool Usage Decision Mode (UD Origin) Show values
InspectionLotHasUsageDecision Usage Decision Made Show values
MainChecklistIsDeactivated Checklists: Deactivated indicator Show values
Column Name Description Domain name
GoodsReceiptIsMovedToBlkdStock GR Blocked Stock KZWES
InspectionLotCreatedBy Name of User Who Created the Data Record QAENDERER
InspectionLotChangedBy Name of User Who Last Changed Data Record QAENDERER
ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
BillOfOperationsGroup Bill of Operations Group PLNNR
BillOfOperationsVariant Bill of Operations Group Counter ALTNR
BillOfOperationsChangeStateID Internal counter CIM_COUNT
OrderInternalBillOfOperations Routing number of operations in the order AUFPL
InspectionLotText Inspection Lot Text QKURZTEXT
InspectionLotObjectText Short Text for Inspection Object QKURZTEXT
InspLotNmbrAddlRecordedCharc Number of Characteristics Recorded Additionally INT2
InspLotNmbrOpenShortTermCharc Number of Outstanding Short-Term Chars That Require Confirm. INT2
InspLotNmbrOpenLongTermCharc Open Long-Term Characteristics INT2
MaintBusinessSubobjectType Checklists: Sub Object Type OJ_NAME
MaintenanceBusinessSubobject Checklists: Sub Object Key ID SWO_TYPEID
MaintChecklistTemplateType Checklists: Checklist Template Object Type OJ_NAME
MaintenanceChecklistTemplate Checklists: Checklist Template Object Key ID SWO_TYPEID
MaintChklstAddlInformationText Checklists: Status information TEXT40
MaintenanceBusinessObjectType Checklists: Object Type OJ_NAME
MaintenanceChecklistType Checklists: Checklist Object Type OJ_NAME
Master Data Relations | to Other Relations ↓ Join Conditions
Technical Object Authorization Group
  • Client
  • Technical Object Authorization Group
  • I_MAINTORDERINSPECTIONLOT.MANDT == T370B.MANDT
  • I_MAINTORDERINSPECTIONLOT.AUTHORIZATIONGROUP == T370B.BEGRU
Bill of Operations Type
  • Client
  • Bill of Operations Type
  • I_MAINTORDERINSPECTIONLOT.MANDT == TCA01.MANDT
  • I_MAINTORDERINSPECTIONLOT.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Bill of Operations Usage
  • Bill of Operations Usage
  • Client
  • I_MAINTORDERINSPECTIONLOT.BILLOFOPERATIONSUSAGE == T411.VERWE
  • I_MAINTORDERINSPECTIONLOT.MANDT == T411.MANDT
Customer (Ship-To Party)
  • Client
  • Customer (Ship-To Party)
  • I_MAINTORDERINSPECTIONLOT.MANDT == KNA1.MANDT
  • I_MAINTORDERINSPECTIONLOT.CUSTOMER == KNA1.KUNNR
Equipment Number
  • Equipment Number
  • Client
  • I_MAINTORDERINSPECTIONLOT.EQUIPMENT == EQUI.EQUNR
  • I_MAINTORDERINSPECTIONLOT.MANDT == EQUI.MANDT
Functional Location
  • Client
  • Functional Location
  • I_MAINTORDERINSPECTIONLOT.MANDT == IFLOT.MANDT
  • I_MAINTORDERINSPECTIONLOT.FUNCTIONALLOCATION == IFLOT.TPLNR
Inspection Lot Origin I_MAINTORDERINSPECTIONLOT.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Type
  • Inspection Type
  • Client
  • I_MAINTORDERINSPECTIONLOT.INSPECTIONLOTTYPE == TQ30.ART
  • I_MAINTORDERINSPECTIONLOT.MANDT == TQ30.MANDT
Task List Usage
  • Client
  • Task List Usage
  • I_MAINTORDERINSPECTIONLOT.MANDT == T411.MANDT
  • I_MAINTORDERINSPECTIONLOT.INSPLOTSELBILLOFOPERATIONSUSGE == T411.VERWE
Account number of customer
  • Client
  • Account number of customer
  • I_MAINTORDERINSPECTIONLOT.MANDT == KNA1.MANDT
  • I_MAINTORDERINSPECTIONLOT.INSPLOTSELECTIONCUSTOMER == KNA1.KUNNR
Vendor's account number
  • Client
  • Vendor's account number
  • I_MAINTORDERINSPECTIONLOT.MANDT == LFA1.MANDT
  • I_MAINTORDERINSPECTIONLOT.INSPLOTSELECTIONSUPPLIER == LFA1.LIFNR
Language Key I_MAINTORDERINSPECTIONLOT.LANGUAGE == T002.SPRAS
Order Number
  • Order Number (Production Order)
  • Order Number
  • Client
  • I_MAINTORDERINSPECTIONLOT.MANUFACTURINGORDER == AUFK.AUFNR
  • I_MAINTORDERINSPECTIONLOT.MAINTENANCEORDER == AUFK.AUFNR
  • I_MAINTORDERINSPECTIONLOT.MANDT == AUFK.MANDT
Order Type
  • Client
  • Order Type
  • I_MAINTORDERINSPECTIONLOT.MANDT == T003O.CLIENT
  • I_MAINTORDERINSPECTIONLOT.MAINTENANCEORDERTYPE == T003O.AUART
Location and account assignment for technical object
  • Client
  • Location and account assignment for technical object
  • I_MAINTORDERINSPECTIONLOT.MANDT == ILOA.MANDT
  • I_MAINTORDERINSPECTIONLOT.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
Order Number (Production Order)
  • Order Number (Production Order)
  • Order Number
  • Client
  • I_MAINTORDERINSPECTIONLOT.MANUFACTURINGORDER == AUFK.AUFNR
  • I_MAINTORDERINSPECTIONLOT.MAINTENANCEORDER == AUFK.AUFNR
  • I_MAINTORDERINSPECTIONLOT.MANDT == AUFK.MANDT
Plant
  • Plant
  • Client
  • I_MAINTORDERINSPECTIONLOT.PLANT == T001W.WERKS
  • I_MAINTORDERINSPECTIONLOT.MANDT == T001W.MANDT
Object Type I_MAINTORDERINSPECTIONLOT.STATUSOBJECTCATEGORY == TJ03.OBTYP
Status Profile
  • Client
  • Status Profile
  • I_MAINTORDERINSPECTIONLOT.MANDT == TJ20.MANDT
  • I_MAINTORDERINSPECTIONLOT.STATUSPROFILE == TJ20.STSMA
Vendor's account number
  • Vendor's account number
  • Client
  • I_MAINTORDERINSPECTIONLOT.SUPPLIER == LFA1.LIFNR
  • I_MAINTORDERINSPECTIONLOT.MANDT == LFA1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Client
  • I_MAINTORDERINSPECTIONLOT.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • I_MAINTORDERINSPECTIONLOT.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_MAINTORDERINSPECTIONLOT.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • I_MAINTORDERINSPECTIONLOT.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • I_MAINTORDERINSPECTIONLOT.MANDT == T399I.MANDT