P_MaintBacklogNonStkCompUnion

Maintenance Backlog Non Stock Component Union | view: PMBACKLOGCOMPUNI | TRAN | Extraction: Not supported | Component: Plant Maintenance
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, AFIH, AFKO, RESB, AFKO, AFVC, EAM_ORDPROCMLST, EBAN, EKKO, EKPO, EKKN, EBKN, RESB, JEST, PRTE, TKA01, T418, FM01, ILOA, AUFK, AUFK, RSADD, RSDB, AUFK, EAM_MOPEXCPHASEA, EAM_MOPEXCPHASET, RSDB, MARA, MAKT, 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
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
ScheduledBasicStartDate Scheduled start
ScheduledBasicStartTime Scheduled Start (Time)
ScheduledBasicEndDate Scheduled finish
ScheduledBasicEndTime Scheduled finish time
MaintOrdBasicStartDate Basic Start Date
MaintOrdBasicStartTime Basic Start (Time)
MaintOrdBasicEndDate Basic finish date
MaintOrdBasicEndTime Basic 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
ProcuredtFromCode null
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 Material Description 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
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
  • Client
  • Base Unit of Measure
  • P_MAINTBACKLOGNONSTKCOMPUNION.MANDT == T006.MANDT
  • P_MAINTBACKLOGNONSTKCOMPUNION.BASEUNIT == T006.MSEHI
Equipment Number
  • Client
  • Equipment Number
  • P_MAINTBACKLOGNONSTKCOMPUNION.MANDT == EQUI.MANDT
  • P_MAINTBACKLOGNONSTKCOMPUNION.EQUIPMENT == EQUI.EQUNR
Fixed Vendor
  • Fixed Vendor
  • Client
  • P_MAINTBACKLOGNONSTKCOMPUNION.FIXEDSUPPLIER == LFA1.LIFNR
  • P_MAINTBACKLOGNONSTKCOMPUNION.MANDT == LFA1.MANDT
Functional Location
  • Client
  • Functional Location
  • P_MAINTBACKLOGNONSTKCOMPUNION.MANDT == IFLOT.MANDT
  • P_MAINTBACKLOGNONSTKCOMPUNION.FUNCTIONALLOCATION == IFLOT.TPLNR
Movement type (inventory management)
  • Client
  • Movement type (inventory management)
  • P_MAINTBACKLOGNONSTKCOMPUNION.MANDT == T156.MANDT
  • P_MAINTBACKLOGNONSTKCOMPUNION.GOODSMOVEMENTTYPE == T156.BWART
Item category (bill of material)
  • Client
  • Item category (bill of material)
  • P_MAINTBACKLOGNONSTKCOMPUNION.MANDT == T418.MANDT
  • P_MAINTBACKLOGNONSTKCOMPUNION.ITEMCATEGORY == T418.POSTP
Order Number
  • Client
  • Order Number
  • P_MAINTBACKLOGNONSTKCOMPUNION.MANDT == AUFK.MANDT
  • P_MAINTBACKLOGNONSTKCOMPUNION.MAINTENANCEORDER == AUFK.AUFNR
Location Plant
  • Location Plant
  • Client
  • P_MAINTBACKLOGNONSTKCOMPUNION.MAINTENANCEPLANT == T001W.WERKS
  • P_MAINTBACKLOGNONSTKCOMPUNION.MANDT == T001W.MANDT
Material Number
  • Client
  • Material Number
  • Material Number
  • P_MAINTBACKLOGNONSTKCOMPUNION.MANDT == MARA.MANDT
  • P_MAINTBACKLOGNONSTKCOMPUNION.PRODUCT == MARA.MATNR
  • P_MAINTBACKLOGNONSTKCOMPUNION.MATERIAL == MARA.MATNR
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • Account Number of Supplier
  • Supplier
  • P_MAINTBACKLOGNONSTKCOMPUNION.MANDT == LFA1.MANDT
  • P_MAINTBACKLOGNONSTKCOMPUNION.OPERATIONSUPPLIER == LFA1.LIFNR
  • P_MAINTBACKLOGNONSTKCOMPUNION.PREFERREDSUPPLIER == LFA1.LIFNR
  • P_MAINTBACKLOGNONSTKCOMPUNION.PURCHASEORDERSUPPLIER == LFA1.LIFNR
Plant Section
  • ?
  • Plant Section
  • Client
  • P_MAINTBACKLOGNONSTKCOMPUNION.[column in domain "WERKS_D"] == T357.WERKS
  • P_MAINTBACKLOGNONSTKCOMPUNION.PLANTSECTION == T357.BEBER
  • P_MAINTBACKLOGNONSTKCOMPUNION.MANDT == T357.MANDT
Vendor
  • Client
  • Account Number of Supplier
  • Account Number of Supplier
  • Supplier
  • P_MAINTBACKLOGNONSTKCOMPUNION.MANDT == LFA1.MANDT
  • P_MAINTBACKLOGNONSTKCOMPUNION.OPERATIONSUPPLIER == LFA1.LIFNR
  • P_MAINTBACKLOGNONSTKCOMPUNION.PREFERREDSUPPLIER == LFA1.LIFNR
  • P_MAINTBACKLOGNONSTKCOMPUNION.PURCHASEORDERSUPPLIER == LFA1.LIFNR
Material Number
  • Client
  • Material Number
  • Material Number
  • P_MAINTBACKLOGNONSTKCOMPUNION.MANDT == MARA.MANDT
  • P_MAINTBACKLOGNONSTKCOMPUNION.PRODUCT == MARA.MATNR
  • P_MAINTBACKLOGNONSTKCOMPUNION.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_MAINTBACKLOGNONSTKCOMPUNION.MANDT == T023.MANDT
  • P_MAINTBACKLOGNONSTKCOMPUNION.PRODUCTGROUP == T023.MATKL
Material type
  • Material type
  • Client
  • P_MAINTBACKLOGNONSTKCOMPUNION.PRODUCTTYPE == T134.MTART
  • P_MAINTBACKLOGNONSTKCOMPUNION.MANDT == T134.MANDT
Product Type P_MAINTBACKLOGNONSTKCOMPUNION.PRODUCTTYPECODE == CMD_PRDTYPE.PROD_TYPE_CODE
Supplier
  • Client
  • Account Number of Supplier
  • Account Number of Supplier
  • Supplier
  • P_MAINTBACKLOGNONSTKCOMPUNION.MANDT == LFA1.MANDT
  • P_MAINTBACKLOGNONSTKCOMPUNION.OPERATIONSUPPLIER == LFA1.LIFNR
  • P_MAINTBACKLOGNONSTKCOMPUNION.PREFERREDSUPPLIER == LFA1.LIFNR
  • P_MAINTBACKLOGNONSTKCOMPUNION.PURCHASEORDERSUPPLIER == LFA1.LIFNR
Object ID of the Work Center
  • Client
  • ?
  • Object ID of the Work Center
  • P_MAINTBACKLOGNONSTKCOMPUNION.MANDT == CRID.MANDT
  • P_MAINTBACKLOGNONSTKCOMPUNION.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • P_MAINTBACKLOGNONSTKCOMPUNION.WORKCENTERINTERNALID == CRID.OBJID
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
  • P_MAINTBACKLOGNONSTKCOMPUNION.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • P_MAINTBACKLOGNONSTKCOMPUNION.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • P_MAINTBACKLOGNONSTKCOMPUNION.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • P_MAINTBACKLOGNONSTKCOMPUNION.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • P_MAINTBACKLOGNONSTKCOMPUNION.MANDT == T399I.MANDT