P_MaintOrdDirectProcmtViaPR

Purchase Requisitions for Direct Procurement | view: PMTORDPROMTPREQ | Extraction: Not supported | Component: Plant Maintenance
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, AFKO, AFKO, AFIH, AFKO, RESB, 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
ReferenceDate null
MaintOrdBasicStartDate Basic Start Date
OpErlstSchedldExecStrtDte Earliest scheduled start: Execution (date)
RequirementDate Requirements date for the component
ScheduledBasicStartDate Scheduled start
ScheduledBasicStartTime Scheduled Start (Time)
ScheduledBasicEndDate Scheduled finish
ScheduledBasicEndTime Scheduled finish time
Column Name Description
OperationIsProcessedExternally Checkbox Show values
MaintenanceProcessingPhase Maintenance Processing Phase Show values
PurReqnCmpltnsCat Category of Incompleteness Show values
PurReqnReleaseStatus Requisition Processing State 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
ManufacturingOrderOperation Operation/Activity Number VORNR
OperationDescription Operation Short Text TEXT40
MaintenanceOrderDesc Description TEXT40
MaintPriorityDesc Priority Text TEXT20
MaintPriorityColorCode null
MainWorkCenter Main work center for maintenance tasks ARBPL
MainWorkCenterPlant Plant associated with main work center WERKS
MaterialName BOM Item Text (Line 1) TEXT40
SupplierName Name of Supplier TEXT80
PreferredSupplierName Name of Supplier TEXT80
Master Data Relations | to Other Relations ↓ Join Conditions
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • P_MAINTORDDIRECTPROCMTVIAPR.MANDT == T006.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPR.BASEUNIT == T006.MSEHI
Equipment Number
  • Client
  • Equipment Number
  • P_MAINTORDDIRECTPROCMTVIAPR.MANDT == EQUI.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPR.EQUIPMENT == EQUI.EQUNR
Functional Location
  • Client
  • Functional Location
  • P_MAINTORDDIRECTPROCMTVIAPR.MANDT == IFLOT.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPR.FUNCTIONALLOCATION == IFLOT.TPLNR
Order Number
  • Client
  • Order Number
  • P_MAINTORDDIRECTPROCMTVIAPR.MANDT == AUFK.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPR.MAINTENANCEORDER == AUFK.AUFNR
Order Type
  • Client
  • Order Type
  • P_MAINTORDDIRECTPROCMTVIAPR.MANDT == T003O.CLIENT
  • P_MAINTORDDIRECTPROCMTVIAPR.MAINTENANCEORDERTYPE == T003O.AUART
Location Plant
  • Client
  • Location Plant
  • P_MAINTORDDIRECTPROCMTVIAPR.MANDT == T001W.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPR.MAINTENANCEPLANT == T001W.WERKS
Revision for Plant Maintenance and Customer Service
  • Client
  • Revision for Plant Maintenance and Customer Service
  • Maintenance Planning Plant
  • P_MAINTORDDIRECTPROCMTVIAPR.MANDT == T352R.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPR.MAINTENANCEREVISION == T352R.REVNR
  • P_MAINTORDDIRECTPROCMTVIAPR.MAINTENANCEPLANNINGPLANT == T352R.IWERK
Location and account assignment for technical object
  • Client
  • Location and account assignment for technical object
  • P_MAINTORDDIRECTPROCMTVIAPR.MANDT == ILOA.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPR.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
Priority
  • Client
  • Priority
  • Priority Type
  • P_MAINTORDDIRECTPROCMTVIAPR.MANDT == T356.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPR.MAINTPRIORITY == T356.PRIOK
  • P_MAINTORDDIRECTPROCMTVIAPR.MAINTPRIORITYTYPE == T356.ARTPR
Priority Type
  • Client
  • Priority Type
  • P_MAINTORDDIRECTPROCMTVIAPR.MANDT == T356A.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPR.MAINTPRIORITYTYPE == T356A.ARTPR
Material Number
  • Client
  • Material Number
  • P_MAINTORDDIRECTPROCMTVIAPR.MANDT == MARA.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPR.MATERIAL == MARA.MATNR
Plant Section
  • Client
  • Plant Section
  • ?
  • P_MAINTORDDIRECTPROCMTVIAPR.MANDT == T357.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPR.PLANTSECTION == T357.BEBER
  • P_MAINTORDDIRECTPROCMTVIAPR.[column in domain "WERKS_D"] == T357.WERKS
Desired Vendor
  • Client
  • Desired Vendor
  • P_MAINTORDDIRECTPROCMTVIAPR.MANDT == LFA1.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPR.PREFERREDSUPPLIER == LFA1.LIFNR
Fixed Vendor
  • Fixed Vendor
  • Client
  • P_MAINTORDDIRECTPROCMTVIAPR.SUPPLIER == LFA1.LIFNR
  • P_MAINTORDDIRECTPROCMTVIAPR.MANDT == LFA1.MANDT
Object ID of the Work Center
  • Client
  • Object ID of the Work Center
  • ?
  • P_MAINTORDDIRECTPROCMTVIAPR.MANDT == CRID.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPR.WORKCENTERINTERNALID == CRID.OBJID
  • P_MAINTORDDIRECTPROCMTVIAPR.[column in domain "CR_OBJTY"] == CRID.OBJTY
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Planner Group for Customer Service and Plant Maintenance
  • Client
  • Maintenance Planning Plant
  • P_MAINTORDDIRECTPROCMTVIAPR.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • P_MAINTORDDIRECTPROCMTVIAPR.MANDT == T024I.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPR.MAINTENANCEPLANNINGPLANT == T024I.IWERK
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • P_MAINTORDDIRECTPROCMTVIAPR.MANDT == T399I.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPR.MAINTENANCEPLANNINGPLANT == T399I.IWERK