P_MaintBacklogServiceUnion

Maintenance Backlog Service Union | view: PMBACKLOGSERVUNI | TRAN | Extraction: Not supported | Component: Plant Maintenance
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, AFIH, AFKO, RESB, AFKO, AFVC, EAM_ORDPROCMLST, AFVC, EBAN, EKKO, EKPO, EKKN, EBKN, PRTE, AFVC, AFVU, AFVV, TKA01, FM01, ILOA, AUFK, AUFK, RSADD, RSDB, AUFK, EAM_MOPEXCPHASEA, EAM_MOPEXCPHASET, RSDB, MARA, T430, T001W, PROJ, T000, T001K, PRPS, EAM_MOPEXCPHASE, EAM_MOPEXCPHASEC, MMPUR_C_BE_SYREG, FINSC_FISC_DATE
Column Name Description
MaintenanceOrder FK Order Number
MaintOrdProcurementDocument FK Object number
Column Name Description
💲 Currency Key (MaintOrdOpComponentCurrency):
OverallLimitAmount Overall Limit
ExpectedOverallLimitAmount Expected Value of Overall Limit
Column Name Description
📏 Base Unit of Measure (BaseUnit):
RequirementQuantityInBaseUnit Requirement Quantity
WithdrawnQuantity Withdrawn Quantity
ReceivedQuantity Withdrawn Quantity
Column Name Description
RequirementDate Requirements date for the component
PerformancePeriodStartDate Start Date for Period of Performance
PerformancePeriodEndDate End Date for Period of Performance
ScheduledBasicStartDate Scheduled start
ScheduledBasicStartTime Scheduled Start (Time)
ScheduledBasicEndDate Scheduled finish
ScheduledBasicEndTime Scheduled finish time
MaintOrdProcmtMilestoneDate Order Procurement Milestone Date
MaintOrdProcmtMlstnWarningDate Warning Date for Procurement Milestone
Column Name Description
MaintOrdProcessPhaseCode Process Phase Show values
IsCompletelyDelivered Final Issue for Reservation Show values
Column Name Description Domain name
MaintenanceOrderOperation Operation/Activity Number VORNR
MaintenanceOrderComponent BOM item number SPOSN
PurchaseRequisition Purchase Requisition Number BANFN
PurchaseOrderItem Item Number of Purchasing Document EBELP
MaintenanceOrderDesc Description TEXT40
MaintenanceOrderSubOperation Suboperation VORNR
OperationDescription Operation Short Text TEXT40
MaintOperationExecStageCode PRE MAIN POST EAM_PREMAINPOST_CDS
MaintOpExecStageShortText Description of Maintenance Operation Execution Stage TEXT30
MaintOpExecutionStageName Short Name of Maintenance Operation Execution Stage TEXT10
ComponentDescription BOM Item Text (Line 1) TEXT40
Supplier Account Number of Supplier LIFNR
Reservation Number of reservation/dependent requirements RSNUM
ReservationItem Item Number of Reservation / Dependent Requirements RSPOS
ReservationType Record type RSART
MaintOrdCompAvailyCritltyCode null
ServicePerformer Service Performer BU_PARTNER
MainWorkCenter Main work center for maintenance tasks ARBPL
MaintProcurementMilestone Procurement Milestone MAINTPROCUREMENTMILESTONE
MaintOrdProcurementDocType Procurement Document Type CHAR3
Master Data Relations | to Other Relations ↓ Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_MAINTBACKLOGSERVICEUNION.BASEUNIT == T006.MSEHI
  • P_MAINTBACKLOGSERVICEUNION.MANDT == T006.MANDT
Equipment Number
  • Client
  • Equipment Number
  • P_MAINTBACKLOGSERVICEUNION.MANDT == EQUI.MANDT
  • P_MAINTBACKLOGSERVICEUNION.EQUIPMENT == EQUI.EQUNR
Fixed Vendor
  • Client
  • Fixed Vendor
  • P_MAINTBACKLOGSERVICEUNION.MANDT == LFA1.MANDT
  • P_MAINTBACKLOGSERVICEUNION.FIXEDSUPPLIER == LFA1.LIFNR
Functional Location
  • Client
  • Functional Location
  • P_MAINTBACKLOGSERVICEUNION.MANDT == IFLOT.MANDT
  • P_MAINTBACKLOGSERVICEUNION.FUNCTIONALLOCATION == IFLOT.TPLNR
Movement type (inventory management)
  • Client
  • Movement type (inventory management)
  • P_MAINTBACKLOGSERVICEUNION.MANDT == T156.MANDT
  • P_MAINTBACKLOGSERVICEUNION.GOODSMOVEMENTTYPE == T156.BWART
Item category (bill of material)
  • Client
  • Item category (bill of material)
  • P_MAINTBACKLOGSERVICEUNION.MANDT == T418.MANDT
  • P_MAINTBACKLOGSERVICEUNION.ITEMCATEGORY == T418.POSTP
Order Number
  • Order Number
  • Client
  • P_MAINTBACKLOGSERVICEUNION.MAINTENANCEORDER == AUFK.AUFNR
  • P_MAINTBACKLOGSERVICEUNION.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • P_MAINTBACKLOGSERVICEUNION.MAINTENANCEORDERTYPE == T003O.AUART
  • P_MAINTBACKLOGSERVICEUNION.MANDT == T003O.CLIENT
Location Plant
  • Client
  • Location Plant
  • P_MAINTBACKLOGSERVICEUNION.MANDT == T001W.MANDT
  • P_MAINTBACKLOGSERVICEUNION.MAINTENANCEPLANT == T001W.WERKS
Location and account assignment for technical object
  • Client
  • Location and account assignment for technical object
  • P_MAINTBACKLOGSERVICEUNION.MANDT == ILOA.MANDT
  • P_MAINTBACKLOGSERVICEUNION.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
Currency Key
  • Client
  • Currency Key
  • P_MAINTBACKLOGSERVICEUNION.MANDT == TCURC.MANDT
  • P_MAINTBACKLOGSERVICEUNION.MAINTORDOPCOMPONENTCURRENCY == TCURC.WAERS
Material Number
  • Material Number
  • Material Number
  • Client
  • P_MAINTBACKLOGSERVICEUNION.PRODUCT == MARA.MATNR
  • P_MAINTBACKLOGSERVICEUNION.MATERIAL == MARA.MATNR
  • P_MAINTBACKLOGSERVICEUNION.MANDT == MARA.MANDT
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • Supplier
  • Account Number of Supplier
  • P_MAINTBACKLOGSERVICEUNION.MANDT == LFA1.MANDT
  • P_MAINTBACKLOGSERVICEUNION.PREFERREDSUPPLIER == LFA1.LIFNR
  • P_MAINTBACKLOGSERVICEUNION.PURCHASEORDERSUPPLIER == LFA1.LIFNR
  • P_MAINTBACKLOGSERVICEUNION.OPERATIONSUPPLIER == LFA1.LIFNR
Plant Section
  • Client
  • Plant Section
  • ?
  • P_MAINTBACKLOGSERVICEUNION.MANDT == T357.MANDT
  • P_MAINTBACKLOGSERVICEUNION.PLANTSECTION == T357.BEBER
  • P_MAINTBACKLOGSERVICEUNION.[column in domain "WERKS_D"] == T357.WERKS
Vendor
  • Client
  • Account Number of Supplier
  • Supplier
  • Account Number of Supplier
  • P_MAINTBACKLOGSERVICEUNION.MANDT == LFA1.MANDT
  • P_MAINTBACKLOGSERVICEUNION.PREFERREDSUPPLIER == LFA1.LIFNR
  • P_MAINTBACKLOGSERVICEUNION.PURCHASEORDERSUPPLIER == LFA1.LIFNR
  • P_MAINTBACKLOGSERVICEUNION.OPERATIONSUPPLIER == LFA1.LIFNR
Material Number
  • Material Number
  • Material Number
  • Client
  • P_MAINTBACKLOGSERVICEUNION.PRODUCT == MARA.MATNR
  • P_MAINTBACKLOGSERVICEUNION.MATERIAL == MARA.MATNR
  • P_MAINTBACKLOGSERVICEUNION.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_MAINTBACKLOGSERVICEUNION.PRODUCTGROUP == T023.MATKL
  • P_MAINTBACKLOGSERVICEUNION.MANDT == T023.MANDT
Material type
  • Client
  • Material type
  • P_MAINTBACKLOGSERVICEUNION.MANDT == T134.MANDT
  • P_MAINTBACKLOGSERVICEUNION.PRODUCTTYPE == T134.MTART
Product Type P_MAINTBACKLOGSERVICEUNION.PRODUCTTYPECODE == CMD_PRDTYPE.PROD_TYPE_CODE
Supplier
  • Client
  • Account Number of Supplier
  • Supplier
  • Account Number of Supplier
  • P_MAINTBACKLOGSERVICEUNION.MANDT == LFA1.MANDT
  • P_MAINTBACKLOGSERVICEUNION.PREFERREDSUPPLIER == LFA1.LIFNR
  • P_MAINTBACKLOGSERVICEUNION.PURCHASEORDERSUPPLIER == LFA1.LIFNR
  • P_MAINTBACKLOGSERVICEUNION.OPERATIONSUPPLIER == LFA1.LIFNR
Object ID of the Work Center
  • Client
  • Object ID of the Work Center
  • ?
  • P_MAINTBACKLOGSERVICEUNION.MANDT == CRID.MANDT
  • P_MAINTBACKLOGSERVICEUNION.WORKCENTERINTERNALID == CRID.OBJID
  • P_MAINTBACKLOGSERVICEUNION.[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_MAINTBACKLOGSERVICEUNION.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • P_MAINTBACKLOGSERVICEUNION.MANDT == T024I.MANDT
  • P_MAINTBACKLOGSERVICEUNION.MAINTENANCEPLANNINGPLANT == T024I.IWERK
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • P_MAINTBACKLOGSERVICEUNION.MANDT == T399I.MANDT
  • P_MAINTBACKLOGSERVICEUNION.MAINTENANCEPLANNINGPLANT == T399I.IWERK