P_MaintOrdDirectProcmtViaPO

Purchase Orders for Direct Procurement | view: PMTORDPROMTPO | Extraction: Not supported | Component: Plant Maintenance
Tables used: AFKO, AFKO, AFIH, AFKO, RESB, AFVV, EKKO, EKPO, EKKN, EKET, AFVC, AFVU, AFVV, TKA01, ILOA, AUFK, AUFK, AUFK, RSADD, RSDB, RSDB, T430, T356, T356_T, T000
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchasing Document
Column Name Description
💲 Currency Key (DocumentCurrency):
NetAmount Net Order Value in PO Currency
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity Purchase Order Quantity
ReceivedQuantity Quantity of Goods Received
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
PurchasingProcessingStatus Purchasing document processing state Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
Column Name Description Domain name
PurchaseRequisition Purchasing Document Number EBELN
PurchaseRequisitionItem Item Number of Purchasing Document EBELP
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
OperationText 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
ProductType Product Type Group CHAR2
PurchaseOrderItemText Short Text TEXT40
MaintOrdComponentIsMissing null
Master Data Relations | to Other Relations ↓ Join Conditions
Currency Key
  • Client
  • Currency Key
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == TCURC.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPO.DOCUMENTCURRENCY == TCURC.WAERS
Equipment Number
  • Client
  • Equipment Number
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == EQUI.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPO.EQUIPMENT == EQUI.EQUNR
Functional Location
  • Client
  • Functional Location
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == IFLOT.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPO.FUNCTIONALLOCATION == IFLOT.TPLNR
Order Number
  • Order Number
  • Client
  • P_MAINTORDDIRECTPROCMTVIAPO.MAINTENANCEORDER == AUFK.AUFNR
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == AUFK.MANDT
Order Type
  • Client
  • Order Type
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == T003O.CLIENT
  • P_MAINTORDDIRECTPROCMTVIAPO.MAINTENANCEORDERTYPE == T003O.AUART
Location Plant
  • Location Plant
  • Client
  • P_MAINTORDDIRECTPROCMTVIAPO.MAINTENANCEPLANT == T001W.WERKS
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == T001W.MANDT
Revision for Plant Maintenance and Customer Service
  • Client
  • Revision for Plant Maintenance and Customer Service
  • Maintenance Planning Plant
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == T352R.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPO.MAINTENANCEREVISION == T352R.REVNR
  • P_MAINTORDDIRECTPROCMTVIAPO.MAINTENANCEPLANNINGPLANT == T352R.IWERK
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • P_MAINTORDDIRECTPROCMTVIAPO.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == ILOA.MANDT
Priority
  • Priority Type
  • Client
  • Priority
  • P_MAINTORDDIRECTPROCMTVIAPO.MAINTPRIORITYTYPE == T356.ARTPR
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == T356.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPO.MAINTPRIORITY == T356.PRIOK
Priority Type
  • Priority Type
  • Client
  • P_MAINTORDDIRECTPROCMTVIAPO.MAINTPRIORITYTYPE == T356A.ARTPR
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == T356A.MANDT
Material Number
  • Client
  • Material Number
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == MARA.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPO.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == T023.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPO.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == T001W.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPO.PLANT == T001W.WERKS
Plant Section
  • Plant Section
  • Client
  • ?
  • P_MAINTORDDIRECTPROCMTVIAPO.PLANTSECTION == T357.BEBER
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == T357.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPO.[column in domain "WERKS_D"] == T357.WERKS
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == T006.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPO.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchasing Group
  • Client
  • Purchasing Group
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == T024.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPO.PURCHASINGGROUP == T024.EKGRP
Storage Location
  • Storage Location
  • Client
  • Plant
  • P_MAINTORDDIRECTPROCMTVIAPO.STORAGELOCATION == T001L.LGORT
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == T001L.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPO.PLANT == T001L.WERKS
Supplier
  • Client
  • Supplier
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == LFA1.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPO.SUPPLIER == LFA1.LIFNR
Object ID of the Work Center
  • Object ID of the Work Center
  • ?
  • Client
  • P_MAINTORDDIRECTPROCMTVIAPO.WORKCENTERINTERNALID == CRID.OBJID
  • P_MAINTORDDIRECTPROCMTVIAPO.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == CRID.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Client
  • Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == T024I.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPO.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • P_MAINTORDDIRECTPROCMTVIAPO.MAINTENANCEPLANNINGPLANT == T024I.IWERK
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • P_MAINTORDDIRECTPROCMTVIAPO.MANDT == T399I.MANDT
  • P_MAINTORDDIRECTPROCMTVIAPO.MAINTENANCEPLANNINGPLANT == T399I.IWERK