P_MaintPlngBcktResource

Auxiliary View for Resources in Planning Bucket | view: PMNTPLGBKTRSRCS | TRAN | Extraction: Not supported | Component: Plant Maintenance
Column Name Description
MaintenanceOrder FK Order Number
MaintenanceOrderOperation Operation/Activity Number
MaintenanceOrderSubOperation Operation/Activity Number
Column Name Description
Column Name Description
📏 null (HoursUnitOfMeasure):
ActualWorkInHours null
ForecastedWorkInHours null
RemainingWorkQuantityInHours null
PlannedWorkInHours null
OperationPlannedWork Work involved in the activity
📏 Unit for work (OperationPlannedWorkUnit):
ConfirmationTotalQuantity Actual work
ForecastedWorkQty Forecasted work (actual + remaining)
RemainingWorkQuantity null
Column Name Description
OpErlstSchedldExecStrtDte Earliest scheduled start: Execution (date)
OpErlstSchedldExecStrtTme Earliest scheduled start: Execution (time)
OpErlstSchedldExecEndDte Earliest scheduled finish: Execution (date)
OpErlstSchedldExecEndTme Earliest scheduled finish: Execution (time)
OpLtstSchedldExecStrtDte Latest scheduled start: Execution (date)
OpLtstSchedldExecStrtTme Latest scheduled start: Execution (time)
OpLtstSchedldExecEndDte Latest scheduled finish: Execution (date)
OpLtstSchedldExecEndTme Latest scheduled finish: Execution (time)
OpActualExecutionStartDate Actual Execution Start Date
OpActualExecutionStartTime Actual Execution Start Time
OpActualExecutionEndDate Actual Execution End Date
OpActualExecutionEndTime Actual Execution End Time
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)
Column Name Description
MaintOrdProcessPhaseCode Process Phase Show values
MaintOpExecStageGroupCode PRE MAIN POST - Grouping Show values
OperationHasLongText Checkbox Show values
WorkCenterTypeCode Object Type of CIM Resources for Work Center Show values
Column Name Description Domain name
MaintenanceOrderDesc Description TEXT40
OperationDescription Operation Short Text TEXT40
OperationWorkCenter Work Center ARBPL
WorkCenterText Work Center 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
NumberOfCapacities Number of capacities required INT1
WorkCenterUtilization null
CapacityRequirement ID of the Capacity Requirements Record BEDID
MaintOrderRoutingNumber Routing number of operations in the order AUFPL
MaintOrderOperationCounter General counter for order CO_APLZL
OperationPersonResponsible Personnel number PERNR
MainWorkCenter Main work center for maintenance tasks ARBPL
Master Data Relations | to Other Relations ↓ Join Conditions
Cost Element
  • Cost Element
  • Client
  • ?
  • P_MAINTPLNGBCKTRESOURCE.COSTELEMENT == CSKA.KSTAR
  • P_MAINTPLNGBCKTRESOURCE.MANDT == CSKA.MANDT
  • P_MAINTPLNGBCKTRESOURCE.[column in domain "KTOPL"] == CSKA.KTOPL
Equipment Number
  • Equipment Number
  • Client
  • P_MAINTPLNGBCKTRESOURCE.EQUIPMENT == EQUI.EQUNR
  • P_MAINTPLNGBCKTRESOURCE.MANDT == EQUI.MANDT
Functional Location
  • Client
  • Functional Location
  • P_MAINTPLNGBCKTRESOURCE.MANDT == IFLOT.MANDT
  • P_MAINTPLNGBCKTRESOURCE.FUNCTIONALLOCATION == IFLOT.TPLNR
Language Key P_MAINTPLNGBCKTRESOURCE.LANGUAGE == T002.SPRAS
Order Number
  • Order Number
  • Client
  • P_MAINTPLNGBCKTRESOURCE.MAINTENANCEORDER == AUFK.AUFNR
  • P_MAINTPLNGBCKTRESOURCE.MANDT == AUFK.MANDT
Order Type
  • Client
  • Order Type
  • P_MAINTPLNGBCKTRESOURCE.MANDT == T003O.CLIENT
  • P_MAINTPLNGBCKTRESOURCE.MAINTENANCEORDERTYPE == T003O.AUART
Location Plant
  • Client
  • Location Plant
  • P_MAINTPLNGBCKTRESOURCE.MANDT == T001W.MANDT
  • P_MAINTPLNGBCKTRESOURCE.MAINTENANCEPLANT == T001W.WERKS
Location and account assignment for technical object
  • Client
  • Location and account assignment for technical object
  • P_MAINTPLNGBCKTRESOURCE.MANDT == ILOA.MANDT
  • P_MAINTPLNGBCKTRESOURCE.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
Material Group
  • Client
  • Material Group
  • P_MAINTPLNGBCKTRESOURCE.MANDT == T023.MANDT
  • P_MAINTPLNGBCKTRESOURCE.MATERIALGROUP == T023.MATKL
Unit for work
  • Unit for work
  • Client
  • P_MAINTPLNGBCKTRESOURCE.OPERATIONPLANNEDWORKUNIT == T006.MSEHI
  • P_MAINTPLNGBCKTRESOURCE.MANDT == T006.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • P_MAINTPLNGBCKTRESOURCE.OPERATIONSUPPLIER == LFA1.LIFNR
  • P_MAINTPLNGBCKTRESOURCE.MANDT == LFA1.MANDT
Plant
  • Client
  • Plant
  • P_MAINTPLNGBCKTRESOURCE.MANDT == T001W.MANDT
  • P_MAINTPLNGBCKTRESOURCE.PLANT == T001W.WERKS
Plant Section
  • ?
  • Client
  • Plant Section
  • P_MAINTPLNGBCKTRESOURCE.[column in domain "WERKS_D"] == T357.WERKS
  • P_MAINTPLNGBCKTRESOURCE.MANDT == T357.MANDT
  • P_MAINTPLNGBCKTRESOURCE.PLANTSECTION == T357.BEBER
Purchasing Group for External Processing Activity
  • Client
  • Purchasing Group for External Processing Activity
  • P_MAINTPLNGBCKTRESOURCE.MANDT == T024.MANDT
  • P_MAINTPLNGBCKTRESOURCE.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • P_MAINTPLNGBCKTRESOURCE.PURCHASINGORGANIZATION == T024E.EKORG
  • P_MAINTPLNGBCKTRESOURCE.MANDT == T024E.MANDT
Object ID of the Work Center
  • Object ID of the Work Center
  • Client
  • Object Type of CIM Resources for Work Center
  • P_MAINTPLNGBCKTRESOURCE.WORKCENTERINTERNALID == CRID.OBJID
  • P_MAINTPLNGBCKTRESOURCE.MANDT == CRID.MANDT
  • P_MAINTPLNGBCKTRESOURCE.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_MAINTPLNGBCKTRESOURCE.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • P_MAINTPLNGBCKTRESOURCE.MANDT == T024I.MANDT
  • P_MAINTPLNGBCKTRESOURCE.MAINTENANCEPLANNINGPLANT == T024I.IWERK
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • P_MAINTPLNGBCKTRESOURCE.MANDT == T399I.MANDT
  • P_MAINTPLNGBCKTRESOURCE.MAINTENANCEPLANNINGPLANT == T399I.IWERK