C_MaintOrdCompPurReqItem

Purchase Requisitions for Plant Maintenance | view: CMTORDPURREQI | Extraction: Not supported | Component: Plant Maintenance
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, AFKO, AFKO, AFIH, AFKO, RESB, AFKO, AFVC, EAM_ORDPROCMLST, AFVV, EBAN, EBKN, JSTO, JEST, PRTE, AFVC, AFVU, AFVV, TKA01, FM01, ILOA, AUFK, AUFK, AUFK, RSADD, RSDB, AUFK, RSDB, T430, T001W, T356, T356_T, PROJ, T000, LFA1, T001K, PRPS, EAM_MOPEXCPHASE, EAM_MOPEXCPHASEC, MMPUR_C_BE_SYREG, FINSC_FISC_DATE
Column Name Description
PurchaseRequisition Purchase Requisition Number
PurchaseRequisitionItem FK Item number of purchase requisition
Column Name Description
💲 Currency Key (PurReqnItemCurrency):
PurchaseRequisitionPrice Price in Purchase Requisition
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
MaintOrdProcmtMilestoneDate Procurement Activity Due Date
Column Name Description
WorkCenterTypeCode Object Type of CIM Resources for Work Center Show values
OperationIsProcessedExternally Checkbox Show values
Column Name Description Domain name
MaintenanceOrderDesc Description TEXT40
MaintOrderRoutingNumber Routing number of operations in the order AUFPL
MaintenanceOrderOperation Maintenance Order Operation
OperationDescription Operation Short Text
MaintOrderOperationCounter Internal counter CIM_COUNT
MaintenanceOrderSubOperation null
Reservation Number of reservation/dependent requirements RSNUM
ReservationItem Item Number of Reservation / Dependent Requirements
MaintPriorityColorCode null
MaintPriorityDesc Priority Text TEXT20
MainWorkCenter Main work center for maintenance tasks
MainWorkCenterPlant Plant associated with main work center WERKS
MaterialName Short Text TEXT40
MaterialThumbnailURL null
PurReqnReleaseStatus Requisition Processing State
SupplierName Name of Supplier TEXT80
PreferredSupplierName Name of Supplier TEXT80
MaintProcurementMilestone Next Procurement Activity MAINTPROCUREMENTMILESTONE
MaintPlanningBucketUUID Maintenance Planning Bucket SYSUUID
Master Data Relations | to Other Relations ↓ Join Conditions
Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • Client
  • C_MAINTORDCOMPPURREQITEM.BASEUNIT == T006.MSEHI
  • C_MAINTORDCOMPPURREQITEM.MANDT == T006.MANDT
Equipment Number
  • Equipment Number
  • Client
  • C_MAINTORDCOMPPURREQITEM.EQUIPMENT == EQUI.EQUNR
  • C_MAINTORDCOMPPURREQITEM.MANDT == EQUI.MANDT
Functional Location
  • Functional Location
  • Client
  • C_MAINTORDCOMPPURREQITEM.FUNCTIONALLOCATION == IFLOT.TPLNR
  • C_MAINTORDCOMPPURREQITEM.MANDT == IFLOT.MANDT
Order Number
  • Order Number
  • Client
  • C_MAINTORDCOMPPURREQITEM.MAINTENANCEORDER == AUFK.AUFNR
  • C_MAINTORDCOMPPURREQITEM.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • C_MAINTORDCOMPPURREQITEM.MAINTENANCEORDERTYPE == T003O.AUART
  • C_MAINTORDCOMPPURREQITEM.MANDT == T003O.CLIENT
Location Plant
  • Location Plant
  • Client
  • C_MAINTORDCOMPPURREQITEM.MAINTENANCEPLANT == T001W.WERKS
  • C_MAINTORDCOMPPURREQITEM.MANDT == T001W.MANDT
Revision for Plant Maintenance and Customer Service
  • Maintenance Planning Plant
  • Client
  • Revision for Plant Maintenance and Customer Service
  • C_MAINTORDCOMPPURREQITEM.MAINTENANCEPLANNINGPLANT == T352R.IWERK
  • C_MAINTORDCOMPPURREQITEM.MANDT == T352R.MANDT
  • C_MAINTORDCOMPPURREQITEM.MAINTENANCEREVISION == T352R.REVNR
Location and account assignment for technical object
  • Client
  • Location and account assignment for technical object
  • C_MAINTORDCOMPPURREQITEM.MANDT == ILOA.MANDT
  • C_MAINTORDCOMPPURREQITEM.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
Priority
  • Priority
  • Priority Type
  • Client
  • C_MAINTORDCOMPPURREQITEM.MAINTPRIORITY == T356.PRIOK
  • C_MAINTORDCOMPPURREQITEM.MAINTPRIORITYTYPE == T356.ARTPR
  • C_MAINTORDCOMPPURREQITEM.MANDT == T356.MANDT
Priority Type
  • Priority Type
  • Client
  • C_MAINTORDCOMPPURREQITEM.MAINTPRIORITYTYPE == T356A.ARTPR
  • C_MAINTORDCOMPPURREQITEM.MANDT == T356A.MANDT
Material Number
  • Client
  • Material Number
  • C_MAINTORDCOMPPURREQITEM.MANDT == MARA.MANDT
  • C_MAINTORDCOMPPURREQITEM.MATERIAL == MARA.MATNR
Plant Section
  • ?
  • Plant Section
  • Client
  • C_MAINTORDCOMPPURREQITEM.[column in domain "WERKS_D"] == T357.WERKS
  • C_MAINTORDCOMPPURREQITEM.PLANTSECTION == T357.BEBER
  • C_MAINTORDCOMPPURREQITEM.MANDT == T357.MANDT
Desired Vendor
  • Client
  • Desired Vendor
  • C_MAINTORDCOMPPURREQITEM.MANDT == LFA1.MANDT
  • C_MAINTORDCOMPPURREQITEM.PREFERREDSUPPLIER == LFA1.LIFNR
Purchasing Group
  • Purchasing Group
  • Client
  • C_MAINTORDCOMPPURREQITEM.PURCHASINGGROUP == T024.EKGRP
  • C_MAINTORDCOMPPURREQITEM.MANDT == T024.MANDT
Currency Key
  • Currency Key
  • Client
  • C_MAINTORDCOMPPURREQITEM.PURREQNITEMCURRENCY == TCURC.WAERS
  • C_MAINTORDCOMPPURREQITEM.MANDT == TCURC.MANDT
Fixed Vendor
  • Client
  • Fixed Vendor
  • C_MAINTORDCOMPPURREQITEM.MANDT == LFA1.MANDT
  • C_MAINTORDCOMPPURREQITEM.SUPPLIER == LFA1.LIFNR
Object ID of the Work Center
  • Object ID of the Work Center
  • Object Type of CIM Resources for Work Center
  • Client
  • C_MAINTORDCOMPPURREQITEM.WORKCENTERINTERNALID == CRID.OBJID
  • C_MAINTORDCOMPPURREQITEM.WORKCENTERTYPECODE == CRID.OBJTY
  • C_MAINTORDCOMPPURREQITEM.MANDT == CRID.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Client
  • Planner Group for Customer Service and Plant Maintenance
  • C_MAINTORDCOMPPURREQITEM.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • C_MAINTORDCOMPPURREQITEM.MANDT == T024I.MANDT
  • C_MAINTORDCOMPPURREQITEM.MAINTENANCEPLANNERGROUP == T024I.INGRP
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • C_MAINTORDCOMPPURREQITEM.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • C_MAINTORDCOMPPURREQITEM.MANDT == T399I.MANDT