P_MaintPlngBcktOrder

Auxiliary View for Orders in Planning Bucket | view: PMNTPLGBKTORD | TRAN | Extraction: Not supported | Component: Plant Maintenance
Tables used: EAM_OSTOBJSTS, AFIH, AFKO, AFKO, AFVC, AFPO, JSTO, JEST, PRTE, ADCP, ADRC, IFLOS, IFLOT, ILOA, AUFK, AUFK, PROJ, PRPS, EAM_MOPEXCPHASE, EAM_MOPEXCPHASEC, T001W, TTZ5, TTZ5S, ITOBCUST, IFLOUSR
Column Name Description
MaintenanceOrder FK Order Number
Column Name Description
Column Name Description
Column Name Description
MaintOrdBasicStartDate Basic Start Date
MaintOrdBasicStartTime Basic Start (Time)
MaintOrdBasicEndDate Basic finish date
MaintOrdBasicEndTime Basic Finish (Time)
LatestAcceptableCompletionDate Final Due Date
ScheduledBasicStartDate Scheduled start
ScheduledBasicStartTime Scheduled Start (Time)
ScheduledBasicEndDate Scheduled finish
ScheduledBasicEndTime Scheduled finish time
Column Name Description
TechObjIsEquipOrFuncnlLoc Technical Object Type Show values
MaintOrderIsFinallyConfirmed Checkbox Show values
MaintenanceOrderPlanningCode Maintenance order planning indicator Show values
WorkCenterTypeCode Object Type of CIM Resources for Work Center Show values
MaintOrdProcessPhaseCode Process Phase Show values
Column Name Description Domain name
MaintOrderRoutingNumber Routing number of operations in the order AUFPL
MaintenanceOrderDesc Description TEXT40
TechnicalObject Functional Location TPLNR
TechnicalObjectLabel Technical Object Identifier EAMS_TECH_OBJ_CONV
MaintOrdPersonResponsible Person Responsible ID I_PARNR
SerialNumber Serial Number GERNR
MaintObjectFreeDefinedAttrib Sort Field CHAR30
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
MainWorkCenter Main work center for maintenance tasks ARBPL
MainWorkCenterPlant Plant associated with main work center WERKS
MaintOrdBasicStartDateTime Maintenance Order Basic Start Date and Time TZNTSTMPS
MaintOrdBasicEndDateTime Maintenance Order Basic End Date and Time TZNTSTMPS
MaintOrdCompAvailyCritltyCode null
MaintOrdStatusCriticalityCode null
MaintOrdProcessSubPhaseCode Process Subphase EAM_OSTAT_SPHASE
SchedldOrdStartDteTme Scheduled Start Date/Time TZNTSTMPS
SchedldOrdEndDteTme Scheduled End Date/Time TZNTSTMPS
NumberOfOrders null
MaintOrdHasOpenMainWork null
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
MaintOrdSchedCriticalityCode null
Master Data Relations | to Other Relations ↓ Join Conditions
ABC Indicator for Technical Object
  • Client
  • ABC Indicator for Technical Object
  • P_MAINTPLNGBCKTORDER.MANDT == T370C.MANDT
  • P_MAINTPLNGBCKTORDER.ABCINDICATOR == T370C.ABCKZ
Assembly
  • Client
  • Assembly
  • P_MAINTPLNGBCKTORDER.MANDT == MARA.MANDT
  • P_MAINTPLNGBCKTORDER.ASSEMBLY == MARA.MATNR
Overall Status
  • Client
  • Overall Status
  • Profile for Overall Status
  • P_MAINTPLNGBCKTORDER.MANDT == EAM_OSTAT.MANDT
  • P_MAINTPLNGBCKTORDER.EAMOVERALLOBJECTSTATUS == EAM_OSTAT.OVERALL_STATUS
  • P_MAINTPLNGBCKTORDER.EAMOVERALLOBJECTSTATUSPROFILE == EAM_OSTAT.OVERALL_STATUS_PROFILE
Profile for Overall Status
  • Client
  • Profile for Overall Status
  • P_MAINTPLNGBCKTORDER.MANDT == EAM_OSTPROF.MANDT
  • P_MAINTPLNGBCKTORDER.EAMOVERALLOBJECTSTATUSPROFILE == EAM_OSTPROF.OVERALL_STATUS_PROFILE
Equipment Number
  • Equipment Number
  • Client
  • P_MAINTPLNGBCKTORDER.EQUIPMENT == EQUI.EQUNR
  • P_MAINTPLNGBCKTORDER.MANDT == EQUI.MANDT
Functional Location
  • Client
  • Functional Location
  • P_MAINTPLNGBCKTORDER.MANDT == IFLOT.MANDT
  • P_MAINTPLNGBCKTORDER.FUNCTIONALLOCATION == IFLOT.TPLNR
Maintenance Activity Type
  • Client
  • Maintenance Activity Type
  • P_MAINTPLNGBCKTORDER.MANDT == T353I.MANDT
  • P_MAINTPLNGBCKTORDER.MAINTENANCEACTIVITYTYPE == T353I.ILART
Order Number
  • Client
  • Order Number
  • P_MAINTPLNGBCKTORDER.MANDT == AUFK.MANDT
  • P_MAINTPLNGBCKTORDER.MAINTENANCEORDER == AUFK.AUFNR
Order Type
  • Client
  • Order Type
  • P_MAINTPLNGBCKTORDER.MANDT == T003O.CLIENT
  • P_MAINTPLNGBCKTORDER.MAINTENANCEORDERTYPE == T003O.AUART
Location Plant
  • Client
  • Location Plant
  • P_MAINTPLNGBCKTORDER.MANDT == T001W.MANDT
  • P_MAINTPLNGBCKTORDER.MAINTENANCEPLANT == T001W.WERKS
Location and account assignment for technical object
  • Client
  • Location and account assignment for technical object
  • P_MAINTPLNGBCKTORDER.MANDT == ILOA.MANDT
  • P_MAINTPLNGBCKTORDER.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
Priority
  • Client
  • Priority Type
  • Priority
  • P_MAINTPLNGBCKTORDER.MANDT == T356.MANDT
  • P_MAINTPLNGBCKTORDER.MAINTPRIORITYTYPE == T356.ARTPR
  • P_MAINTPLNGBCKTORDER.MAINTPRIORITY == T356.PRIOK
Priority Type
  • Client
  • Priority Type
  • P_MAINTPLNGBCKTORDER.MANDT == T356A.MANDT
  • P_MAINTPLNGBCKTORDER.MAINTPRIORITYTYPE == T356A.ARTPR
Material Number for Order
  • Client
  • Material Number for Order
  • P_MAINTPLNGBCKTORDER.MANDT == MARA.MANDT
  • P_MAINTPLNGBCKTORDER.MATERIAL == MARA.MATNR
System Condition
  • System Condition
  • Client
  • P_MAINTPLNGBCKTORDER.OPERATIONSYSTEMCONDITION == T357M.ANLZU
  • P_MAINTPLNGBCKTORDER.MANDT == T357M.MANDT
Plant Section
  • Client
  • Plant Section
  • ?
  • P_MAINTPLNGBCKTORDER.MANDT == T357.MANDT
  • P_MAINTPLNGBCKTORDER.PLANTSECTION == T357.BEBER
  • P_MAINTPLNGBCKTORDER.[column in domain "WERKS_D"] == T357.WERKS
Object ID of the Work Center
  • Object ID of the Work Center
  • Client
  • Object Type of CIM Resources for Work Center
  • P_MAINTPLNGBCKTORDER.WORKCENTERINTERNALID == CRID.OBJID
  • P_MAINTPLNGBCKTORDER.MANDT == CRID.MANDT
  • P_MAINTPLNGBCKTORDER.WORKCENTERTYPECODE == 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_MAINTPLNGBCKTORDER.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • P_MAINTPLNGBCKTORDER.MANDT == T024I.MANDT
  • P_MAINTPLNGBCKTORDER.MAINTENANCEPLANNINGPLANT == T024I.IWERK
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • P_MAINTPLNGBCKTORDER.MANDT == T399I.MANDT
  • P_MAINTPLNGBCKTORDER.MAINTENANCEPLANNINGPLANT == T399I.IWERK