I_MaintOrdCompPurRequisitionC

Purchase Requisitions for Maintenance Order Components | view: IMTORDCOMPPURREQ | Extraction: Not supported | Component: Plant Maintenance
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, AFKO, AFKO, AFIH, AFKO, RESB, EAM_ORDPROCMLST, AFVV, EBAN, EBKN, PRTE, AFVC, AFVU, AFVV, TKA01, FM01, ILOA, AUFK, AUFK, AUFK, RSADD, RSDB, RSDB, T430, T001W, T356, T356_T, PROJ, T000, LFA1, T001K, PRPS, MMPUR_C_BE_SYREG, FINSC_FISC_DATE
Column Name Description
PurchaseRequisition Purchase Requisition Number
PurchaseRequisitionItem FK Item number of purchase requisition
Column Name Description
Column Name Description
📏 Purchase requisition unit of measure (BaseUnit):
RequestedQuantity Purchase requisition quantity
Column Name Description
MaintOrdBasicStartDate Basic Start Date
OpErlstSchedldExecStrtDte Earliest scheduled start: Execution (date)
RequirementDate Requirements date for the component
ReferenceDate null
ScheduledBasicStartDate Scheduled start
ScheduledBasicStartTime Scheduled Start (Time)
ScheduledBasicEndDate Scheduled finish
ScheduledBasicEndTime Scheduled finish time
MaintOrdProcmtMilestoneDate Order Procurement Milestone Date
Column Name Description
PurReqnReleaseStatus Requisition Processing State Show values
OperationIsProcessedExternally Checkbox Show values
Column Name Description Domain name
MaintOrderRoutingNumber Routing number of operations in the order AUFPL
MaintOrderOperationCounter Internal counter CIM_COUNT
Reservation Number of reservation/dependent requirements RSNUM
ReservationItem Item Number of Reservation / Dependent Requirements RSPOS
MaintenanceOrderOperation Maintenance Order Operation CHAR4
OperationDescription Operation Short Text TEXT40
MaintenanceOrderDesc Description TEXT40
MaintPriorityDesc Priority Text TEXT20
MainWorkCenter Main work center for maintenance tasks ARBPL
MainWorkCenterPlant Plant associated with main work center WERKS
SupplierName Name of Supplier TEXT80
PreferredSupplierName Name of Supplier TEXT80
MaterialName BOM Item Text (Line 1) TEXT40
MaintProcurementMilestone Procurement Milestone MAINTPROCUREMENTMILESTONE
Master Data Relations | to Other Relations ↓ Join Conditions
Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • Client
  • I_MAINTORDCOMPPURREQUISITIONC.BASEUNIT == T006.MSEHI
  • I_MAINTORDCOMPPURREQUISITIONC.MANDT == T006.MANDT
Equipment Number
  • Client
  • Equipment Number
  • I_MAINTORDCOMPPURREQUISITIONC.MANDT == EQUI.MANDT
  • I_MAINTORDCOMPPURREQUISITIONC.EQUIPMENT == EQUI.EQUNR
Functional Location
  • Functional Location
  • Client
  • I_MAINTORDCOMPPURREQUISITIONC.FUNCTIONALLOCATION == IFLOT.TPLNR
  • I_MAINTORDCOMPPURREQUISITIONC.MANDT == IFLOT.MANDT
Order Number
  • Order Number
  • Client
  • I_MAINTORDCOMPPURREQUISITIONC.MAINTENANCEORDER == AUFK.AUFNR
  • I_MAINTORDCOMPPURREQUISITIONC.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • I_MAINTORDCOMPPURREQUISITIONC.MAINTENANCEORDERTYPE == T003O.AUART
  • I_MAINTORDCOMPPURREQUISITIONC.MANDT == T003O.CLIENT
Location Plant
  • Location Plant
  • Client
  • I_MAINTORDCOMPPURREQUISITIONC.MAINTENANCEPLANT == T001W.WERKS
  • I_MAINTORDCOMPPURREQUISITIONC.MANDT == T001W.MANDT
Revision for Plant Maintenance and Customer Service
  • Maintenance Planning Plant
  • Client
  • Revision for Plant Maintenance and Customer Service
  • I_MAINTORDCOMPPURREQUISITIONC.MAINTENANCEPLANNINGPLANT == T352R.IWERK
  • I_MAINTORDCOMPPURREQUISITIONC.MANDT == T352R.MANDT
  • I_MAINTORDCOMPPURREQUISITIONC.MAINTENANCEREVISION == T352R.REVNR
Location and account assignment for technical object
  • Client
  • Location and account assignment for technical object
  • I_MAINTORDCOMPPURREQUISITIONC.MANDT == ILOA.MANDT
  • I_MAINTORDCOMPPURREQUISITIONC.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
Priority
  • ?
  • Client
  • Priority
  • I_MAINTORDCOMPPURREQUISITIONC.[column in domain "ARTPR"] == T356.ARTPR
  • I_MAINTORDCOMPPURREQUISITIONC.MANDT == T356.MANDT
  • I_MAINTORDCOMPPURREQUISITIONC.MAINTPRIORITY == T356.PRIOK
Material Number
  • Material Number
  • Client
  • I_MAINTORDCOMPPURREQUISITIONC.MATERIAL == MARA.MATNR
  • I_MAINTORDCOMPPURREQUISITIONC.MANDT == MARA.MANDT
Plant Section
  • Plant Section
  • Client
  • ?
  • I_MAINTORDCOMPPURREQUISITIONC.PLANTSECTION == T357.BEBER
  • I_MAINTORDCOMPPURREQUISITIONC.MANDT == T357.MANDT
  • I_MAINTORDCOMPPURREQUISITIONC.[column in domain "WERKS_D"] == T357.WERKS
Desired Vendor
  • Client
  • Desired Vendor
  • I_MAINTORDCOMPPURREQUISITIONC.MANDT == LFA1.MANDT
  • I_MAINTORDCOMPPURREQUISITIONC.PREFERREDSUPPLIER == LFA1.LIFNR
Fixed Vendor
  • Fixed Vendor
  • Client
  • I_MAINTORDCOMPPURREQUISITIONC.SUPPLIER == LFA1.LIFNR
  • I_MAINTORDCOMPPURREQUISITIONC.MANDT == LFA1.MANDT
Object ID of the Work Center
  • Object ID of the Work Center
  • ?
  • Client
  • I_MAINTORDCOMPPURREQUISITIONC.WORKCENTERINTERNALID == CRID.OBJID
  • I_MAINTORDCOMPPURREQUISITIONC.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_MAINTORDCOMPPURREQUISITIONC.MANDT == CRID.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_MAINTORDCOMPPURREQUISITIONC.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • I_MAINTORDCOMPPURREQUISITIONC.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_MAINTORDCOMPPURREQUISITIONC.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • I_MAINTORDCOMPPURREQUISITIONC.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • I_MAINTORDCOMPPURREQUISITIONC.MANDT == T399I.MANDT