P_WorkRequestOrderUnion

Private view for Order and Notification | view: PREQORDUNION | Extraction: Not supported | Component: Plant Maintenance
Tables used: QMEL, AFIH, AFKO, QMIH, JEST, T370C, BUT000, EQUI, EQKT, EQUZ, IFLOS, IFLOT, IFLOTX, T499S, ILOA, AUFK, T001W, ADCP, ADR6, ADRC, ADRP, USR21, CRHD, ADR2, ADR2, ITOBCUST, IFLOUSR
Column Name Description
MaintExecutionObject FK Maintenance Execution Object
MaintExecutionObjectType Maintenance Execution Object Type Show values
Column Name Description
Column Name Description
Column Name Description
CreationDate Created On
RequiredStartDate Basic Start Date
RequiredEndDate Basic finish date
LatestAcceptableCompletionDate Final Due Date
ScheduledBasicStartDate Scheduled start
ScheduledBasicStartTime Scheduled Start (Time)
NotificationCreationDate Date of Notification
MalfunctionStartDate Start of Malfunction (Date)
Column Name Description
MaintExecutionObjectType Maintenance Execution Object Type Show values
TechObjIsEquipOrFuncnlLoc Technical Object Type Show values
WorkCenterTypeCode Object Type of CIM Resources for Work Center Show values
MaintenanceProcessingPhase Maintenance Processing Phase Show values
NotificationHasLongText Order Has Long Text Show values
MaintenanceObjectIsDown Breakdown Indicator Show values
MaintOrdProcessPhaseCode Process Phase Show values
Column Name Description Domain name
TechnicalObject Technical Object EAMS_TEC_OBJ
TechnicalObjectLabel Technical Object Identifier EAMS_TECH_OBJ_ALPHA_CONV
TechnicalObjectDescription Technical Object Description TEXT40
SuperiorFunctionalLocation Functional Location
SuperiorTechnicalObjectName Description of functional location TEXT40
MaintenanceItem Maintenance item POSNU
MainWorkCenter Main work center for maintenance tasks ARBPL
MaintenanceWorkCenterPlant Plant associated with main work center WERKS
MalfunctionEffect Effect on Operation AUSWK
CreatedByUser Entered By USNAM
PersonResponsible Person Responsible ID I_PARNR
ReportedByUser Name of Person Reporting Notification USNAM
ReporterFullName Full Name of Person TEXT80
SerialNumber Serial Number GERNR
NotificationType Notification Type QMART
DocumentText Description TEXT40
MaintNotificationCode Coding QCODE
MaintNotificationCodeGroup Code Group - Coding QCODEGRP
MaintNotificationCatalog Catalog Type - Coding QKATART
LocationName Location Name TEXT40
MaintObjectFreeDefinedAttrib Sort Field CHAR30
ABCIndicator ABC Indicator for Technical Object ABCKZ
MaintNotifInternalID Object Number for Status Management J_OBJNR
MaintOrdProcessSubPhaseCode Process Subphase EAM_OSTAT_SPHASE
FunctionalLocationName Functional Location Label ILOM_STRNO
FunctionalLocationLabelName Description of functional location TEXT40
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
PlantName Plant Name TEXT30
Master Data Relations | to Other Relations ↓ Join Conditions
Assembly
  • Assembly
  • Client
  • P_WORKREQUESTORDERUNION.ASSEMBLY == MARA.MATNR
  • P_WORKREQUESTORDERUNION.MANDT == MARA.MANDT
Location of maintenance object
  • Location of maintenance object
  • Client
  • Maintenance Plant
  • P_WORKREQUESTORDERUNION.ASSETLOCATION == T499S.STAND
  • P_WORKREQUESTORDERUNION.MANDT == T499S.MANDT
  • P_WORKREQUESTORDERUNION.MAINTENANCEPLANT == T499S.WERKS
Order Currency
  • Order Currency
  • Client
  • P_WORKREQUESTORDERUNION.CURRENCY == TCURC.WAERS
  • P_WORKREQUESTORDERUNION.MANDT == TCURC.MANDT
Equipment Number
  • Equipment Number
  • Client
  • P_WORKREQUESTORDERUNION.EQUIPMENT == EQUI.EQUNR
  • P_WORKREQUESTORDERUNION.MANDT == EQUI.MANDT
Functional Location
  • Functional Location
  • Client
  • P_WORKREQUESTORDERUNION.FUNCTIONALLOCATION == IFLOT.TPLNR
  • P_WORKREQUESTORDERUNION.MANDT == IFLOT.MANDT
Maintenance Activity Type
  • Client
  • Maintenance Activity Type
  • P_WORKREQUESTORDERUNION.MANDT == T353I.MANDT
  • P_WORKREQUESTORDERUNION.MAINTENANCEACTIVITYTYPE == T353I.ILART
Order Number
  • Maintenance Execution Object
  • Order Number
  • Settlement order
  • Client
  • P_WORKREQUESTORDERUNION.MAINTEXECUTIONOBJECT == AUFK.AUFNR
  • P_WORKREQUESTORDERUNION.MAINTENANCEORDER == AUFK.AUFNR
  • P_WORKREQUESTORDERUNION.SETTLEMENTORDER == AUFK.AUFNR
  • P_WORKREQUESTORDERUNION.MANDT == AUFK.MANDT
Maintenance Plant
  • Client
  • Maintenance Plant
  • P_WORKREQUESTORDERUNION.MANDT == T001W.MANDT
  • P_WORKREQUESTORDERUNION.MAINTENANCEPLANT == T001W.WERKS
Maintenance Execution Object
  • Maintenance Execution Object
  • Order Number
  • Settlement order
  • Client
  • P_WORKREQUESTORDERUNION.MAINTEXECUTIONOBJECT == AUFK.AUFNR
  • P_WORKREQUESTORDERUNION.MAINTENANCEORDER == AUFK.AUFNR
  • P_WORKREQUESTORDERUNION.SETTLEMENTORDER == AUFK.AUFNR
  • P_WORKREQUESTORDERUNION.MANDT == AUFK.MANDT
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • P_WORKREQUESTORDERUNION.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • P_WORKREQUESTORDERUNION.MANDT == ILOA.MANDT
Priority
  • Client
  • Priority Type
  • Priority
  • P_WORKREQUESTORDERUNION.MANDT == T356.MANDT
  • P_WORKREQUESTORDERUNION.MAINTPRIORITYTYPE == T356.ARTPR
  • P_WORKREQUESTORDERUNION.MAINTPRIORITY == T356.PRIOK
Priority Type
  • Client
  • Priority Type
  • P_WORKREQUESTORDERUNION.MANDT == T356A.MANDT
  • P_WORKREQUESTORDERUNION.MAINTPRIORITYTYPE == T356A.ARTPR
Material Number
  • Client
  • Material Number
  • P_WORKREQUESTORDERUNION.MANDT == MARA.MANDT
  • P_WORKREQUESTORDERUNION.MATERIAL == MARA.MATNR
System Condition
  • Client
  • System Condition
  • P_WORKREQUESTORDERUNION.MANDT == T357M.MANDT
  • P_WORKREQUESTORDERUNION.OPERATIONSYSTEMCONDITION == T357M.ANLZU
Order Type
  • Client
  • Order Type
  • P_WORKREQUESTORDERUNION.MANDT == T003O.CLIENT
  • P_WORKREQUESTORDERUNION.ORDERTYPE == T003O.AUART
Plant Section
  • Plant Section
  • Client
  • Maintenance Plant
  • P_WORKREQUESTORDERUNION.PLANTSECTION == T357.BEBER
  • P_WORKREQUESTORDERUNION.MANDT == T357.MANDT
  • P_WORKREQUESTORDERUNION.MAINTENANCEPLANT == T357.WERKS
Responsible Cost Center
  • ?
  • Responsible Cost Center
  • Client
  • ?
  • P_WORKREQUESTORDERUNION.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_WORKREQUESTORDERUNION.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • P_WORKREQUESTORDERUNION.MANDT == CSKS.MANDT
  • P_WORKREQUESTORDERUNION.[column in domain "DATBI"] == CSKS.DATBI
Settlement order
  • Maintenance Execution Object
  • Order Number
  • Settlement order
  • Client
  • P_WORKREQUESTORDERUNION.MAINTEXECUTIONOBJECT == AUFK.AUFNR
  • P_WORKREQUESTORDERUNION.MAINTENANCEORDER == AUFK.AUFNR
  • P_WORKREQUESTORDERUNION.SETTLEMENTORDER == AUFK.AUFNR
  • P_WORKREQUESTORDERUNION.MANDT == AUFK.MANDT
Object ID of the Work Center
  • Object Type of CIM Resources for Work Center
  • Client
  • Object ID of the Work Center
  • P_WORKREQUESTORDERUNION.WORKCENTERTYPECODE == CRID.OBJTY
  • P_WORKREQUESTORDERUNION.MANDT == CRID.MANDT
  • P_WORKREQUESTORDERUNION.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
  • Client
  • Maintenance Planning Plant
  • P_WORKREQUESTORDERUNION.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • P_WORKREQUESTORDERUNION.MANDT == T024I.MANDT
  • P_WORKREQUESTORDERUNION.MAINTENANCEPLANNINGPLANT == T024I.IWERK
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • P_WORKREQUESTORDERUNION.MANDT == T399I.MANDT
  • P_WORKREQUESTORDERUNION.MAINTENANCEPLANNINGPLANT == T399I.IWERK