C_MaintOrdCompPurOrderItem

Purchase Orders for Plant Maintenance | view: CMTORDPURORDER | Extraction: Not supported | Component: Plant Maintenance
Tables used: AFKO, AFKO, AFIH, AFKO, RESB, EAM_ORDPROCMLST, AFVV, EKKO, EKPO, EKKN, EKET, AFVC, AFVU, AFVV, TKA01, ILOA, AUFK, AUFK, AUFK, RSADD, RSDB, RSDB, T023, T023T, T430, T356, T356_T, T024, T000, T001L, LFA1
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
💲 Currency Key (DocumentCurrency):
NetAmount Net Order Value in PO Currency
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
ReceivedQuantity Quantity of Goods Received
OrderQuantity Purchase Order Quantity
Column Name Description
MaintOrdBasicStartDate Basic Start Date
OpErlstSchedldExecStrtDte Earliest scheduled start: Execution (date)
ReferenceDate null
RequirementDate Requirements date for the component
MaintOrdProcmtMilestoneDate Procurement Activity Due Date
Column Name Description
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
OperationIsProcessedExternally Checkbox Show values
Column Name Description Domain name
MaintenanceOrderDesc Description TEXT40
MaintenanceOrderOperation Maintenance Order Operation
OperationDescription Operation Short Text
OperationDescription_H Operation Short Text TEXT40
MaintenanceOrderSubOperation null
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
MaintOrdComponentIsMissing Checkbox
MaintPriorityColorCode null
MaintPriorityDesc Priority Text TEXT20
MainWorkCenter Main work center for maintenance tasks
MainWorkCenterPlant Plant associated with main work center WERKS
PurchaseOrderItemText Short Text TEXT40
PurchasingGroupName Purchasing Group Name TEXT18
MaterialGroupName Material Group Name TEXT20
StorageLocationName Storage Location Name TEXT16
PurchasingProcessingStatus Purchasing document processing state
SupplierName Name of Supplier TEXT80
ProductType Product Type Group CHAR2
MaintProcurementMilestone Next Procurement Activity MAINTPROCUREMENTMILESTONE
MaintPlanningBucketUUID Maintenance Planning Bucket SYSUUID
Master Data Relations | to Other Relations ↓ Join Conditions
Currency Key
  • Currency Key
  • Client
  • C_MAINTORDCOMPPURORDERITEM.DOCUMENTCURRENCY == TCURC.WAERS
  • C_MAINTORDCOMPPURORDERITEM.MANDT == TCURC.MANDT
Equipment Number
  • Equipment Number
  • Client
  • C_MAINTORDCOMPPURORDERITEM.EQUIPMENT == EQUI.EQUNR
  • C_MAINTORDCOMPPURORDERITEM.MANDT == EQUI.MANDT
Functional Location
  • Client
  • Functional Location
  • C_MAINTORDCOMPPURORDERITEM.MANDT == IFLOT.MANDT
  • C_MAINTORDCOMPPURORDERITEM.FUNCTIONALLOCATION == IFLOT.TPLNR
Order Number
  • Order Number
  • Client
  • C_MAINTORDCOMPPURORDERITEM.MAINTENANCEORDER == AUFK.AUFNR
  • C_MAINTORDCOMPPURORDERITEM.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • C_MAINTORDCOMPPURORDERITEM.MAINTENANCEORDERTYPE == T003O.AUART
  • C_MAINTORDCOMPPURORDERITEM.MANDT == T003O.CLIENT
Location Plant
  • Client
  • Location Plant
  • C_MAINTORDCOMPPURORDERITEM.MANDT == T001W.MANDT
  • C_MAINTORDCOMPPURORDERITEM.MAINTENANCEPLANT == T001W.WERKS
Revision for Plant Maintenance and Customer Service
  • Maintenance Planning Plant
  • Client
  • Revision for Plant Maintenance and Customer Service
  • C_MAINTORDCOMPPURORDERITEM.MAINTENANCEPLANNINGPLANT == T352R.IWERK
  • C_MAINTORDCOMPPURORDERITEM.MANDT == T352R.MANDT
  • C_MAINTORDCOMPPURORDERITEM.MAINTENANCEREVISION == T352R.REVNR
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • C_MAINTORDCOMPPURORDERITEM.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • C_MAINTORDCOMPPURORDERITEM.MANDT == ILOA.MANDT
Priority
  • Priority
  • Priority Type
  • Client
  • C_MAINTORDCOMPPURORDERITEM.MAINTPRIORITY == T356.PRIOK
  • C_MAINTORDCOMPPURORDERITEM.MAINTPRIORITYTYPE == T356.ARTPR
  • C_MAINTORDCOMPPURORDERITEM.MANDT == T356.MANDT
Priority Type
  • Priority Type
  • Client
  • C_MAINTORDCOMPPURORDERITEM.MAINTPRIORITYTYPE == T356A.ARTPR
  • C_MAINTORDCOMPPURORDERITEM.MANDT == T356A.MANDT
Material Number
  • Material Number
  • Client
  • C_MAINTORDCOMPPURORDERITEM.MATERIAL == MARA.MATNR
  • C_MAINTORDCOMPPURORDERITEM.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • C_MAINTORDCOMPPURORDERITEM.MATERIALGROUP == T023.MATKL
  • C_MAINTORDCOMPPURORDERITEM.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • C_MAINTORDCOMPPURORDERITEM.PLANT == T001W.WERKS
  • C_MAINTORDCOMPPURORDERITEM.MANDT == T001W.MANDT
Plant Section
  • ?
  • Plant Section
  • Client
  • C_MAINTORDCOMPPURORDERITEM.[column in domain "WERKS_D"] == T357.WERKS
  • C_MAINTORDCOMPPURORDERITEM.PLANTSECTION == T357.BEBER
  • C_MAINTORDCOMPPURORDERITEM.MANDT == T357.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • C_MAINTORDCOMPPURORDERITEM.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • C_MAINTORDCOMPPURORDERITEM.MANDT == T006.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_MAINTORDCOMPPURORDERITEM.PURCHASINGGROUP == T024.EKGRP
  • C_MAINTORDCOMPPURORDERITEM.MANDT == T024.MANDT
Storage Location
  • Storage Location
  • Plant
  • Client
  • C_MAINTORDCOMPPURORDERITEM.STORAGELOCATION == T001L.LGORT
  • C_MAINTORDCOMPPURORDERITEM.PLANT == T001L.WERKS
  • C_MAINTORDCOMPPURORDERITEM.MANDT == T001L.MANDT
Supplier
  • Supplier
  • Client
  • C_MAINTORDCOMPPURORDERITEM.SUPPLIER == LFA1.LIFNR
  • C_MAINTORDCOMPPURORDERITEM.MANDT == LFA1.MANDT
Object ID of the Work Center
  • ?
  • Object ID of the Work Center
  • Client
  • C_MAINTORDCOMPPURORDERITEM.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • C_MAINTORDCOMPPURORDERITEM.WORKCENTERINTERNALID == CRID.OBJID
  • C_MAINTORDCOMPPURORDERITEM.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
  • C_MAINTORDCOMPPURORDERITEM.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • C_MAINTORDCOMPPURORDERITEM.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • C_MAINTORDCOMPPURORDERITEM.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • C_MAINTORDCOMPPURORDERITEM.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • C_MAINTORDCOMPPURORDERITEM.MANDT == T399I.MANDT